day17- 读取csv文件和面向对象
1.csv
1.读取csv文件
# utf-8-sig:带签名的utf-8,有字节序标记
import csv
with open(r'resources/2018年北京积分落户数据.csv', 'r', encoding='utf-8-sig') as file:
# delimiter参数默认是逗号,但是如果值不是用逗号分隔就要重新指定
# guotechar参数默认值是引号,但是如果不是引号包围就要重新指定
reader = csv.reader(file) # 创建csv阅读器
for line in reader:
print(line)
2.将数据写入csv文件
import csv
with open(r'resources/2018年北京积分落户数据.csv', 'a', encoding='utf-8-sig', newline='') as file:
writer = csv.write(file)
writer.writerow(['6020', '贺晓明', '1981-11', '北京宝洁技术有限公司', '120'])
writer.writerows([
['6021', '小芳', '1981-07', '北京宝洁技术有限公司', '78.90'],
['6022', '大王'