csv文件读取操作

一、传统文件读取

def txt_writed():
    """写文本"""
    with open('data.txt','w',encoding='utf-8') as f:
        f.write('你好，python\n')
        lines=[
            'xx\n',
            'yy\n',
            'ss\n',
        ]
        f.writelines(lines)

def txt_read():
    with open('data.txt',encoding='utf-8') as f:
        """读文件"""
        for lins in f:
            print(lins,end='')
if __name__ == '__main__':
    txt_writed()
    txt_read()

二、csv文件读取

import csv

def csv_read():
    """读取csv文件"""
    with open('fisheriris.csv ', encoding='utf8') as f:
        reader=csv.reader(f)   #用csv模块读取f
        headers=next(reader)    #用next的迭代遍历
        print(headers)          #读取csv的头行
        for row in reader:
            print(row)
            
def csv_read_by_dict():
    """读取csv文件用字典表存储"""
    with open('fisheriris.csv ', encoding='utf8') as f:
        reader=csv.DictReader(f)
        for row in reader:
            print(row)
if __name__ == '__main__':
    csv_read()

三、写入csv文件

import csv
def csv_write():
    """写入csv文件"""
    header=['a','b','c']
    rows = [
        (1, "w", 't'),
        (2, "sss", "y"),
        (3, "ssad", "dfd")
    ]
    with open('mysql.csv', 'w', encoding='utf-8') as f:
        writer=csv.writer(f)  #以csv的方式读取f文件
        writer.writerow(header) #写入头
        writer.writerows(rows)  #写入每一行

if __name__ == '__main__':
    csv_write()