我需要根据引用dict重命名并重复我的dataframe列。下面我创建了一个虚拟的dataframe:
rawdata= {'id':['json','molly','tina','jake','molly'],'entity':['present','absent','absent','present','present'],'entity2':['present','present','present','absent','absent'],'entity3':['absent','absent','absent','present','absent']}
df= pd.DataFrame(rawdata)
df.set_index('id')
entity entity2 entity3
id
json present present absent
molly absent present absent
tina absent present absent
jake present absent present
molly present absent absent
现在我有了以下dict示例:
^{pr2}$我现在需要替换基于dict值的列名,如果一个列有多个值,则应该重复该列。以下是我想要的数据帧:
entity_exp1 entity2_exp1 entity2_exp2 entity3_exp1 entity3_exp2 entity3_exp3
id
json present present present absent absent absent
molly absent present present absent absent absent
tina absent present present absent absent absent
jake present absent absent present present present
molly present absent absent absent absent absent
您可以简单地循环:
选项1
在字典理解中使用
pd.concat
选项2
^{pr2}$切片数据帧并重命名列
您可以使用dict键作为列名重新编制df的索引,然后使用dict的值重命名列
相关问题 更多 >
编程相关推荐