Python - KeyError: 14425L

Question

When I use this code, it prints everything alright, and then gives me an error: KeyError: 14425L The code:

i = 0
while (i <= len(data)):
    print data.ix[i]['Params']
    i += 1

btw:

data.keys()
Out[67]: Index([u'Email Address', u'Hashed Email', u'Timestamp', u'Session Index', u'Event', u'Description', u'Version', u'Platform', u'Device', u'Params'], dtype=object)

Why are you looping over indices using an explicit `while` loop? It *must* be possible to use a plain `for` instead(which prevents this kind of errors, and has less overhead). — Bakuriu, Aug 03 '13 at 12:44
Iterating by index is unpythonic - it's slow, hard to read, and only works on sequences, not arbitrary iterables. — Gareth Latty, Aug 03 '13 at 12:55

score 3 · Accepted Answer · edited May 23 '17 at 11:43

3

Python list indices are 0 based, so len(data) is not a valid index.

Use

while (i < len(data)):

instead.

However, it looks like you are looping over a Pandas dataframe. You may want to review iterating row by row through a pandas dataframe and What is the most efficient way to loop through dataframes with pandas?

edited May 23 '17 at 11:43

Community

1
1

answered Aug 03 '13 at 12:42

Martijn Pieters

1,048,767
296
4,058
3,343

Thanks. Sorry for the dumb question :) – erantdo Aug 03 '13 at 13:09

score 2 · Answer 2 · answered Aug 03 '13 at 12:42

2

You are accessing index past the last one. Maximum index of a list is len(data) - 1.

while (i <= len(data)):

should be:

while (i < len(data)):

answered Aug 03 '13 at 12:42

Rohit Jain

209,639
45
409
525

Python - KeyError: 14425L

2 Answers2