擅长:python、mysql、java
<p>假设您的<code>.csv</code>文件如下所示:</p>
<pre><code>11|2000-02-18|Badjora|22|33|44|55|""|""Wood 6.5"" Long Line (Pine - Category:15 m | Humidity max: 13 g/m3)""|4
333|1999-02-18|Badjora|444|555|666|777|""|"""|4
</code></pre>
<p>您可以通过以下方式读取该文件:</p>
<pre><code>import csv
with open("sample.csv") as sample:
reader = csv.reader(sample, delimiter="|")
for row in reader:
print(row)
</code></pre>
<p>这很好地输出:</p>
<pre><code>['11', '2000-02-18', 'Badjora', '22', '33', '44', '55', '', 'Wood 6.5"" Long Line (Pine - Category:15 m ', ' Humidity max: 13 g/m3)""', '4']
['333', '1999-02-18', 'Badjora', '444', '555', '666', '777', '', '"|4\n']
</code></pre>
<p>但是,如果要修复分隔符,请使用以下命令:</p>
<pre><code>with open("sample.csv") as sample, open("fixed_sample.csv", "w", newline="") as outfile:
reader = csv.reader(sample, delimiter="|")
writer = csv.writer(outfile, delimiter=",")
for item in reader:
writer.writerow(item)
</code></pre>