python csv写入和读取csv文件

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"])