pandas 数据合并，索引排序

pandas 数据合并写入exc的时候会出现列按照字母顺序排列，下面是2种解决方法

1、让本列重新排序

df3 = pd.DataFrame(df3,columns = ['date','open','high','close','low','volume','price_change','p_change','ma5','ma10','ma20','v_ma5','v_ma10','v_ma20','turnover'])  

2、写入exc的时候排序

c=['date','open','high','close','low','volume','price_change','p_change','ma5','ma10','ma20','v_ma5','v_ma10','v_ma20','turnover']

df3.to_excel(writer,'Sheet1',columns=c)