Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def save_xlsx():
- list_one = pd.read_csv('output1.csv', 'r',)
- df1 = pd.DataFrame(list_one)
- list_two = pd.read_csv('output2.csv', 'r')
- df2 = pd.DataFrame(list_two)
- writer = pd.ExcelWriter('new.xlsx', engine='xlsxwriter')
- df1.to_excel(writer, sheet_name='list_one')
- df2.to_excel(writer, sheet_name='list_two')
- writer.save()
Advertisement
Add Comment
Please, Sign In to add comment