擅长:python、mysql、java
<p>最简单的方法是使用<a href="https://docs.python.org/3.8/library/csv.html#csv.DictReader" rel="nofollow noreferrer">DictReader</a>读取文件。与用于编写文件的DictWriter一样,DictReader对行使用字典,因此从旧行中删除键然后写入新文件的方法将按预期工作。你知道吗</p>
<pre><code>import csv
FTemp = "D:/tempfile.csv"
FOut = "D:/NewFile.csv"
with open(FTemp, 'r') as csv_file:
# Adjust the list to be have the correct order
old_fieldnames = ['Stn_Name', 'Lat', 'Long', 'Prov', 'Tm', 'DwTm']
csv_reader = csv.DictReader(csv_file, fieldnames=old_fieldnames)
with open(FOut, 'w') as new_file:
fieldnames = ['Stn_Name', 'Lat', 'Long', 'Prov', 'Tm']
csv_writer = csv.DictWriter(new_file, fieldnames=fieldnames)
for line in csv_reader:
del line['DwTm']
csv_writer.writerow(line)
</code></pre>