1.csv模块
- 是python的内置模块,跨多种形式导入导出数据,excel进行打开
- 格式可以是.csv .json .html .txt
2.写入csv文件
- 1.通过创建writer对象用到了writerow是写入一行,用writerows是写入多行的
import csv
headers = ('name','age','sex')
persons = [
('张三',16,'男'),
('李四',15,'男'),
('王麻子',13,'女')
]
with open('img.csv','w',encoding='utf-8',newline='') as f:
writer = csv.writer(f)
writer.writerow(headers)
writer.writerows(persons)
#for i in persons:
# writer.writerow(i)
以下这个点击可以对比代码
- 2.用Dictwriter可以使用字典的方式把数据写入进去
headers = ('name','age','sex')
persons = [
{'name':'张三','age':16,'sex':'男'},
{'name':'李四','age':15,'sex':'男'},
{'name':'王麻子','age':13,'sex':'女'}
]
with open('img.csv','w',encoding='utf-8',newline='') as f:
writer = csv.DictWriter(f,headers)
writer.writeheader()
writer.writerows(persons)
# for i in persons:
# writer.writerow(i)
3.读取csv文件
- 1.通过reader()读取到的每一条数据是列表,可以通过下标的方式获取每一个值
with open('img.csv','r',encoding='utf-8',newline='') as f:
reader = csv.reader(f)
for i in reader:
print(i)
- 2.通过Dictreader()读取到的是一个字典,通过key值方式获取数据
with open('img.csv','r',encoding='utf-8',newline='') as f:
Dreader = csv.DictReader(f)
for i in Dreader:
print(i)
print(i['name'])
- 直接print(i)得到的是一个字典我们需要查找他的key值来查找数据