给出DataFrames的以下命令:
{
"01_2012":
"Acc" "B" "F"
"011" 23 43
"012" 4324 432
"01_2013":
"Acc" "B" " F"
"011" 23 224
"012" 4324 453,
"01_2014":
"Acc" "B" " F"
"011" 23 312
"012" 4324 500
"013: 4322 2120
}
是否可以合并“ Acc”键上的所有数据框,并将dict键名称添加到其他列?
因此最终结果将是:
"Acc" "B_01_2012" "F_01_2012" "B_01_2013" "F_01_2013" "B_01_2014" "F_01_2014"
"011" 23 43 ...
"012" 4324 432
"013" Nan Nan Nan Nan 4322 2120
看起来您可以做一个concat:
pd.concat([d.set_index('Acc') for d in df_dicts.values()],
keys=df_dicts.keys, axis=1)
要么
pd.concat([d.set_index('Acc').add_suffix(f'_{k}')
for k,d in df_dicts.items()],
axis=1)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句