Markwin Markwin - 7 months ago 39
Python Question

Python Read csv file in a column?

Is it possible to read

files in columns instead of rows in python?

e.g. if i have a csv file like this:

a b c
1 0 1
1 4 1

How would one get a list of
or something of the sorts?


You are looking for transpose functionality. To solve your problem,

  1. First read csv as rows and create row wise tuples in a list ex: [(a,b,c),(1,0,1),(1,4,1)..]
  2. Transpose above list using any of the solutions present in Transpose a matrix in Python.

Post transpose , your data will look like [(a,1,1),(b,0,4)..]