add missing date index in dataframe,df.to_csv('test.csv')