我的数据帧1如下所示:
ID group_1 area_1 group_2 area_2 group_3 area_3
1 basketball 250 scoccer 500 swimming 100
2 volleyball 100 np.nan np.nan np.nan np.nan
3 football 10 basketball 1000 np.nan np.nan
我有另一个DF2看起来像这样
ID group_1 area_1 group_2 area_2 group_3 area_3 group_4 area_4
1 scoccer 500 basketball 50 basketball 200 swimming 100
2 volleyball np.nan np.nan np.nan np.nan np.nan np.nan np.nan
3 basketball 1000 basketball np.nan football 10 np.nan np.nan
我想要的输出应该如下所示:
ID group_1 area_1 group_2 area_2 group_3 area_3
1 scoccer 500 basketball 250 swimming 100
2 volleyball 100 np.nan np.nan np.nan np.nan
3 basketball 1000 football 10 np.nan np.nan
我想用DF2中的结构来安排DF1,这意味着作为第一步,我需要确定DF2中独特的水平表达式(scoccer、篮球、游泳),其中安排很重要。然后按此排列对DF1进行排序(但保留区域_x的正确值)
编辑: 答案为@kait时,最终的_df如下所示:
ID group_1 area_1 group_2 group_3 area_3 group_4 group_5 area_5 group_6
1 scoccer 500 500 basketball 250 250 swimming 100 100
2 volleyball 100 100 np.nan np.nan np.nan np.nan np.nan np.nan
3 basketball 1000 1000 football 10 10 np.nan np.nan np.nan
这行吗
首先,重塑df1
接下来,解析df2:
相关问题 更多 >
编程相关推荐