读写CSV文件

读取CSV文件

import csv
def read_csv():
    with open("data.csv","r",encoding="UTF8")as csvFile:
        #读取csv文件，返回的是迭代类型（list,字典等能循环的类型）
        read = csv.reader(csvFile)
        for i in read:##i是列表类型
            print(i[0])
read_csv()

def read_csv_row():
    with open("data.csv","r",encoding="UTF8")as csvFile:
        #读取csv文件，返回的迭代类型（list,字典等能循环的类型）
        read = csv.reader(csvFile)
        for(row,v) in enumerate(read):##(row,v)row第几行，v行内容
            if(row>0):
                print("%d:%s"%(row,v))
read_csv_row()

CSV中写代码

def csv_write():
    with open("data.csv",'w',encoding="utf-8")as file:
        file.write("id,name,url,num")
        file.write("\n")
        file.write("1,百度,www.baidu.com,100")
        file.write("\n")