1,打开: data=pd.read_csv('data_etr.csv',parse_dates=['DATA_DATE'],encoding='gbk')
data.head()
data=pd.read_excel('data/meal_order_detail.xlsx',sheet_name='meal_order_detail1)
2,透明表:pd.pivot_table(data=data,values='KWH',index='CONS_NO',columns='DATA_DATE')
(行列值)
3,堆叠:pd.concat([df1,fd2],axis=0,join=’inner’) #0是纵,1是横,‘inner’是交集,‘outer’是并集
4,记录重复: