Markwin Markwin - 17 days ago 6
Python Question

Python Read csv file in a column?

Is it possible to read

csv
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
[a,1,1],[b,0,4],[c,1,1]
or something of the sorts?

Answer

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)..]