CSV工具类是Python中的自带包,用来解析CSV文件。
- 实例化一个CSV对象,需要传入一个CSV文件的路径
with open('./case.csv') as casefile
csv.DictReader()
将CSV读取成字典的形式
rows2 = csv.DictReader(casefile)
print rows2
# [{'paxID': '111', 'daxID': '222', 'merID': '333'}, {'paxID': '444', 'daxID': '555', 'merID': '666'}]
- 取一个值
rows2[rowNum][colunmName]
print rows2[2]['paxID']
#444
csv.reader()
将CSV读取成list
rows = csv.reader(casefile)
row_list = [row for row in rows]
print row_list
# [['paxID', 'daxID', 'merID'], ['111', '222', '333'], ['444', '555', '666']]
- 封装一个csv 工具类