例2.38数据写入文件示例

import pandas as pd
import numpy as np
datas = pd.date_range(start='20191101',end='20191124',freq='D')
a1 = pd.DataFrame(np.random.randn(24,4),index = datas,columns=list('ABCD'))
a2 = pd.DataFrame(np.random.randn(24,4))
a1.to_excel('data2_28_1.xlsx')
a2.to_csv('data2_38_3.csv')
f = pd.ExcelWriter('data2_38_3.xlsx')
a1.to_excel(f,"Sheet1")
a2.to_excel(f,"Sheet2")
f.save()

print("学号：3008")