FlyWithMe

Untitled

Sep 25th, 2020
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.36 KB | None | 0 0
  1. def save_xlsx():
  2.     list_one = pd.read_csv('output1.csv', 'r',)
  3.     df1 = pd.DataFrame(list_one)
  4.  
  5.     list_two = pd.read_csv('output2.csv', 'r')
  6.     df2 = pd.DataFrame(list_two)
  7.  
  8.     writer = pd.ExcelWriter('new.xlsx', engine='xlsxwriter')
  9.     df1.to_excel(writer, sheet_name='list_one')
  10.     df2.to_excel(writer, sheet_name='list_two')
  11.     writer.save()
Advertisement
Add Comment
Please, Sign In to add comment