我有以下数据帧:
df = pd.DataFrame({'scene':[{"living":"0.515","kitchen":"0.297"}, {"kitchen":"0.401","study":"0.005"}, {"study":"0.913"}, {}, {"others":"0"}], 'id':[1, 2, 3 ,4, 5]})
id scene
01 {"living":"0.515","kitchen":"0.297"}
02 {"kitchen":"0.401","study":"0.005"}
03 {"study":"0.913"}
04 {}
05 {"others":"0"}
我想创建一个新的数据帧,如下所示,有人可以帮我用Pandas创建吗?
id living kitchen study others
01 0.515 0.297 0 0
02 0 0.401 0.005 0
03 0 0 0.913 0
04 0 0 0 0
05 0 0 0 0
解决方法:
关于你的数据,
df = pd.DataFrame({'scene':[{"living":"0.515","kitchen":"0.297"}, {"kitchen