Dataframe contains multiple values in 1 column-CodePudding

I am pulling data from an API, put it into a dataframe, and it came back like this.

name      preferences                                             zip_code
billy     {'email':False, 'print':False, 'charge':False}          12345
sam       {'email':False, 'print':False, 'charge':False}          55555
edward    {'email':False, 'print':False, 'charge':False}          68954

How can I produce results that look like this:

name      email     print     charge     zip_code
billy     FALSE     FALSE     FALSE      12345
sam       FALSE     FALSE     FALSE      55555
edward    FALSE     FALSE     FALSE      68954

CodePudding user response：

You could convert the preferences column to dataframe, and join:

(df.drop('preferences', axis=1)
   .join(pd.DataFrame(df['preferences'].to_dict()).T)
)

output:

     name  zip_code  email  print  charge
0   billy     12345  False  False   False
1     sam     55555  False  False   False
2  edward     68954  False  False   False