pandas中行列转换

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)