Markwin Markwin - 1 year ago 63
Python Question

Python Read csv files 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?

Answer Source

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download