擅长:python、mysql、java
<p>您可以使用dict键作为列名重新编制df的索引,然后使用dict的值重命名列</p>
<pre><code>df_new = df.reindex(columns=sum([[k]*len(v) for k,v in ref_dict.items()],[]))
df_new.columns=sum(ref_dict.values(),[])
df_new
Out[573]:
entity_exp1 entity2_exp1 entity2_exp2 entity3_exp1 entity3_exp2 entity3_exp3
0 present present present absent absent absent
1 absent present present absent absent absent
2 absent present present absent absent absent
3 present absent absent present present present
4 present absent absent absent absent absent
</code></pre>