How to get values from a column with format of dictionary?

user_11985685 0
Viewed 28

If I have adata frame with this column and this information

slice_info                                 time                             
----------------------------------------- -----
{'gaming': 2, 'main': 92, 'working': 9}   2021-09-11 00:04:00
{'gaming': 4, 'main': 78, 'working': 10}  2021-09-11 00:04:00
.....

How can I get the values that belong to gaming and the sum this 2 and 4 value?

pandas dataframe python
2 Answers

You could just .apply a function to retrieve the value from the dictionary and then sum those values:

df["slice_info"].apply(lambda entry: entry["gaming"]).sum()
user_32810970

Parse and convert:

import json

rows = []

for line in data.splitlines()[2:]:
    rows.append(json.loads(line.split('}')[0].replace("'", '"') + "}"))

print(rows[0]["gaming"])  # 2
user_91601240
Related