Python操作 Excel，Csv, pickle看这一篇就够了

最新推荐文章于 2022-11-28 20:04:40 发布

Fighting-年轻人就该张牙舞爪

最新推荐文章于 2022-11-28 20:04:40 发布

阅读量5.2k

点赞数 1

分类专栏： Python技术文章标签： python

本文链接：https://blog.csdn.net/weixin_43380311/article/details/108338190

版权

Python技术专栏收录该内容

102 篇文章 6 订阅

订阅专栏

文章目录

- - CSV读写
  - XML(html)读写

CSV读写

import csv

header = ['class', 'id']
# --列表型写入
rows = [
[1, 2],
[3, 4]
]
with open('demo.csv', 'wb') as f:
    f_csv = csv.writer(f) # csv 写对象
    f_csv.writerow(header) # 写入单行
    f_csv.writerows(rows) # 写入多行
# --字典型写入
rows = [
{'class': 1, 'id': 2},
...
]
with open('test.csv', 'w') as f:
    f_csv = csv.DictWriter(f, header)
    f_csv.writeheader()
    f_csv.writerows(rows)


#------------读取
with open('test.csv', 'r') as f:
    # 列表类型读取
    f_csv = csv.reader(f)
    for i in f_csv:
        i  # 列表
    # 字典类型读取
    f_csv = csv.DictReader(f)
    for i in f_csv:
        i  # 字典

XML(html)读写

import csv

header = ['class', 'id']
# --列表型写入
rows = [
[1, 2],
[3, 4]
]
with open('demo.csv', 'w') as f:
    f_csv = csv.writer(f) # csv 写对象
    f_csv.writerow(header) # 写入单行
    f_csv.writerows(rows) # 写入多行
# --字典型写入
rows = [
{'class': 1, 'id': 2},
...
]
with open('test.csv', 'w') as f:
    f_csv = csv.DictWriter(f, header)
    f_csv.writeheader()
    f_csv.writerows(rows)


#------------读取
with open('test.csv', 'r') as f:
    # 列表类型读取
    f_csv = csv.reader(f)
    for i in f_csv:
        i  # 列表
    # 字典类型读取
    f_csv = csv.DictReader(f)
    for i in f_csv:
        i  # 字典