'How to load OrderedDict into Pandas Dataframe?

I have a pyhton dict object which gives back the following data.

Id = 1234
LastModifiedDate = 2022-05-17T13:17:57.000+0000
RecordType.Name = OrderedDict([('attributes', OrderedDict([('type', 'RecordType'), ('url', '/abc/data/v4711/uobjects/RecordType/12345678AU')])), ('Name', 'Paul')])

I write the data from dict into pandas dataframe and it works for this columns.

df_one_0 = df_one_1[['Id', 'LastModifiedDate']]

But from the column RecordType.Name I just need the Name key which is Paul. I get this key value with.

df_one_0 = df_one_1.RecordType[0]['Name']

But how can I bring these both "selects" together?

This for example is not working:

df_one_0 = df_one_1[['Id', 'LastModifiedDate', RecordType[0]['Name']]]


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source