Python: putting rows data from a csv file into a list

Question

I have a CSV file in the same directory as my Python script, and I would like to take that data and turn it into a list that I can use later. I would prefer to use Python's CSV module. After reading the the module's documentation and questions regarding it, I have still not found any help.

Code

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import csv
inputfile = 'inputfile.csv'

inputm = []

reader = csv.reader(inputfile)

for row in reader:
    inputm.append(row)

inputfile.csv

point1,point2,point3,point4
0,1,4,1 
0,1,1,1 
0,1,4,1 
0,1,0,0
0,1,2,1 
0,0,0,0 
0,0,0,0 
0,1,3,1 
0,1,4,1

It only returns the string of the filename I provide it.

[['i'], ['n'], ['p'], ['u'], ['t'], ['f'], ['i'], ['l'], ['e']]

I would like it to return each row of the CSV file as a sub-list instead of each letter of the filename as a sub-list.

point1,point2,point3,point4 0,1,4,1 0,1,1,1 0,1,4,1 0,1,0,00,1,2,1 0,0,0,0 0,0,0,0 0,1,3,1 0,1,4,1 — some_person
– some_person, Commented Mar 27, 2017 at 3:53

Keerthana Prabhakaran · Accepted Answer · 2017-03-27 03:56:48Z

3

You need to open the file in read mode, read the contents! That is,

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import csv
inputfile = 'inputfile.csv'

inputm = []

with open(inputfile, "rb") as f:
    reader = csv.reader(f, delimiter="\t")
    for row in reader:
        inputm.append(row)

Output:

[['point1,point2,point3,point4'], ['0,1,4,1'], ['0,1,1,1'], ['0,1,4,1'], ['0,1,0,0'], ['0,1,2,1'], ['0,0,0,0'], ['0,0,0,0'], ['0,1,3,1'], ['0,1,4,1']]

edited Mar 27, 2017 at 3:56

answered Mar 27, 2017 at 3:43

Keerthana Prabhakaran

3,8071 gold badge16 silver badges25 bronze badges

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

Comments

AChampion · Accepted Answer · 2017-03-27 03:45:49Z

1

You actually need to open() the file:

inputfile = open('inputfile.csv')

You may want to look at the with statement:

with open('inputfile.csv') as inputfile:
    reader = csv.reader(inputfile)
    inputm = list(reader)

answered Mar 27, 2017 at 3:45

AChampion

30.5k4 gold badges63 silver badges79 bronze badges

Collectives™ on Stack Overflow

Python: putting rows data from a csv file into a list

Code

inputfile.csv

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Code

inputfile.csv

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related