python高效编程技巧9（如何读写csv文件）

#!/usr/bin/env python# -*- coding:utf-8 -*-# 读写csv文件import csv# ========读csv文件：打开，需要使用二进制方式rb========rf = open("boss.csv", "rb")reader = csv.reader(rf)for row in reader:print rowrf.flush()r

古月的三个锦囊

570人浏览 · 2017-10-17 16:34:28

古月的三个锦囊 · 2017-10-17 16:34:28 发布

#!/usr/bin/env python
# -*- coding:utf-8 -*-

# 读写csv文件
import csv

# ========读csv文件：打开，需要使用二进制方式rb========
rf = open("boss.csv", "rb")
reader = csv.reader(rf)
for row in reader:
    print row
rf.flush()
rf.close()

# ========写csv文件========
wf = open("boss2.csv", "wb")
writer = csv.writer(wf)
writer.writerow(["姓名", "性别", "年龄"])
wf.flush()
wf.close()

# ========综合使用========
with open("boss.csv", "rb") as rf:
    reader = csv.reader(rf)
    # 如果是wb，则这个boss2.csv文件会先被清空，如果是wb，则是追加模式
    with open("boss2.csv", "wb") as wf:
        writer = csv.writer(wf)
        for row in reader:
            writer.writerow(row)
        wf.flush()
        wf.close()
    rf.flush()
    rf.close()