finding out the number of rows in a CSV file [Resolved]

SimonPalmer simon.palmer at gmail.com
Wed Aug 27 07:54:43 EDT 2008


On Aug 27, 12:50 pm, SimonPalmer <simon.pal... at gmail.com> wrote:
> On Aug 27, 12:41 pm, Jon Clements <jon... at googlemail.com> wrote:
>
>
>
> > 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!
>
> Thanks to everyone for their suggestions.
>
> In my case the number of rows is never going to be that large (<200)
> so it is a practical if slightly inelegant solution

actually not resolved...

after reading the file throughthe csv.reader for the length I cannot
iterate over the rows.  How do I reset the row iterator?



More information about the Python-list mailing list