pandas中行列转换 pivot 和melt

stocks = ['000625.SZ','601225.SH','600115.SH','601318.SH']  #,'601318.SH','600688.SH','600398.SH','000629.SZ'
stocksprices = shareprices[shareprices['s_info_windcode'].isin(stocks)]

df = stocksprices.sort_values(['s_info_windcode','trade_dt'],ascending=False)

df = df[['s_info_windcode','trade_dt', 's_dq_adjpreclose']]

df1 = df.copy()
df1.set_index(['s_info_windcode','trade_dt'],inplace=True)

df2 = df1.unstack(0)

df3 = pd.DataFrame(df2['s_dq_adjpreclose'])　

关键在于set_index后，unstack(0)

pivot和melt用法
如图想行转列的话，操作如下，列转行也一同，用melt反向操作即可

 

 1、行转列 pivot操作

 

 2、列转行 melt操作