Save results to csv file with Python

by

I know the question is asking about your “csv” package implementation, but for your information, there are options that are much simpler — numpy, for instance.

import numpy as np
np.savetxt('data.csv', (col1_array, col2_array, col3_array), delimiter=",")

(This answer posted 6 years later, for posterity’s sake.)

In a different case similar to what you’re asking about, say you have two columns like this:

names = ['Player Name', 'Foo', 'Bar']
scores = ['Score', 250, 500]

You could save it like this:

np.savetxt('scores.csv', [p for p in zip(names, scores)], delimiter=",", fmt="%s")

scores.csv would look like this:

Player Name,Score
Foo,250
Bar,500

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. Reading data from a CSV file in Python
  13. How to efficiently handle European decimal separators using the pandas read_csv function?
  14. Python Pandas read_csv skip rows but keep header
  15. Python : Compare two csv files and print out differences
  16. Pandas – Strip white space
  17. Loading UTF-8 file in Python 3 using numpy.genfromtxt
  18. Filter string data based on its string length
  19. Why is pandas.to_datetime slow for non standard time format such as ‘2014/12/31’
  20. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x96 in position 35: invalid start byte
  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. ValueError: not enough values to unpack (expected 11, got 1)
  27. how to specify the datetime format in read_csv
  28. Convert nested JSON to CSV file in Python
  29. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  30. Python: Writing Nested Dictionary to CSV

Leave a Comment