我试图从多个字典键中提取最大值和相应的键&python dataframe中对象列中的值,有人能帮我吗
df:
Obj_values
0 {"Sony":25,"Max":91,"James":55}
1 {"Jack":12,"Max":10}
2 {}
3
4 {"Halk":21,"Hall":15}
5 {"H":1}
6 {"Aws":"k","Az":113,"Gc":"b"}
7 {"Max":60,"HBO":113,"Sony":55, "WS":1256,"James":55}
我尝试了下面的方法,但仍然无法将数据帧转换为dict:
obj_lst = df["Obj_values"].tolist()
df["Obj_values"] = ast.literal_eval(str(obj_lst))
df["Obj_values"].dtype
# dtype('O')
for k,v in df["Obj_values"].items():
print(k,v)
预期结果: