finding out the number of rows in a CSV file

Jon Clements joncle at googlemail.com
Wed Aug 27 07:41:19 EDT 2008


On Aug 27, 12:29 pm, "Simon Brunning" <si... at brunningonline.net>
wrote:
> 2008/8/27 SimonPalmer <simon.pal... at gmail.com>:
>
> > anyone know how I would find out how many rows are in a csv file?
>
> > I can't find a method which does this on csv.reader.
>
> len(list(csv.reader(open('my.csv'))))
>
> --
> Cheers,
> Simon B.
> si... at brunningonline.nethttp://www.brunningonline.net/simon/blog/

Not the best of ideas if the row size or number of rows is large!
Manufacture a list, then discard to get its length -- ouch!



More information about the Python-list mailing list