擅长:python、mysql、java
<p>解决方案是在</p>
<pre><code>with open(path, 'r') as infile:
</code></pre>
<p>这两个参数是encoding='UTF-8'和errors='ignore'。这允许我创建一个原始CSV的副本,没有头和UnicodeDecodeError。下面是完整的代码。</p>
<pre><code>import csv
path = '/Users/johndoe/file.csv'
with open(path, 'r', encoding='utf-8', errors='ignore') as infile, open(path + 'final.csv', 'w') as outfile:
inputs = csv.reader(infile)
output = csv.writer(outfile)
for index, row in enumerate(inputs):
# Create file with no header
if index == 0:
continue
output.writerow(row)
</code></pre>