import pandas as pd
#string to show exporting data to csv
''' df.to_csv( filepath_or_buffer:path to story to sep = ',':column separator columns:list needed to export header = True:Specify column names of new datas,also support list index = True :if or not export index mode = 'w':python's write mode , modes: r r+ w w+ a a+ encoding = 'utf-8'encoding format of data ) '''
#code to show exporting data to excel
df1 = pd.read_csv('123.csv',encoding = 'utf-8')
df2 = pd.read_csv('123.csv',encoding = 'utf-8')
writer = pd.ExcelWriter('output.xlsx')
df1.to_excel(writer,'Sheet1')
df2.to_excel(writer,'Sheet2')
writer.save()
还没有评论,来说两句吧...