回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有这样一句话:</p>
<pre><code>d = {
"Meter": ["000413031", "000413032", "000413034", "000413035"],
"Account": ["314113801", "314113802", "314114140", "314114221"],
"AcceptedDate": ["20210226", "20210226", "20210226", "20210226"],
"EulaVersion": ["2018v01FXRSSWO", "2018v01FXRSSWO", "2018v01FXRSSWO", "2018v01FXRSSWO"],
"SoftwareVersion": ["FXRS1810", "FXRS1810", "FXRS1810", "FXRS1810"],
"CompanyName": ["SN2000 TEST", "SN2000 TEST", "SN2000 TEST", "SN2000 TEST"],
"MachGuid": ["{B2B94738-B031-46B2-9D94-F54EEF46BE82}", "{B2B94738-B031-46B2-9D94-F54EEF46BE82}", "{B2B94738-B031-46B2-9D94-F54EEF46BE82}", " {B2B94738 - B031 - 46 B2 - 9 D94 - F54EEF46BE82}"]
}
</code></pre>
<p>因为我需要将其戏剧性地插入到db中,所以我首先通过以下方式获得所有列名:</p>
<pre><code>keys = ','.join(d.keys())
</code></pre>
<p>我得到:</p>
<pre><code>Meter,Account,AcceptedDate,EulaVersion,SoftwareVersion,CompanyName,MachGuid
</code></pre>
<p>这正是我想要的</p>
<p>dict的值都是列表</p>
<p>所以我需要一个接一个的</p>
<p>当我尝试时:</p>
<pre><code>test =','.join(str(d[x][0]) for x in sorted(d))
</code></pre>
<p>这意味着只需获取列表中的第一个值,但我收到:</p>
<pre><code>20210226,314113801,SN2000 TEST,2018v01FXRSSWO,{B2B94738-B031-46B2-9D94-F54EEF46BE82},000413031,FXRS1810
</code></pre>
<p>这不符合顺序。有朋友能帮忙吗</p>