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  陈丙丁  阅读(159)  评论(0)  编辑  收藏  举报