学习笔记（12):150讲轻松搞定Python网络爬虫-CSV处理-写入CSV文件的两种方式

最新推荐文章于 2022-04-03 13:15:29 发布

kingx3

最新推荐文章于 2022-04-03 13:15:29 发布

阅读量500

点赞数

文章标签： python 网络爬虫编程语言 Python 数据存储

立即学习: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)