Python爬虫学习笔记（十）

## CSV文件存储  csv以纯文本的形式存储表格数据
# import csv
# with open('text.csv','w') as csvfile:
#     writer = csv.writer(csvfile)
#     writer.writerow(['id','name','age'])
#     writer.writerow(['001','wangsan','11'])
#     writer.writerow(['002','liyun','12'])


#### 想修改列与列之间的分隔符  可以传入delimiter参数
# import csv
# with open('test.csv','a',encoding='utf-8') as fp:
#     writer = csv.writer(fp,delimiter=' ')
#     writer.writerow(['id','name','age'])
#     writer.writerow(['001','王三','12'])
#     writer.writerow(['002','李云','13'])


####   writerows 方法同时写入多行 #传入二维列表
# import csv
# with open('text.csv','a',encoding='utf-8') as fp:
#     writer = csv.writer(fp,delimiter=' ')
#     writer.writerow(['id','name','age'])
#     writer.writerows([['001','占用','13'],['002','组织','14']])



####   以字典的形式写入   可以调用pandas库中 DataFrame对象的to_csv方法来写入
# import  csv
# with open('test.csv','a',encoding='utf-8') as fp:
#     filednames = ['name','id','age']
#     writer = csv.DictWriter(fp,fieldnames=filednames,delimiter='|')
#     writer.writeheader()
#     writer.writerow({'name':'王三','id':'001','age':'18'})
#     writer.writerow({'name':'李云','id':'002','age':'19'})


#### 读取csv
import csv
import pandas as pd
df = pd.read_csv('test.csv')
print(df)