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