Python: CSV write by column rather than row

by

The reason csv doesn’t support that is because variable-length lines are not really supported on most filesystems. What you should do instead is collect all the data in lists, then call zip() on them to transpose them after.

>>> l = [('Result_1', 'Result_2', 'Result_3', 'Result_4'), (1, 2, 3, 4), (5, 6, 7, 8)]
>>> zip(*l)
[('Result_1', 1, 5), ('Result_2', 2, 6), ('Result_3', 3, 7), ('Result_4', 4, 8)]

More Related Contents:

  1. A simple maths operation on a CSV column using python [closed]
  2. How to write a python code which copies a unique column from an output file to a .csv file
  3. How can I convert JSON to CSV?
  4. Skip the headers when editing a csv file using Python
  5. How to avoid Python/Pandas creating an index in a saved csv?
  6. datetime dtypes in pandas read_csv
  7. Python CSV error: line contains NULL byte
  8. How do I convert this list of dictionaries to a csv file?
  9. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  10. csv.Error: iterator should return strings, not bytes
  11. Compare two CSV files and search for similar items
  12. Pandas read csv file with float values results in weird rounding and decimal digits
  13. Key error when selecting columns in pandas dataframe after read_csv
  14. How to delete columns in a CSV file?
  15. Precision lost while using read_csv in pandas
  16. Python Pandas: How to read only first n rows of CSV files in?
  17. Prevent pandas read_csv treating first row as header of column names
  18. Modify an existing Excel file using Openpyxl in Python
  19. read and write on same csv file
  20. Writing to a particular cell using csv module in python
  21. Writing List of Strings to Excel CSV File in Python
  22. Load CSV file with PySpark
  23. Python UTF-16 CSV reader
  24. Read specific columns with pandas or other python module
  25. load csv into 2D matrix with numpy for plotting
  26. Read .csv file from URL into Python 3.x – _csv.Error: iterator should return strings, not bytes (did you open the file in text mode?)
  27. Pandas read_csv dtype read all columns but few as string
  28. csv: writer.writerows() splitting my string inputs
  29. How can I stop Python’s csv.DictWriter.writerows from adding empty lines between rows in Windows?
  30. How to convert csv to json in python?

Leave a Comment