我正在阅读python中的csv文件,提取包含json数据的列,并提取所需的键值对。所以我已经给出了好列的列表(比如说good_columns =[]
),我想在我的列表中添加这个键的值到新的列表中(比如说data=[]
),但是在json中有些键是我不想要的,根据我的好列列表,我想在我的数据列表中加零。
提前谢谢。你知道吗
good_columns = [
"outboundrtp_roundTripTime",
"outboundrtp_targetBitrate",
"outboundrtp_bytesSent",
"outboundrtp_packetsSent",
"outboundrtp_packetsLost",
"inboundrtp_inboundJitter" ,
"inboundrtp_bytesReceived" ,
"inboundrtp_packetsLost"
]
json内容:
{
"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
}
我希望我的列表中包含值为0的键,而不是在好的列中。结果应该是:
对于第一个:
期望输出:
[0.340,17586,8880,78,1,0.024,24835,0]
电流输出:
[0,0,0.340,17586,8880,78,1,0]
对于第二个:
期望输出:
[0,5616,37366,654,0,0,0]
电流输出:
[0,0,0,5616,37366,654,0]
我尝试过的:
for key, value in record.items():
if key in good_columns:
data.append(value)
elif key not in good_columns:
data.append(0)
但这并没有达到预期的效果。你知道吗
希望对你有帮助。你知道吗
试试这个:
相关问题 更多 >
编程相关推荐