finding maximum value form csv column

Question

dataset=[]
f= open('auto-mpg-data.csv')
csv_f=csv.reader(f)
for row in csv_f:
    dataset.append(row)

#reading column
mpg=[]
for row in dataset:
    mpg.append(row[0])
print(mpg)

print(max(mpg))

this is the data. When I try to find the maximum value from this list it show 9 instead of 46.6. How can I get this value?

acw1668 · Accepted Answer · 2016-08-18 05:12:52Z

1

The problem is that the items of the list mpg are strings, so the result is true as '9' is greater than '46.6' when comparing strings. You should convert the items in the list mpg to float numbers first:

mpg = [float(row[0]) for row in dataset]

answered Aug 18, 2016 at 5:12

acw1668

48k5 gold badges30 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

finding maximum value form csv column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related