学习日志(五) Python操作csv Excel

Python 持久化操作 - CSV、Excel

1. Python操作csv

1.1 读CSV

​ import csv

​ 打开文件，用 with open(“./csv/文件名.csv”,”r”) as csvfile:

​ 读取csv文件，返回的是迭代类型 read = csv.reader(csvfile)

​ for i in read: print(i)

import csv#导入模块
#打开csv文件
with open("E:/Users/DELL/PycharmProjects/untitled1/销售相关企业信息.csv","r") as csvfile:#r代表read
    #读取文件
    read = csv.reader(csvfile)
    # print(read)
    for i in read:#使用遍历的方式来读取文件
        print(i)

1.2 写CSV

with open('./csvtest.csv','w')as csvfile:#这里的w代表write写入
    writer = csv.writer(csvfile)
    writer.writerow(['id','url','keywords'])
    data = [
        ('1','http://www.xiaoheiseo.com/','小黑'),
        ('2',