How to create a matrix from a csv file?

Question

I have been trying for two hours to create a table of values from a matrix and so far i have been able to create a column from the csv file. I know this is going to be easy for everybody, but when reading from a csv file, i cant seem to phrase it right so would people please put me in the right direction?

import csv

file = open('data.csv', 'rU')
reader = csv.reader(file)

for row in reader:
    print row[0]

so far I can only print out the first column, any advice guys?

what exactly are you trying to do? print the data.csv? if so, just do print row instead of print row[0] — Deusdeorum
– Deusdeorum, Commented May 8, 2016 at 16:18

martineau · Accepted Answer · 2016-05-08 16:46:39Z

1

You can do it with a list comprehension:

import csv

with open('data.csv', 'rU') as file:
    table = [row for row in csv.reader(file)]

print(table)

This will create a list of lists where each sublist is a row of the csv file.

answered May 8, 2016 at 16:46

martineau

124k29 gold badges181 silver badges319 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ohad Eytan · Accepted Answer · 2016-05-08 16:28:25Z

0

In your code row is a list of all the columns, So:

row[0] is the first column, row[1] is the second etc.

you can write:

print(str(row))

to print all the columns, or iterate over the with:

for column in row:
    print(column)

edited May 8, 2016 at 16:28

answered May 8, 2016 at 16:21

Ohad Eytan

8,5341 gold badge24 silver badges32 bronze badges

2 Comments

entercaspa Over a year ago

thanks man that is much appreciated much easier way to see that actually... so basically after

Ohad Eytan Over a year ago

@entercaspa great. you can mark the answer as correct if its solved your question.

Collectives™ on Stack Overflow

How to create a matrix from a csv file?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related