求助大神 ,如何能把df的列值变成股票代码,然后做相关分析


data = pro.stock_basic(exchange='', list_status='L', fields='ts_code,symbol,name,area,industry,list_date')
bank=data[data['industry']=='银行']
bank1=bank['ts_code'].tolist()
for i in bank1:
    stk = pro.daily(ts_code=i, start_date=20170101, end_date='')
    #print(stk['close'])
    df = pd.DataFrame()
    #stk = pd.DataFrame()
    stk['return'] = stk['close'].pct_change()
    #print(stk)
    #print(stk['return'])
    #print(stk['return'])
    df = pd.DataFrame()
    df[i] = stk['return']
    print(df)

     000001.SZ
0          NaN
1     0.002519
2    -0.017085
3    -0.071063
4     0.023665
..         ...
974   0.000000
975  -0.002186
976   0.004381
977  -0.001091
978   0.000000

[979 rows x 1 columns]
     002142.SZ
0          NaN
1    -0.007979
2    -0.007775
3    -0.041340
4    -0.015220
..         ...
974   0.000571
975  -0.014849
976   0.004058
977   0.010970
978  -0.006282

 

 

 

pandas中的T属性或者transpose函数就是实现行转列的功能,准确地说就是转置