Python 读取CSV

import csv

def parseCSVFileStr(data):
    """
    将csv转换为 [{},{},{},{},{},{},] 形式的列表
    """
    titleFlag = 0
    ldata = []
    ltitle = []
    data = data.replace('"', '')
    for row in data.split("\r\n"):
        if titleFlag == 0:
            for cell in row.split(","):
                ltitle.append(cell.upper())
            titleFlag = 1
        else:
            d = {}
            i = 0
            for cell in row.split(","):
                d[ltitle[i]] = cell
                i = i+1
            ldata.append(d)
    return ldata

f = csv.read('./filename.xxx')
fdata = f.read()
tmpdata = parseCSVFileStr(fdata.decode('GBK'))


posted @ 2023-06-03 14:03  太晓  阅读(6)  评论(0编辑  收藏  举报