excel行列转置 

1 import pandas as pd
2 
3 data = pd.read_excel("dataProcess.xlsx")
4 
5 dReverse = pd.melt(data,id_vars=["catalogA","catalogB"],value_vars=["2000 [YR2000]","2001 [YR2001]"])
6 dReverse.to_csv("test.csv")

 

posted @ 2016-08-22 15:00  陈丙丁  阅读(173)  评论(0)    收藏  举报