Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import os
- import time
- import pandas as pd
- import xlwt
- from xlwt.Workbook import *
- from pandas import ExcelWriter
- import xlsxwriter
- #set folder to import files from
- path = r'path to some file'
- #folder = os.listdir(path)
- #for loop goes here
- #get date
- date = time.strftime('%Y-%m-%d',time.gmtime(os.path.getmtime(path)))
- #import excel document
- original = pd.DataFrame()
- data = pd.DataFrame()
- original = pd.read_excel(path,sheetname='Leave',skiprows=26)
- data = pd.read_excel(path,sheetname='Leave',skiprows=26)
- print (data.shape)
- data.fillna(method='ffill',inplace=True)
- #the code for creating the workbook and worksheets
- wb= Workbook()
- ws1 = wb.add_sheet('original')
- ws2 = wb.add_sheet('result')
- original.to_excel(writer,'original')
- data.to_excel(writer,'result')
- writer.save('final.xls')
- import pandas as pd
- df1 = pd.DataFrame({'Data': ['a', 'b', 'c', 'd']})
- df2 = pd.DataFrame({'Data': [1, 2, 3, 4]})
- df3 = pd.DataFrame({'Data': [1.1, 1.2, 1.3, 1.4]})
- writer = pd.ExcelWriter('multiple.xlsx', engine='xlsxwriter')
- df1.to_excel(writer, sheet_name='Sheeta')
- df2.to_excel(writer, sheet_name='Sheetb')
- df3.to_excel(writer, sheet_name='Sheetc')
- writer.save()
Add Comment
Please, Sign In to add comment