typeerror '_csv.reader' object is not subscriptable [duplicate]

Question

When I try to open a file in python I get the error, typeerror '_csv.reader' object is not subscriptable. The code is as below, can someone kindly help me please

with open(file) as f:  
    reader = csv.reader(f, delimiter='\t')  
    for line in reader:  
        oldseq, city, state, newseq = line

The error is here, in the following code, for line in reader[:1]:

with open(newfile) as f:  
    reader = csv.reader(f, delimiter='\t')  
    for line in reader[:1]:  
        oldseq, city, state, newseq = line

I need to just skip the first line as it has headers, thats why I was doing reader[:1]

If you show us the full traceback, we most likely can help you find where the real problem is occurring. It is not in the code you posted. — Martijn Pieters
– Martijn Pieters, Commented Feb 3, 2014 at 12:17
I just updated the code & now Im pointing to the error, can you please help — user1345260
– user1345260, Commented Feb 3, 2014 at 12:23
You are trying to skip the header of the CSV file. Slicing doesn't work, use reader.next() instead to skip the first row. — Martijn Pieters
– Martijn Pieters, Commented Feb 3, 2014 at 12:27

Martijn Pieters · Accepted Answer · 2014-02-03 12:49:38Z

5

You cannot slice a reader object; you can skip the first row with:

with open(newfile) as f:  
    reader = csv.reader(f, delimiter='\t')
    next(reader, None)  # skip header
    for line in reader:  
        oldseq, city, state, newseq = line

edited Feb 3, 2014 at 12:49

answered Feb 3, 2014 at 12:12

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

user1345260 Over a year ago

Can you please explain the initial try command?

Martijn Pieters Over a year ago

@user1345260: Actually, I was wrong, the next() builtin was added in 2.6 already. The try tests if the name exists, in Python 2.5 trying to access next will rase a NameError and the except block then defines a Python-only implementation that does the same thing as the built-in.

Martijn Pieters Over a year ago

@user1345260: But I removed it, it is redundant here, and your question is really a dupe.

user1345260 Over a year ago

And shouldn't I remove [:1] from the line for line in reader[:1]:

Martijn Pieters Over a year ago

Yes. +++ OUT OF CAFFIENE ERROR +++ REDO FROM START +++ (e.g. my mistake, sorry)

|

Collectives™ on Stack Overflow

typeerror '_csv.reader' object is not subscriptable [duplicate]

1 Answer 1

7 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Linked

Related