python csv
写入
import csv# 只有,号分隔在excel中打开是多列,其他分隔符是一列# 不加newline windows下回多一个空行 不加encoding 编码随系统with open("a.csv", "w", encoding="utf-8", newline="") as f:writer = csv.writer(f, delimiter=" ")writer.writerow(["中文", 2, 3])writer.writerows([["中文", 2, 3], [4, 5, 6]],)with open("a1.csv", "w", encoding="utf-8", newline="") as f:# 字典形式写入field_name = ["a", "b", "c"]writer = csv.DictWriter(f, field_name)writer.writeheader() # 写入头部writer.writerows([{"a": 1, "b": 2, "c": 3}])
读取
with open("a.csv", "r", encoding="utf-8") as f:reader = csv.reader(f, delimiter=",") # delimiter指定 默认,for row in reader:print(row)with open("a1.csv", "r", encoding="utf-8") as f:# 字典形式读取 reader是一个迭代器reader = csv.DictReader(f)for row in reader:# row为OrderDict有序字典,可以和普通字典一样使用print(row)print(row["a"])
如果觉得《python csv写入和读取csv文件》对你有帮助,请点赞、收藏,并留下你的观点哦!