python csv 用法教程

Python基础入门：读写CSV文件教程_python csv reader-CSDN博客

import csv
"""
data.csv
name,password
abc,123456
张五,123#456
张#abc123,123456
666,123456
a b,123456"""
with open('data.csv', encoding='utf-8') as f:reader = csv.reader(f)header = next(reader)print(header)for row in reader:print(row)
"""
['name', 'password']
['abc', '123456']
['张五', '123#456']
['张#abc123', '123456']
['666', '123456']
['a b', '123456']
"""

 

import csvheader = ['name', 'password', 'status']data = [['abc', '123456', 'PASS'],['张五', '123#456', 'PASS'],['张#abc123', '123456', 'PASS'],['666', '123456', 'PASS'],['a b', '123456', 'PASS']
]with open('result.csv', 'w', encoding='utf-8', newline='') as f:writer = csv.writer(f)writer.writerow(header)for row in data:writer.writerow(row)

import csv
"""
name,password
abc,123456
张五,123#456
张#abc123,123456
666,123456
a b,123456"""
with open('data.csv', encoding='utf-8') as f:reader = csv.DictReader(f)for row in reader:print(row)print(row['name'], row['password'])
"""
{'name': 'abc', 'password': '123456'}
abc 123456
{'name': '张五', 'password': '123#456'}
张五 123#456
{'name': '张#abc123', 'password': '123456'}
张#abc123 123456
{'name': '666', 'password': '123456'}
666 123456
{'name': 'a b', 'password': '123456'}
a b 123456
"""

import csvheader = ['name', 'password', 'status']data = [{'name':'abc', 'password':'123456', 'status':'PASS'},{'name':'张五', 'password':'123#456', 'status':'PASS'},{'name':'张#abc123', 'password':'123456', 'status':'PASS'},{'name':'666', 'password':'123456', 'status':'PASS'},{'name':'a b', 'password':'123456', 'status':'PASS'}
]with open('data.csv', 'w', encoding='utf-8', newline='') as f:writer = csv.DictWriter(f, header)writer.writeheader()for row in data:writer.writerow(row)

 newline=‘’为了防止换行写入

【python基础教程】csv文件的写入与读取-腾讯云开发者社区-腾讯云

具有不同分隔符的csv读取

zetcode-zh/docs/py/52.md at master · apachecn/zetcode-zh · GitHub