Python读取csv文件

import csv

inFile = open('d.csv','rb') # 打开csv文件
inReader = csv.reader(inFile) # 读取csv文件

for rowIndex,row in enumerate(inReader, start = 1):
    for colIndex,col in enumerate(row, start = 1):
        rs = util.execSql(col, locals()) # 执行csv里面的SQL
        outFile = open('o.csv','a+')
        Writer = csv.writer(outFile) # 写入csv文件
        Writer.writerow(str(col))
        for rowIndex2,row2 in enumerate(rs, start =1):
            row3 = [rowIndex2] + list(row2) # 数组拼接
            Writer.writerow(row3)
            print('{}.row{}').format(rowIndex2,row2)
        outFile.close()
inFile.close()

posted @ 2021-11-10 10:55  中了毒蛇粉的猫  阅读(131)  评论(0)    收藏  举报