如何使用pandas编码来转换这个名为df1的数据帧
index,client1,client2
name,bob,erika
email,gmail,yahoo
house_A,Paris,London
house_B,London,Milan
house_C,Berlin,Paris
code_name_A,Vaugirard,Windsor
code_name_B,Great,Brera
code_name_C,Mauer,Elysee
visa_id_num_A,FR001B,UK001E
visa_id_num_B,UK001B,IT001E
visa_id_num_C,GE001B,FR001E
food_A,apples,burgers
food_B,bananas,fries
food_C,burgers,pizzas
food_D,fries,oranges
food_E,pizzas,pears
这个数据帧称为df2
index,FR001B,UK001B,GE001B,UK001E,IT001E,FR001E
client_number,client1,client1,client1,client2,client2,client2
name,bob,bob,bob,erika,erika,erika
email,gmail,gmail,gmail,yahoo,yahoo,yahoo
house,Paris,London,Berlin,London,Milan,Paris
code_name,Vaugirard,Great,Mauer,Windsor,Brera,Elysee
visa_id_num,FR001B,UK001B,GE001B,UK001E,IT001E,FR001E
food_A,apples,apples,apples,burgers,burgers,burgers
food_B,bananas,bananas,bananas,fries,fries,fries
food_C,burgers,burgers,burgers,pizzas,pizzas,pizzas
food_D,fries,fries,fries,oranges,oranges,oranges
food_E,pizzas,pizzas,pizzas,pears,pears,pears
我需要拆分索引值并用新值替换特定的索引值。我试过用stack,unstack和groupby,但是很乱。你知道吗
非常感谢
让我们尝试一下,使用
T
、pd.wide_to_long
来处理多个“熔体”,以及set_index
:输出:
相关问题 更多 >
编程相关推荐