回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我想从csv文件写入字典。你知道吗</p>
<p>但是:</p>
<ol>
<li>一行中的第一个单词应该是关键字</li>
<li>行中的所有其他单词都应该是该键的独立值。你知道吗</li>
</ol>
<p>到目前为止我的代码是:</p>
<pre><code>def coordinates(text):
import csv
reader = csv.reader(open(text))
d = {}
for row in reader:
key = row[0]
d[key] = row[1:]
print(d)
coordinates('luchthavens2.csv')
</code></pre>
<p>使用此代码,行中的所有项都是我字典中的键。你知道吗</p>
<p>谁能帮忙?你知道吗</p>
<p>编辑:</p>
<p>输入文件如下所示:</p>
<pre class="lang-none prettyprint-override"><code>BIN,"Bamiyan","Bamiyan","Afghanistan","AF",34.800000,67.816667,701,"Afghanistan",\N,\N,1149361
BST,"Bost","Bost","Afghanistan","AF",31.550000,64.366667,701,"Afghanistan",\N,1134720,1149361
CCN,"Chakcharan","Chakcharan","Afghanistan","AF",34.533333,65.266667,701,"Afghanistan",\N,\N,1149361
</code></pre>
<p>全部来自一个名为luchthavens2.csv的excel文件,文本的位置是A1-A2-A3-etc</p>
<p>你应该在这里找到:<a href="https://expirebox.com/download/bb8cb3a39f9be041743a8b86db89093b.html" rel="nofollow noreferrer">https://expirebox.com/download/bb8cb3a39f9be041743a8b86db89093b.html</a></p>
<p>输出:</p>
<pre><code>{
'CCN,"Chakcharan","Chakcharan","Afghanistan","AF",34.533333,65.266667,701,"Afghanistan",\\N,\\N,1149361': [],
'BST,"Bost","Bost","Afghanistan","AF",31.550000,64.366667,701,"Afghanistan",\\N,1134720,1149361': [],
'BIN,"Bamiyan","Bamiyan","Afghanistan","AF",34.800000,67.816667,701,"Afghanistan",\\N,\\N,1149361': []
}
</code></pre>
<p>编辑:</p>
<p>我已将输入文件更改为文本文件,然后再次更改为csv文件。奇怪的是,我可以毫无问题地阅读它。你知道吗</p>