CSV中的分号分隔符转换为逗号？

Question

我有一个简单的场景，我将CSV中的分隔符从;（分号）更改为,（逗号）。下面是代码

代码：

import csv
semicolonin = csv.reader(r"C:\pyscripts\1.csv", delimiter=';')
commaout = csv.writer(r"C:\pyscripts\1.csv", delimiter=',')
for row in semicolonin:
    commaout.writerow(row)

但我收到一个错误。我错过什么了吗？在

^{pr2}$

执行commaout = csv.writer(r"C:\pyscripts\1.csv", delimiter=',')行时。在

Answer 1

必须向writer方法提供一个file对象，如下所示：

import csv
with open(r"C:\pyscripts\1.csv") as in_file, open(r"C:\pyscripts\1.csv", 'w') as out_file:
    semicolonin = csv.reader(in_file, delimiter=';')
    commaout = csv.writer(out_file, delimiter=',')
    for row in semicolonin:
        commaout.writerow(row)

Answer 2

您还可以使用熊猫：

import pandas as pd

f = pd.read_csv("C:\pyscripts\1.csv")
f.to_csv("C:\pyscripts\1.csv", sep=";")