开发环境配置

1. csv文件的写
2. csv文件的读

csv文件的写

import csv


def write_csv():
    headers = ['month', 'money']

    # 数据成列表形式，csv.writer 写入
    rows_list_list = [
        [1, 5000],
        [2, 4600]
    ]
    with open('test.csv', 'w', newline='')as fp:
        csv_writer = csv.writer(fp)
        csv_writer.writerow(headers)
        csv_writer.writerows(rows_list_list)

    # 数据内容成字典形式，csv.DictWriter 写入
    rows_list_dic = [
        {'month': 3, 'money': 4200},
        {'month': 4, 'money': 4000}
    ]
    with open('test2.csv', 'w', newline='')as fp:
        csv_writer = csv.DictWriter(fp, headers)
        csv_writer.writeheader()
        csv_writer.writerows(rows_list_dic)

csv文件的读

import csv

def read_csv():
    # 读成列表
    with open("test.csv", encoding="utf-8") as fp:
        csv_reader = csv.reader(fp)
        for row in csv_reader:
            print(row)
    print("----------")
    # 读成字典
    with open("test2.csv", encoding="utf-8") as fp:
        csv_reader = csv.DictReader(fp)
        print(csv_reader.fieldnames)
        for row in csv_reader:
            print(row)

out:

['month', 'money']
['1', '5000']
['2', '4600']
----------
['month', 'money']
{'month': '3', 'money': '4200'}
{'month': '4', 'money': '4000'}

---

转载请注明来源，欢迎对文章中的引用来源进行考证，欢迎指出任何有错误或不够清晰的表达。