爬虫学习-第十四篇

"""
Version: 0.1
Author: freshbin
Date: 2019年8月28日
"""

print("=================================CSV start================================================")

import csv

# with open('data.csv', 'w') as csvfile:
#     writer = csv.writer(csvfile, delimiter=' ') # delimiter修改列与列之间的分隔符,后来我发现加入了delimiter之后，出来的数据格式有点奇怪，pandas读取会失败
#     writer.writerow(['id', 'name', 'age'])
#     writer.writerow(['10001', 'Mike', 20])
#     writer.writerow(['10002', 'Bob', 22])
#     writer.writerow(['10003', 'Jordan', 21])

# with open('data.csv', 'a', encoding='utf-8') as csvfile:
#     fieldnames = ['id', 'name', 'age']
#     writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
#     writer.writerow({'id': '10004', 'name': '中文', 'age': 22})

# 读取
# with open('data.csv', 'r', encoding='utf-8') as csvfile:
#     reader = csv.reader(csvfile)
#     for row in reader:
#         print(row)

# pandas读取
import pandas as pd

df = pd.read_csv('data.csv')
print(df)
print("=================================CSV end================================================")