finding out the number of rows in a CSV file

Jon Clements joncle at
Wed Aug 27 13:41:19 CEST 2008

On Aug 27, 12:29 pm, "Simon Brunning" <si... at>
> 2008/8/27 SimonPalmer <simon.pal... at>:
> > 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.net

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