How to modify a column of a pandas dataframe?

Question

One column of my dataframe its in the following format:

{'name': 'Aimo'}
{'name': 'Aimo'}
{'name': 'Aimo'}
{'name': 'Aimo'}
{'name': 'Aimo'}

The dtype of the column is object. How can I modify this column in the following format?

Aimo
Aimo
Aimo
Aimo
Aimo

Probably the new dtype would be character. Thank you in advance!

U13-Forward · Accepted Answer · 2021-09-23 12:24:49Z

2

I guess if they're dictionaries, do:

df['column'] = df['column'].str['name']

Or parse them as dictionaries if they are not already:

from ast import literal_eval
df['column'] = df['column'].map(literal_eval).str['name']

answered Sep 23, 2021 at 12:24

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jezrael · Accepted Answer · 2021-09-23 12:36:48Z

2

df['column'] = df['column'].str.get('name')

answered Sep 23, 2021 at 12:25

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges