df_target = pd.DataFrame(df_pct[(df_pct.ts_code == code)].sort_values(by=[‘date’],ascending=False))
df_xiang = pd.DataFrame(df_target[‘ts_code’].head(1))
df_hebing = pd.merge(df_pct,pivot_df,on=[‘date’],how=’inner’)
df_hebing = df_hebing[:-1]
df_corr = pd.DataFrame(df_hebing.corr()[‘pct_chg’]).sort_values(by=[‘pct_chg’],ascending=False)
df_corr.index.name=’var’
df_corr = df_corr.reset_index()
var = df_corr[‘var’].values[1]#实际是第二行
df_corr_2 = pd.DataFrame(df_corr[‘var’].iloc[[1]])
df21 = df_xiang.reset_index()[[‘ts_code’]]
df22 = df_corr_2.reset_index()[[‘var’]]
df33 = pd.DataFrame(pd.concat([df21,df22],axis=1))
data = data.append(df33)
一是要reset_index,一是要concat，不然都会错
Original: https://blog.csdn.net/sphinxrascal168/article/details/123945495
Author: sphinxrascal168
Title: 把两个毫不相关dataframe中的字段合并在一起
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/742325/
转载文章受原作者版权保护。转载请注明原作者出处！