dictionary inside column of a dataframe

Question

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.

I don't know why the question is closed, the other post doesn't talk about str slicing and is different, it doesn't quite answer and solve the issue like you did guys. — Elyes Lounissi, Apr 07 '22 at 12:19
the question was the same, it hadn't been updated for a while I added the `str` method to it ;) — mozway, Apr 07 '22 at 12:19
so you cannot ask on stack overflow similar questions if there is no perfect answer for the question ? — Elyes Lounissi, Apr 07 '22 at 12:21
because for my case str perfectly solves the issue, and there was no answer having it before I asked — Elyes Lounissi, Apr 07 '22 at 12:22

jezrael · Accepted Answer · 2022-04-07T12:21:42.690

3

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

only_solana = df[df['platform'].str.get('id')==5426]

edited Apr 07 '22 at 12:21

answered Apr 07 '22 at 12:10

jezrael

822,522
95
1,334
1,252

dictionary inside column of a dataframe

1 Answers1