python导出、导入csv

包是python自带的不用单独安装依赖包

#coding=utf-8
import csv

#导出csv文件
#filePath 例如 C:\Users\yc\Desktop\1\output.csv
def exportCsv(filePath):
    # 打开文件
    file = open(filePath,'w',newline='')

    # 写入数据
    writer = csv.writer(file)
    writer.writerow(['姓名','年龄','性别'])
    writer.writerow(['小明',25,'男'])
    writer.writerow(['小红',22,'女'])
    #关闭文件
    file.close()

#导入csv文件
def importCsv(filePath):
    with open(filePath, 'r') as file:
        reader = csv.reader(file)
        for row in reader:
            print(row)
            for i in range(len(row)):
                print(row[i])

if __name__ == '__main__':
    #导出
    #exportCsv('C:\\Users\\yc\\Desktop\\1\\output.csv')
    #导入
    importCsv('C:\\Users\\yc\\Desktop\\1\\output.csv')