- 把列值中的字典展开为新列
原始的DataFrame如下:
df = pd.DataFrame([[1,'a',{'a':'vv','b':'cc'}],[2,'b',{'c':'vv','b':'cc'}], [3,'c',{'b':'cc'}], [4,'n',{'a':'cc'}]], columns =['id', 'prop', 'value'])
把‘value’转换为list后再变成DataFrame即可:
pd.DataFrame(list(df['value']))
- 把两列的值对应起来变成新的列:
df = pd.DataFrame([[1,'a','rr'],[2,'b','dd'], [3,'c','bb'],[4,'n','rr']], columns =[&