【python】【pycharm】+读写csv文件/其他格式配置文件

目录

• step1：数据写入csv配置文件
•  step2：读取csv文件数据
• step3：调用
• 完整代码
• 效果

https://blog.csdn.net/qq_39413365/article/details/88760885

回到顶部

step1：数据写入csv配置文件

def csv_writer():
    '''写入csv文件'''
    headers = ["编号", "课程", "讲师"]

    rows = [
        (1, "A", "AA"),
        (2, "B", "BB"),
        (3, "C", "CC")
    ]
    with open("ZGXTest.csv", "w", encoding="GBK", newline="") as f:
        writer = csv.writer(f)
        writer.writerow(headers)
        writer.writerows(rows)

回到顶部

 step2：读取csv文件数据

def csv_reader():
    '''读取csv文件'''
    with open("ZGXTest.csv", encoding="GBK") as f:
        # reader = csv.DictReader(f)
        # 读取每一行
        reader = csv.reader(f)
        # 配置表头
        headers = next(reader)
        # 打印表头
        print(headers)
        # 打印每一行（无表头）
        for row in reader:
            print(row)

回到顶部

step3：调用

if __name__ == "__main__":
    csv_writer()
    csv_reader()

 

回到顶部

完整代码

import csv


def csv_writer():
    '''写入csv文件'''
    headers = ["编号", "课程", "讲师"]

    rows = [
        (1, "A", "AA"),
        (2, "B", "BB"),
        (3, "C", "CC")
    ]
    with open("ZGXTest.csv", "w", encoding="GBK", newline="") as f:
        writer = csv.writer(f)
        writer.writerow(headers)
        writer.writerows(rows)


def csv_reader():
    '''读取csv文件'''
    with open("ZGXTest.csv", encoding="GBK") as f:
        # reader = csv.DictReader(f)
        # 读取每一行
        reader = csv.reader(f)
        # 配置表头
        headers = next(reader)
        # 打印表头
        print(headers)
        # 打印每一行（无表头）
        for row in reader:
            print(row)


if __name__ == "__main__":
    csv_writer()
    csv_reader()

 

回到顶部

效果

打印结果

 文件内容