How to obtain the total numbers of rows from a CSV file in Python?

by

You need to count the number of rows:

row_count = sum(1 for row in fileObject)  # fileObject is your csv.reader

Using sum() with a generator expression makes for an efficient counter, avoiding storing the whole file in memory.

If you already read 2 rows to start with, then you need to add those 2 rows to your total; rows that have already been read are not being counted.

More Related Contents:

  1. Row count in a csv file
  2. create a loop inside a loop in python
  3. Writing a pandas DataFrame to CSV file
  4. How to write to a CSV line by line?
  5. How do I write data into CSV format as string (not file)?
  6. Save results to csv file with Python
  7. Using numpy.genfromtxt to read a csv file with strings containing commas
  8. Split string on commas but ignore commas within double-quotes?
  9. Read CSV file with comma within fields in Python
  10. How to keep leading zeros in a column when reading CSV with Pandas?
  11. Streaming large training and test files into Tensorflow’s DNNClassifier
  12. How do you split reading a large csv file into evenly-sized chunks in Python?
  13. python pandas read_csv delimiter in column data
  14. Why does CSV file contain a blank line in between each data line when outputting with Dictwriter in Python [duplicate]
  15. module ‘pandas’ has no attribute ‘read_csv
  16. Python CSV: Remove quotes from value
  17. Conditional row read of csv in pandas
  18. Find all CSV files in a directory using Python
  19. Calculate summary statistics of columns in dataframe
  20. Extract csv file specific columns to list in Python
  21. double quoted elements in csv cant read with pandas
  22. Python – re-ordering columns in a csv
  23. ValueError: not enough values to unpack (expected 11, got 1)
  24. how to specify the datetime format in read_csv
  25. UnicodeDecodeError when reading CSV file in Pandas
  26. How to upload a CSV file in FastAPI and convert it into JSON?
  27. Convert nested JSON to CSV file in Python
  28. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  29. ValueError: x and y must be the same size
  30. Python: Writing Nested Dictionary to CSV

Leave a Comment