How to transpose a dataset in a csv file?

by

If the whole file contents fits into memory, you can use

import csv
from itertools import izip
a = izip(*csv.reader(open("input.csv", "rb")))
csv.writer(open("output.csv", "wb")).writerows(a)

You can basically think of zip() and izip() as transpose operations:

a = [(1, 2, 3),
     (4, 5, 6),
     (7, 8, 9)]
zip(*a)
# [(1, 4, 7),
#  (2, 5, 8),
#  (3, 6, 9)]

izip() avoids the immediate copying of the data, but will basically do the same.

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. Transpose list of lists
  3. How do I read a large csv file with pandas?
  4. How to add pandas data to an existing csv file?
  5. Create a .csv file with values from a Python list
  6. Transpose column to row with Spark
  7. Change specific value in CSV file via Python
  8. TypeError: a bytes-like object is required, not ‘str’ in python and CSV
  9. _csv.Error: field larger than field limit (131072)
  10. Pandas split column into multiple columns by comma
  11. Remove file after Flask serves it
  12. General Unicode/UTF-8 support for csv files in Python 2.6
  13. Inline CSV File Editing with Python
  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. Python Pandas – Read csv file containing multiple tables
  24. Transpose the data in a column every nth rows in PANDAS
  25. Is there a way to speed up handling large CSVs and dataframes in python?
  26. Strip white spaces from CSV file
  27. Get data from Twitter using Tweepy and store in csv file
  28. How to add a new column to the beginning of the rows of a CSV file?
  29. Python Parse CSV Correctly
  30. start index at 1 for Pandas DataFrame

Leave a Comment