python列表嵌套字典转dataframe

axllen

现在有一个列表，格式如下

[Python] 纯文本查看 复制代码

[{'hostname': 'device1', 'CPU usage': '0.24'},
 {'hostname': 'device1', 'Disk usage': '1.88'},
 {'hostname': 'device1', 'Memory usage': '52.86'},
 {'hostname': 'device2', 'CPU usage': '15.25'},
 {'hostname': 'device2', 'Memory usage': '8.67'}]

想转成以下格式 dataframe


请问应该怎么办？谢谢

bj201809

[Python] 纯文本查看 复制代码

from itertools import groupby
from collections import ChainMap
from pandas as pd

base_data = [{'hostname': 'device1', 'CPU usage': '0.24'},
 {'hostname': 'device1', 'Disk usage': '1.88'},
 {'hostname': 'device1', 'Memory usage': '52.86'},
 {'hostname': 'device2', 'CPU usage': '15.25'},
 {'hostname': 'device2', 'Memory usage': '8.67'}]
 
base_data.sort(key=lambda x:x['hostname'])


res = []
for _,g in groupby(base_data,key=lambda x:x['hostname']):
        res.append(dict(ChainMap(*g)))
        
df = pd.DataFrame(res)

print(df)

bj201809

bj201809 发表于 2023-6-19 19:26
[mw_shl_code=python,true]from itertools import groupby
from collections import ChainMap
from panda ...

思路：先按hostname分组，再合并字典，最后转换dataframe

discuz0

嵌套字典转dataframe

fan666

............