使用python读取CSV文件时打印特定元素

Question

假设我有下面的数据集

10,"XG16008168",9/12/2017 0:00:00,9/13/2017 0:00:00,2/23/2018 0:00:00,"Whatever","07210","25978","Main","Yes",3/9/2018 0:00:00,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,,0,0,0,0,0,0,0,0,0,1,,0,,0,,0,0,0,0,0,1,0,0,0,0,0,0,,0,
11,"X000000000",11/30/2017 0:00:00,9/25/2017 0:00:00,2/27/2018 0:00:00,"Whatever 004","07210","25978","Main","Yes",3/9/2018 0:00:00,,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,,0,0,0,0,0,0,0,0,0,1,"Missing valve number.",0,,0,,0,0,0,0,0,0,1,0,0,0,0,0,,0,

我使用以下方法读取此CSV文件：

^{pr2}$

我正在尝试打印CSV文件的一个元素。在

所以，通过打印row[1][1]我期望"X000000000"，但是我得到了{}，这是{}中的第二个字符。在

你能告诉我如何提取元素吗？在

Answer 1

显示的是row，而不是rows，因此显示的是每行第二个元素中的一个字符。在

Answer 2

您正在使用第[1][1]行，但应该是第[1]行。在

尝试在pythonshell中打印行，您将能够轻松地分析事情。每个项目的索引值示例，行是项目列表。在

with open("/home/lavanya/Desktop/AccessTable.txt", "r") as RTCData:

    with open("RTCOutput.csv", "w") as RTCOutput:

        ALLRows = csv.reader(RTCData, delimiter=',')

        for row in ALLRows:

            rows.append(row)
            print row
            print(row[1][1])

Answer 3

>>> import csv
>>> with open('eggs.csv', 'rb') as csvfile:
...     spamreader = csv.reader(csvfile, delimiter=' ', quotechar='|')
...     for row in spamreader:
...         print(', '.join(row))
Spam, Spam, Spam, Spam, Spam, Baked Beans
Spam, Lovely Spam, Wonderful Spam