[Tutor] ignoring certain lines while reading through CSV

Abhishek Pratap abhishek.vit at gmail.com
Sat Jan 28 00:18:10 CET 2012


Thansk Joel. Thats exactly what I am doing.

-A

On Fri, Jan 27, 2012 at 3:04 PM, Joel Goldstick
<joel.goldstick at gmail.com> wrote:
> On Fri, Jan 27, 2012 at 5:48 PM, Abhishek Pratap <abhishek.vit at gmail.com> wrote:
>> Hi Joel
>>
>> Here is a sample
>>
>> ['1', 'AAAAAAA', '4344', '0.001505'] : want to keep this one
>>
>> ['#', 'AAAAAAA', '4344', '0.001505'] : and throw this one
>
> Ok, so you are getting single quotes around your data.  So do
> row[0].startswith("#") to test your row.
> You may be able to test for row[0]=="#" if you always get only the #
> in the first position of the row.
>>
>>
>> You are right I am checking after parsing. I dint find an option in
>> csv.reader to ignore lines.
>>
>> -Abhi
>>
>>
>>
>>
>>
>> On Fri, Jan 27, 2012 at 2:42 PM, Joel Goldstick
>> <joel.goldstick at gmail.com> wrote:
>>> On Fri, Jan 27, 2012 at 5:13 PM, Abhishek Pratap <abhishek.vit at gmail.com> wrote:
>>>> Hi Guys
>>>>
>>>> I am wondering if there is a keyword to ignore certain lines ( for eg
>>>> lines starting with # ) when I am reading them through stl module csv.
>>>>
>>>> Example code:
>>>>
>>>> input_file = sys.argv[1]
>>>> csv.register_dialect('multiplex_info',delimiter=' ')
>>>>
>>>> with open(input_file, 'rb') as fh:
>>>>    reader= csv.reader(fh,'multiplex_info')
>>>>    for row in reader:
>>>>        print row
>>>>
>>>>
>>>> best,
>>>> -Abhi
>>>> _______________________________________________
>>>> Tutor maillist  -  Tutor at python.org
>>>> To unsubscribe or change subscription options:
>>>> http://mail.python.org/mailman/listinfo/tutor
>>>
>>> You could look up the docs for csv.reader, but if there isn't, in your
>>> for loop you can use row[0].startswith('"#")  to check if your line
>>> starts with #.
>>> Can you show what the row looks like?
>>>
> --
> Joel Goldstick


More information about the Tutor mailing list