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