python 3 csv file - attribute error

Question

I am trying to read in the following csv file:

https://github.com/eljefe6a/nfldata/blob/master/stadiums.csv

I copied and pasted the contents it into excel and save it as a csv file because it is in a unix format.

and I get the following attribute error message

Any help appreciated. Thank you.

import sys
import csv
with open('stadium.csv', newline='') as csvfile:
      readCSV = csv.reader(csvfile,delimiter=',')
      for line in readCSV:
          line = line.strip()
          unpacked = line.split(",")
          stadium, capacity, expanded, location, surface, turf, team, opened, weather, roof, elevation = line.split(",")
          results = [turf, "1"]
          print("\t".join(results))

Error:

Traceback (most recent call last):
  File "C:/Python34/mapper.py", line 31, in <module>
    line = line.strip()
AttributeError: 'list' object has no attribute 'strip'

I donno why you split again line.split(",")

Avinash Raj
– Avinash Raj

2015-07-12 04:22:46 +00:00
Commented Jul 12, 2015 at 4:22 — Avinash Raj
– Avinash Raj, Commented Jul 12, 2015 at 4:22

Seizo Otto · Accepted Answer · 2015-07-12 04:25:48Z

1

When you call .strip() on line it doesn't work because line is a list type object. Strip is method that only applies to strings. If I'm correct about what you're trying to do the correct way to unpack the variables would be:

stadium, capacity, expanded, location, surface, turf, team, opened, weather, roof, elevation = line[0], line[1], line[2], line[3], line[4], line[5], line[6], line[7], line[8], line[9], line[10]

The above works because you put the location of the value in the list (line) within the brackets and unpack the values into their respective variables. Then call you can do:

stadium.split()

for example.

answered Jul 12, 2015 at 4:25

Seizo Otto

113 bronze badges

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

Comments

Anand S Kumar · Accepted Answer · 2015-07-12 04:23:16Z

0

When you are using csv module, with delimiter as ',' and when you do -

for line in readCSV:

line is actually each row in the csv, and the row would be a list of all elements in that row, delimited by ',' . You actually do not need to strip or split them again.

You can try -

import sys
import csv
with open('stadium.csv', newline='') as csvfile:
    readCSV = csv.reader(csvfile,delimiter=',')
    for line in readCSV:
        stadium, capacity, expanded, location, surface, turf, team,opened, weather, roof, elevation = line
        results = [turf, "1"]
        print("\t".join(results))

Please do make sure that the elements you do unpacking are there in the csv.

answered Jul 12, 2015 at 4:23

Anand S Kumar

91.4k18 gold badges196 silver badges179 bronze badges

2 Comments

user4745212 Over a year ago

Thanks. I just added in the elements and they are the column names with the first letter in upper case. I am now getting this error message: Traceback (most recent call last): File "C:/Python34/mapper.py", line 30, in <module> Stadium, Capacity, Expanded, Location, Surface, Turf, Team,Opened, Weather, Roof, Elevation NameError: name 'Stadium' is not defined

user4745212 Over a year ago

I forgot to enclosed them in quotes, so it works now. Thanks

Rob Kennedy · Accepted Answer · 2015-07-12 04:23:50Z

0

The CSV reader already separates all the fields for you. That is, your line variable is already a list, not a string, so there's nothing to strip and nothing to split. Use line the way you intended to use unpacked.

That's why you're using the csv package in the first place, remember.

answered Jul 12, 2015 at 4:23

Rob Kennedy

164k23 gold badges288 silver badges481 bronze badges

Collectives™ on Stack Overflow

python 3 csv file - attribute error

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related