【python】【pycharm】+读写csv⽂件其他格式配置⽂件step1：数据写⼊csv配置⽂件
1def csv_writer():
2'''写⼊csv⽂件'''
3    headers = ["编号", "课程", "讲师"]
4
5    rows = [
6        (1, "A", "AA"),
7        (2, "B", "BB"),
8        (3, "C", "CC")
9    ]
10    with open("ZGXTest.csv", "w", encoding="GBK", newline="") as f:
11        writer = csv.writer(f)
12        writer.writerow(headers)
13        writer.writerows(rows)
View Code
step2：读取csv⽂件数据
1def csv_reader():
2'''读取csv⽂件'''
3    with open("ZGXTest.csv", encoding="GBK") as f:
4# reader = csv.DictReader(f)
5# 读取每⼀⾏
6        reader = ader(f)
7# 配置表头
8        headers = next(reader)
9# 打印表头
10print(headers)
11# 打印每⼀⾏（⽆表头）
12for row in reader:
13print(row)
View Code
step3：调⽤
1if__name__ == "__main__":
2    csv_writer()
3    csv_reader()
View Code
完整代码
1import csv
2
3
4def csv_writer():
5'''写⼊csv⽂件'''
6    headers = ["编号", "课程", "讲师"]
7
8    rows = [
9        (1, "A", "AA"),
10        (2, "B", "BB"),
11        (3, "C", "CC")
12    ]
13    with open("ZGXTest.csv", "w", encoding="GBK", newline="") as f:
14        writer = csv.writer(f)
15        writer.writerow(headers)
16        writer.writerows(rows)
17
18
19def csv_reader():
20'''读取csv⽂件'''
21    with open("ZGXTest.csv", encoding="GBK") as f:
22# reader = csv.DictReader(f) 23# 读取每⼀⾏
24        reader = ader(f)
25# 配置表头
26        headers = next(reader)
27# 打印表头
28print(headers)
29# 打印每⼀⾏（⽆表头）
30for row in reader:
31print(row)
32
33
34if__name__ == "__main__":
35    csv_writer()
36    csv_reader()
View Code
效果
打印结果
⽂件内容
python怎么读csv数据

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。