Extract value from Python data dictionary column

elia_Werner 0
Viewed 25

I have a DF with a column that is a dictionary:

import pandas as pd

data = [10,{'self': 'https://elia.atlassian.net/rest/api/3/customFieldOption/10200', 'value': 'IT-Sourced Changes 2022', 'id': '10200'},30]
df = pd.DataFrame(data, columns=['Data'])

How do I create a new column that selects only one value e.g. 'IT-Sourced Changes 2022'?

Thank you!

dictionary dataframe python
1 Answers

df['new_col']= df['requirement_source'].str['value']

Should get the job done

Hassan Jalil0
Related