Writing List of Strings to Excel CSV File in Python

by

The csv.writer writerow method takes an iterable as an argument. Your result set has to be a list (rows) of lists (columns).

csvwriter.writerow(row)

Write the row parameter to the writer’s file object, formatted according to the current dialect.

Do either:

import csv
RESULTS = [
    ['apple','cherry','orange','pineapple','strawberry']
]
with open('output.csv','w') as result_file:
    wr = csv.writer(result_file, dialect="excel")
    wr.writerows(RESULTS)

or:

import csv
RESULT = ['apple','cherry','orange','pineapple','strawberry']
with open('output.csv','w') as result_file:
    wr = csv.writer(result_file, dialect="excel")
    wr.writerow(RESULT)

More Related Contents:

  1. Update a CSV file?
  2. How do I read and write CSV files with Python?
  3. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  4. Python convert csv to xlsx
  5. CSVWriter not saving data to file the moment I write it
  6. Python CSV to SQLite
  7. Save Dataframe to csv directly to s3 Python
  8. How to obtain the total numbers of rows from a CSV file in Python?
  9. Writing to CSV with Python adds blank lines [duplicate]
  10. Panda’s Write CSV – Append vs. Write
  11. Python DictWriter writing UTF-8 encoded CSV files
  12. Convert tab-delimited txt file into a csv file using Python
  13. Numpy loading csv TOO slow compared to Matlab
  14. Error “(unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape” [duplicate]
  15. IndexError: too many indices for array
  16. Proper way to reset csv.reader for multiple iterations?
  17. AttributeError: ‘module’ object has no attribute ‘reader’ [duplicate]
  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