<pre><code>good_columns = [
"outboundrtp_roundTripTime",
"outboundrtp_targetBitrate",
"outboundrtp_bytesSent",
"outboundrtp_packetsSent",
"outboundrtp_packetsLost",
"inboundrtp_inboundJitter" ,
"inboundrtp_bytesReceived" ,
"inboundrtp_packetsLost"
]
json_data = [{
"endpoint_AudioE2ELatency": 0,
"endpoint_VideoE2ELatency": 165,
"outboundrtp_roundTripTime": 0.340,
"outboundrtp_targetBitrate": 17586,
"outboundrtp_bytesSent": 8880,
"outboundrtp_packetsSent": 78,
"outboundrtp_packetsLost": 1,
"outboundrtp_remb": 0,
"inboundrtp_inboundJitter": 0.024,
"inboundrtp_bytesReceived": 24835,
"inboundrtp_packetsLost": 0,
"inboundrtp_remb": 0
},{
"endpoint_AudioE2ELatency": 0,
"endpoint_VideoE2ELatency": 149,
"outboundrtp_roundTripTime": 0,
"outboundrtp_targetBitrate": 5616,
"outboundrtp_bytesSent": 37366,
"outboundrtp_packetsSent": 654,
"outboundrtp_packetsLost": 0,
"outboundrtp_remb": 0
}]
def get_val(json_dict, val):
return json_dict.get(val,0)
for index, json_dict in enumerate(json_data,1):
merge_keys = good_columns + list(json_dict.keys())
order_keys = list(dict.fromkeys(merge_keys))
data = [get_val(json_dict,val) for val in order_keys]
print('{}.Dictionary data is {}'.format(index,data))
>>>1.Dictionary data is [0.34, 17586, 8880, 78, 1, 0.024, 24835, 0, 0, 165, 0, 0]
2.Dictionary data is [0, 5616, 37366, 654, 0, 0, 0, 0, 0, 149, 0]
</code></pre>
<p>希望对你有帮助。你知道吗</p>