擅长:python、mysql、java
<p>使用dict压缩:</p>
<pre><code>import pandas as pd
data = {'entityId': 'clusterId123',
'displayName': 'dev_cluster',
'firstSeenTms': 1584113406351,
'lastSeenTms': 1627524312116,
'properties': {'detectedName': 'dev_cluster'},
'tags': [],
'icon': {'primaryIconType': 'hypervisor'},
'toRelationships': {
'isMemberOf': [
{'id': 'HYPERVISOR_123', 'type': 'HYPERVISOR'},
{'id': 'HYPERVISOR_234', 'type': 'HYPERVISOR'},
{'id': 'HYPERVISOR_345', 'type': 'HYPERVISOR'}
]
}
}
df = pd.DataFrame({
"clusterId": data["entityId"],
"clusterName": data["displayName"],
"hypervisorId": _id["id"]
} for _id in data["toRelationships"]["isMemberOf"])
df
</code></pre>
<p>结果:</p>
<pre><code> clusterId clusterName hypervisorId
0 clusterId123 dev_cluster HYPERVISOR_123
1 clusterId123 dev_cluster HYPERVISOR_234
2 clusterId123 dev_cluster HYPERVISOR_345
</code></pre>