pythonでcsv

読み込んで、列順を変えて書き込む


import csv

csv_r = open("./test.csv", "r", encoding="utf-8", errors="", newline="" )
csv_w = open('output.csv', 'w')
rf = csv.reader(csv_r, delimiter=",", doublequote=True, lineterminator="\r\n", quotechar='"', skipinitialspace=True)
wf = csv.writer(csv_w, lineterminator='\n')

order = [2,3,1]

for row in rf:
data = []
for i in order:
if i == 0:
data.append("")
continue
data.append(row[i-1])
wf.writerow(data)

csv_r.close()
csv_w.close()