csv的操作

1 csv的简介

cama separeted value逗号分隔符,也称之为字符分隔符  csv的读写方法

rows = [['张三',14],['李四',24],['王五',34]]
with open('test1.csv','w',newline='')as csv_file:
#创建一个写的对象并把他写入csv_file的文件中
    writer = csv.writer(csv.file)
    for row in rows:
        writer.writerow(row)
#writerow写入一行数据  默认写入格式  数据与数据之间默认空一行 加入newline  可以将空行去掉

with open('test1.csv','r')as read_file:
    reader = csv.reader(read_file)
    print([row for row in reader])
    
 

字典的读写

data_dic=[{'name':'张三','age':'15'},{'name':'李四','age':'25'}]
with open('dic.csv','w'newline='')as csv_file:
    keys= []
    for key in data_dic[0].keys():
        print(key)
        keys.append(key)
    #写入一个字典到csv中  filename是设置文本标题
    writer = csv.DictWriter('csv_file',filenames= keys)
    writer.writeheader()
    for dict in data_dic:
        write.writerow(dict)
with open('dic.csv','r')as csv_file:
    reader = csv.DictReader(csv_file)
    print([row for row in reader])