Writing a Python list of lists to a csv file

by

Python’s built-in CSV module can handle this easily:

import csv

with open("output.csv", "wb") as f:
    writer = csv.writer(f)
    writer.writerows(a)

This assumes your list is defined as a, as it is in your question. You can tweak the exact format of the output CSV via the various optional parameters to csv.writer() as documented in the library reference page linked above.

Update for Python 3

import csv

with open("out.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerows(a)

More Related Contents:

  1. Reading a huge .csv file
  2. How do I create a python code that distinguishes between the capital of a state and the state that the capital has?
  3. Writing a list to a file with Python
  4. open() gives FileNotFoundError/IOError: Errno 2 No such file or directory
  5. How to open a file using the open with statement
  6. Skip the headers when editing a csv file using Python
  7. How to open a file for both reading and writing?
  8. Python parse CSV ignoring comma with double-quotes
  9. Writing a list to a file with Python, with newlines
  10. Read from a log file as it’s being written using python
  11. file.tell() inconsistency
  12. Inline CSV File Editing with Python
  13. Python write to a file returns empty file
  14. Python Pandas: How to read only first n rows of CSV files in?
  15. Use Multiple Character Delimiter in Python Pandas read_csv
  16. Fastest way to process a large file?
  17. Python 2.7: Print to File
  18. Is there a need to close files that have no reference to them?
  19. ValueError : I/O operation on closed file
  20. Reading a file with a specified delimiter for newline
  21. Open files in ‘rt’ and ‘wt’ modes
  22. Convert percent string to float in pandas read_csv
  23. What is the difference between rb and r+b modes in file objects [duplicate]
  24. How can I use io.StringIO() with the csv module?
  25. How to read the last line of a file in Python? [duplicate]
  26. Python Pandas – Read csv file containing multiple tables
  27. Read random lines from huge CSV file
  28. How to count top 10 most common values in a dict in python
  29. Get data from Twitter using Tweepy and store in csv file
  30. how to count the total number of lines in a text file using python

Leave a Comment