转载:https://automatetheboringstuff.com/2e/chapter16/
import csv
exampleFile = open('C:\\Users\\del\\Desktop\\123.csv')
exampleReader = csv.reader(exampleFile)
print(type(exampleReader)) #<class '_csv.reader'>
exampleData = list(exampleReader) #转换为list列表,这样才方便访问
print(exampleData)
print('--------------------------------------1')
print(exampleData[0])
print(exampleData[1])
print(exampleData[2])
print(exampleData[3])
print('--------------------------------------2')
print(exampleData[0][0])
print(exampleData[0][1])
print(exampleData[0][2])
print('--------------------------------------3')
for row in exampleData:
print(row)
执行结果:
C:\Python38\pythonw.exe C:/Users/del/PycharmProjects/untitled1/cs/api.py
<class '_csv.reader'>
[['4/4/2015 13:34', '苹果', '11'], ['4/5/2015 3:41', '香蕉', '22'], ['4/6/2015 12:46', '橘子', '33'], ['4/8/2015 8:59', '栗子', '44']]
--------------------------------------1
['4/4/2015 13:34', '苹果', '11']
['4/5/2015 3:41', '香蕉', '22']
['4/6/2015 12:46', '橘子', '33']
['4/8/2015 8:59', '栗子', '44']
--------------------------------------2
4/4/2015 13:34
苹果
11
--------------------------------------3
['4/4/2015 13:34', '苹果', '11']
['4/5/2015 3:41', '香蕉', '22']
['4/6/2015 12:46', '橘子', '33']
['4/8/2015 8:59', '栗子', '44']
Process finished with exit code 0