Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #34223

Re: CSV out of range

Show all headers | View raw

On Tue, Dec 4, 2012 at 12:31 PM, Thomas Bach
<thbach@students.uni-mainz.de> wrote:
> Hi there,
>
> Please be a bit more precise…
>
> On Tue, Dec 04, 2012 at 12:00:05PM +0100, Anatoli Hristov wrote:
>>
>> The problem comes when I try to index the SKU array and the field is
>> empty
>
> Can you provide an example for that?
>
>> and it seems that there I have empty array, I wanted to ignore the
>> empty arrays using if statement, but it does the same.
>
> Please provide a small, runable example with the actual code you tried
> that raises the exception and the complete trace back.
>
> Regards,
>         Thomas Bach.
> --
> http://mail.python.org/mailman/listinfo/python-list

Ok as I said I run a small script, here it is:

>>> import csv
>>>
>>> file = open("ShopPrices.csv", "rbU")
>>> reader = csv.reader(file, delimiter=";")
>>> mylist = []
>>> for i in reader:
...     mylist.append(i)
...
>>> mylist[543]
['19ITN992575', '19I', 'TN', '992575', 'RAB-UP-750-H3', 'Triton 19"
heavy duty 150kg shelf plate 750mm 1U black', '39,93', '0', '', '',
'', '', '', '', '', '', '', '', '']
>>> sku = []
>>> for x in mylist:
...     sku.append(x[4])
...
Traceback (most recent call last):
  File "<stdin>", line 2, in ?
IndexError: list index out of range

>>> sku[43]
'PDM2332IEC-3P30R-3'
>>>

It appends all the data till it comes one SKU with empty record ("") .
I tried to use tey and except, but still the same

Thanks

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: CSV out of range Anatoli Hristov <tolidtm@gmail.com> - 2012-12-04 13:36 +0100

csiph-web