<p>我有一个python脚本,从csv文件中读取并将值存储在一个列表中,
其中的值是日期行[0]、浮点行[10]、布尔行[11]。在</p>
<p>脚本在读取部分工作得很好,但当我试图将选定的值写入第二个CSV文件时,系统会创建一个文件,其中只包含头文件</strong>,系统崩溃并显示以下错误:</p>
<blockquote>
<p>line 62, in <br/>
fwriter.writerow("{}:{}:{}".format(row[0],row[10],row[11]))</p>
<p>builtins.IndexError: string index out of range</p>
</blockquote>
<p>代码中的错误在哪里?在</p>
<h2>代码:</h2>
<pre><code> import csv
mydelimeter = csv.excel()
mydelimeter.delimiter=";"
myfile = open("C:/Users/test/Documents/R_projects/homework/rdu-weather-history.csv")
# read the first line in the opened file ==> Header
myfile.readline()
myreader=csv.reader(myfile,mydelimeter)
result=[]
'''
create a variable that handle values of the 3 fields
==> Date - fastest5secwindspeed - fog
and display the result where
fog ==> Yes and highest speed more than 10.
'''
for index ,row in enumerate(myreader):
try:
'''
check if the values in the fog colums is == Yes
if ok
check if the column of the "fastwindspeed"
is empty ==> raise Exception
check if the value in column of the "fastwindspeed"
is < 10.0 ==> raise Exception
else print the results
'''
if row[11] =="Yes":
if row[10] in (None, ""):
raise Exception( "this Record has empty value" )
if float(row[10]) < 10.0:
raise Exception( 'the wind speed is below 10 mph in ' + row[0] )
print(row[0],row[10],row[11])
'''
<a href="https://www.cnpython.com/list/append" class="inner-link">append</a> the result into a list
in order to use it in the writing of the new csv file
'''
result.append(row[0])
result.append(row[10])
result.append(row[11])
except Exception as e:
print("{}:{}".format(index ,e))
myfile.close()
'''
create a second csv file and append the selected result from the 1st csv file
'''
with open("C:/Users/test/Documents/Python_Projects/rduSpeedFog.csv", "w") as f:
headers = ["Date","WindSpeed","Fog"]
fwriter=csv.writer(f,mydelimeter)
fwriter.writerow(headers)
for row in result:
fwriter.writerow("{}:{}:{}".format(row[0],row[10],row[11]))
print("Writing Complete")
f.close()
</code></pre>
<p>在使用了@Bamar的答案之后</p>
<p>我得到了这个结果</p>
<p><a href="https://i.stack.imgur.com/6IYcX.png" rel="nofollow noreferrer">csv file as result</a></p>