csv模块

写入

import csv
address = '\test.csv'  #文件地址
#元素为字典：
#打开方式用'w'，还可以添加参数encoding='utf8'，参数newline=''可以避免空行                
with open(address,'w',newline='') as fout:
    cout = csv.DictWriter(fout,['Name','SumCount','DropCount','OutCount','InCount']) #[]list里的为CSV的表头名
    cout.writeheader()   #写入表头
    cout.writerows(data) #data是一个列表list，其中的元素是字典dict,注意字典的key要与前面表头名对应
    
#元素为列表：
#改为：
cout = csv.writer(fout)
cout.writerows(data)

读取

#读成列表：
with open(address,'r') as fin:
    cin = csv.reader(fin)
    out = [row for row in cin]
print(out)#是一个列表，每行也是个列表

#读成字典：
#原本没有表头：
with open(address,'r') as fin:
    cin = csv.DictReader(fin,filenames=['first','last'])
    out = [row for row in cin]
print(out)

#原本有表头：
with open(address,'r') as fin:
    cin = csv.DictReader(fin)
    out = [row for row in cin]
print(out)

xlrd模块

读取

import xlrd
address = 'test.xls'

def read_xls():
    outdata = []
    data = xlrd.open_workbook(address)
    table = data.sheets()[0]
    title = table.row_values(0)

    for row in range(2, table.nrows):
        rn = [i.strip() for i in table.row_values(row)]
        d = {k: v for k, v in zip(title, rn)}
        #print(d)
        outdata.append(d)
    return outdata