python爬虫--json和csv文件的基本使用
代码
import csv
with open('data.csv','r',encoding='utf-8') as f:
reader=csv.reader(f)
for res in reader:
print(res)
with open('data.csv','r',encoding='utf-8') as f:
reader=csv.DictReader(f)
for res in reader:
print(res)
header = [
'name',
'age',
'classroom'
]
rows = [('张三', 14, '1'), ('李四', 15, '2'), ('王五', 20, '3')]
with open('class.csv','w',encoding='utf-8',newline='') as f:
writer=csv.writer(f)
writer.writerow(header)
writer.writerows(rows)
map={'name':'huhu','age':12,'classroom':'3'}
with open('class.csv','w',encoding='utf-8',newline='') as f:
writer=csv.DictWriter(f,header)
writer.writeheader()
writer.writerow(map)