Python csv how many rows

Amir Amir 9, 9 9 gold badges 42 42 silver badges 69 69 bronze badges. This is very handy for integrating into a python script. Alex Troush Alex Troush 4 4 silver badges 10 10 bronze badges. When i write this answer, topic haven't information about csv is csv reader object. Certainly a fastest solution. I'd recommend renaming the len variable as it's overwriting the built-in function.

Use "list" to fit a more workably object. You can then count, skip, mutate till your heart's desire: list fileObject list values len list fileObject get length of file lines list fileObject [] skip first 10 lines. Sean Sean 2, 2 2 gold badges 22 22 silver badges 30 30 bronze badges.

Sadman Sakib Sadman Sakib 1 1 silver badge 4 4 bronze badges. Arthur Gatignol Arthur Gatignol 53 6 6 bronze badges.

If you're reading it as a DataFrame you don't need a loop you can just do len df — pyjamas. Parvathirajan Natarajan 1, 11 11 silver badges 28 28 bronze badges. What if you have line breaks inside double quotes? That should still be considered part of the same record. CSV wc -l. Abramodj Abramodj 5, 9 9 gold badges 45 45 silver badges 73 73 bronze badges. Ruben Romo Ruben Romo 17 2 2 bronze badges.

Just stumbling across stuff, seems this shape comment isn't so bad and actually comparatively very fast: stackoverflow. Oh but you'll want to do a data. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta.

Now live: A fully responsive profile. Linked See more linked questions. Leave a Reply Cancel reply Your email address will not be published. This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website.

We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience. Necessary Necessary. Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website.

Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics. Using a counter. And in the end, we will be printing the rowcount value.

Skip to content. Change Language. Related Articles. Table of Contents. Save Article. Improve Article.