回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我正在尝试从json写入csv,所以每个值(pH)都在不同的行中,但我一直在获取</p>
<blockquote>
<p>Traceback (most recent call last):<br/>
File "C:/Users/User/PycharmProjects/Meslosana/getValues.py", line 22, in <br/>
lines[i][1] = pH<br/>
IndexError: list index out of range</p>
</blockquote>
<p>我还将在相同的行但不同的列中添加不同的值</p>
<p>我的csv文件看起来像这样,它没有空行</p>
<pre><code>0,0,0,0,0
0,0,0,0,0
0,0,0,0,0
0,0,0,0,0
0,0,0,0,0
0,0,0,0,0
0,0,0,0,0
0,0,0,0,0
0,0,0,0,0
</code></pre>
<p>每次我运行代码时,它都会在底部创建一个空行</p>
<p>这是我的密码</p>
<pre><code>import json
import csv
file = 'LaukiGeojson/Zemdegas.geojson'
cord = []
with open(file) as f:
data = json.load(f)
i = 1
for feature in data['features']:
cord = feature['geometry']['coordinates'][0]
pH = feature['properties']['pH']
print(pH)
print(feature)
print(data)
# saglabaa
r = csv.reader(open('LaukiAnalizes/Zemdegas.csv'))
lines = list(r)
print(len(lines))
#lines[i][0] = 1
lines[i][1] = pH
#lines[i][2] = 1
#lines[i][3] = 1
#lines[i][4] = 1
i += 1
writer = csv.writer(open('LaukiAnalizes/Zemdegas.csv', 'w', newline=''))
writer.writerows(lines)
# saglabaa
r = csv.reader(open('LaukiAnalizes/Zemdegas.csv'))
lines = list(r)
lines[0][0] = 'ID'
lines[0][1] = 'pH'
lines[0][2] = 'P'
lines[0][3] = 'K'
lines[0][4] = 'Mg'
writer = csv.writer(open('LaukiAnalizes/Zemdegas.csv', 'w', newline=''))
writer.writerows(lines)
open('LaukiAnalizes/Zemdegas.csv').close()
</code></pre>