1、导入csv模块
import csv
2、读取csv文件
with open("file path","r+") as f:
f_1=csv.reader(f)
3、打开并写入另一个csv文件
with open("file path","w+",newline='') as ff:
ff_1=csv.writer(ff)
ff_1.writerow([])
for row in f_1:
ff_1.writerow([])
4、关闭csv文件
f_1.close()
5、关闭csv文件
ff_1.close()
注,示例:
import csv
with open("C:\\Users\\Rooobins\\Desktop\\operrecord_18062110_center_2.csv","r+") as f:
f_csv=csv.reader(f)
with open("C:\\Users\\Rooobins\\Desktop\\operrecord_18062110_center_3.csv","w+",newline='') as f_1:
f_1_csv=csv.writer(f_1)
f_1_csv.writerow(["所在省份","经纬度"])
for row in f_csv:
f_1_csv.writerow(["山西省",row[0]+","+row[1]])
f_1.close()
f.close()