立即学习:https://edu.csdn.net/course/play/24756/280719?utm_source=blogtoedu
- 类似于reader的用法,写入列表数据用.write配合writerow和writerows
- 写入字典数据利用.DictWriter配合writeheader和writerows
- 注意文件打开时添加newline='',防止不必要的空行
# !/usr/bin/python
# Filename: CSV文件的两种写入方式.py
# Data : 2020/06/24
# Author : --king--
# ctrl+alt+L自动加空格格式化
import csv
headers = ('name','age','height')
# 列表套元组的方式
students = [
("张三",18,180),
("李四",19,190),
("王五",20,170)
]
# 1.用.writer写入
# newline='' 避免在写入后自动换行增加空行
with open("students.csv",'w',encoding='utf-8',newline='') as fp:
# csv.writer写入表头
writer = csv.writer(fp)
# .writerow写入单行
writer.writerow(headers)
# .writerows写入多行
writer.writerows(students)
# 2.需要写入的数据为字典列表方式
students = [
{"name":"张三","age":18,"height":180},
{"name":"李四","age":19,"height":190},
{"name":"王五","age":20,"height":170}
]
with open("students.csv",'w',encoding='utf-8',newline='') as fp:
# csv.DictWriter指定需要写入的文件和表头,并未写入表头
writer = csv.DictWriter(fp,headers)
# .writeheader写入表头
writer.writeheader()
# .writerows写入多行
writer.writerows(students)