List to Dictionary in pandas?

Question

I have a column which has values stored as list. The column looks like:

[{'key': 'firebase_screen_class', 'value': 'MainViewController'},
 {'key': 'firebase_event_origin', 'value': 'auto'},
 {'key': 'firebase_screen_id', 'value': '81265142482196321'},
 {'key': 'engagement_time_msec', 'value': '3374'}]

I want to convert this into a column which looks like:

{'firebase_screen_class': 'MainViewController',
 'firebase_event_origin': 'auto',
 'firebase_screen_id': '81265142482196321',
 'engagement_time_msec': '3374'}

Hint: for each key its value is the key for you and for the value its key is the value for you. — DirtyBit, Mar 29 '19 at 11:11

score 4 · Answer 1 · answered Mar 29 '19 at 11:11

4

Use a dictionary comprehension:

{d['key']:d['value'] for d in col}

where col is your original column.

answered Mar 29 '19 at 11:11

John Coleman

51,337
7
54
119

score 1 · Answer 2 · answered Mar 29 '19 at 11:11

you can simply do it using for loop:

l1 = [{'key': 'firebase_screen_class', 'value': 'MainViewController'},
     {'key': 'firebase_event_origin', 'value': 'auto'},
     {'key': 'firebase_screen_id', 'value': '81265142482196321'},
     {'key': 'engagement_time_msec', 'value': '3374'}]
final_dict = {}
for d1 in l1:
    final_dict[d1['key']] = d1['value']

print final_dict

score 1 · Accepted Answer · answered Mar 29 '19 at 11:15

list = [{'key': 'firebase_screen_class', 'value': 'MainViewController'},
        {'key': 'firebase_event_origin', 'value': 'auto'},
        {'key': 'firebase_screen_id', 'value': '81265142482196321'},
        {'key': 'engagement_time_msec', 'value': '3374'}]

result = dict()

for d in list:
     result[d['key']] = d['value']

score 0 · Answer 4 · answered Mar 29 '19 at 20:59

0

def dd(arr):
    di = {}
    for j in arr:
        di[j['key']] = j['value']
    return di

df['new_cil'] = df['col'].map(dd)

answered Mar 29 '19 at 20:59

nk23

179
1
10

List to Dictionary in pandas?

4 Answers4