Why can’t I repeat the ‘for’ loop for csv.Reader?

by

The csv reader is an iterator over the file. Once you go through it once, you read to the end of the file, so there is no more to read. If you need to go through it again, you can seek to the beginning of the file:

fh.seek(0)

This will reset the file to the beginning so you can read it again. Depending on the code, it may also be necessary to skip the field name header:

next(fh)

This is necessary for your code, since the DictReader consumed that line the first time around to determine the field names, and it’s not going to do that again. It may not be necessary for other uses of csv.

If the file isn’t too big and you need to do several things with the data, you could also just read the whole thing into a list:

data = list(read)

Then you can do what you want with data.

More Related Contents:

  1. How do I create a python code that distinguishes between the capital of a state and the state that the capital has?
  2. How do I read a large csv file with pandas?
  3. How to add pandas data to an existing csv file?
  4. How to ignore the first line of data when processing CSV data?
  5. Create a .csv file with values from a Python list
  6. Change specific value in CSV file via Python
  7. TypeError: a bytes-like object is required, not ‘str’ in python and CSV
  8. _csv.Error: field larger than field limit (131072)
  9. Pandas split column into multiple columns by comma
  10. Remove file after Flask serves it
  11. General Unicode/UTF-8 support for csv files in Python 2.6
  12. Convert commas decimal separators to dots within a Dataframe
  13. Read data from CSV file and transform from string to correct data-type, including a list-of-integer column
  14. Inline CSV File Editing with Python
  15. ‘utf-8’ codec can’t decode byte 0xa0 in position 4276: invalid start byte
  16. What does ‘killed’ mean when processing a huge CSV with Python, which suddenly stops?
  17. Convert HTML into CSV
  18. How to *actually* read CSV data in TensorFlow?
  19. Deleting rows with Python in a CSV file
  20. pyqt – populating QTableWidget with csv data
  21. Simple CSV to XML Conversion – Python
  22. csv.writer writing each character of word in separate column/cell
  23. Pandas ParserError EOF character when reading multiple csv files to HDF5
  24. Python Pandas – Read csv file containing multiple tables
  25. Is there a way to speed up handling large CSVs and dataframes in python?
  26. Strip white spaces from CSV file
  27. Get data from Twitter using Tweepy and store in csv file
  28. How to add a new column to the beginning of the rows of a CSV file?
  29. Python Parse CSV Correctly
  30. start index at 1 for Pandas DataFrame

Leave a Comment