Skip to content
Advertisement

dictionary inside column of a dataframe

I have a pandas dataframe that has a column like this :

9834    {'id': 5426, 'name': 'Solana', 'symbol': 'SOL'...
9835    {'id': 1839, 'name': 'BNB Smart Chain (BEP20)'...
9836    {'id': 1027, 'name': 'Ethereum', 'symbol': 'ET...
9837    {'id': 1839, 'name': 'BNB Smart Chain (BEP20)'...
9838    {'id': 1027, 'name': 'Ethereum', 'symbol': 'ET...
9839    {'id': 1027, 'name': 'Ethereum', 'symbol': 'ET...
9840    {'id': 1027, 'name': 'Ethereum', 'symbol': 'ET...
9841    {'id': 1839, 'name': 'BNB Smart Chain (BEP20)'...
9842    {'id': 1027, 'name': 'Ethereum', 'symbol': 'ET...
9843    {'id': 1839, 'name': 'BNB Smart Chain (BEP20)'...

I want to make a condition on the whole dataframe based on the id value.

I did many attempts but failed.

only_solana = df[df['platform']['id']==5426]

it says key error, it cannot access ‘id’ which is inside the column ‘platform’.

Any help is welcome, and thank you in advance.

Advertisement

Answer

Use Series.str.get and compare in boolean indexing:

only_solana = df[df['platform'].str.get('id')==5426]
User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement