CSVWriter not saving data to file the moment I write it

by

Use

with open('myfile.csv','wb') as myfile:
    wrtr = csv.writer(myfile, delimiter=",", quotechar=""")
    for row in rows:
        wrtr.writerow([row.field1,row.field2,row.field3])
        myfile.flush() # whenever you want

or 

myfile = open('myfile.csv','wb')
wrtr = csv.writer(myfile, delimiter=",", quotechar=""")
for row in rows:
    wrtr.writerow([row.field1,row.field2,row.field3])
    myfile.flush() # whenever you want, and/or
myfile.close() # when you're done.

The nice thing about the first approach is that your file will also be automatically properly closed in case of an Exception.

If you want your file object to be anonymous, then it will only be closed when the program exits. When or whether it is flushed depends on the OS – so it might be never until exit.

More Related Contents:

  1. A simple maths operation on a CSV column using python [closed]
  2. How can I convert JSON to CSV?
  3. Skip the headers when editing a csv file using Python
  4. How to add a new column to a CSV file?
  5. Skip rows during csv import pandas
  6. How to avoid Python/Pandas creating an index in a saved csv?
  7. datetime dtypes in pandas read_csv
  8. Python CSV error: line contains NULL byte
  9. How do I convert this list of dictionaries to a csv file?
  10. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  11. sort csv by column
  12. csv.Error: iterator should return strings, not bytes
  13. Compare two CSV files and search for similar items
  14. Python Dictionary to CSV
  15. Is it possible to keep the column order using csv.DictReader?
  16. OSError: Initializing from file failed on csv in Pandas
  17. ValueError : I/O operation on closed file
  18. Writing to a particular cell using csv module in python
  19. Writing List of Strings to Excel CSV File in Python
  20. Load CSV file with PySpark
  21. Python UTF-16 CSV reader
  22. Read specific columns with pandas or other python module
  23. load csv into 2D matrix with numpy for plotting
  24. Read random lines from huge CSV file
  25. Load CSV to Pandas MultiIndex DataFrame
  26. How to count top 10 most common values in a dict in python
  27. Why is the Python CSV reader ignoring double-quoted fields?
  28. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?
  29. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment