How to convert csv string to float? [duplicate]

Question

I have export.csv file, with data

name,total
candy,10
ice cream,15
potatoe chips,20

when i read the .csv file with this code

with open('files/export.csv','r') as file_csv:
    read= list(csv.reader(file_csv))
    for row in read:
        print(row)

Turns out that the data in the total column is a string data type not a float. I want the output be like this:

"name","total"
"candy",10
"ice cream",15
"potatoe chips",20

So I can sum and take the total column data.

The float builtin can convert a string to a float as long as it is in Python's literal float format. — Masklinn
– Masklinn, Commented Dec 11, 2020 at 7:13

costaparas · Accepted Answer · 2020-12-11 07:18:46Z

2

To convert the 2nd field into floats, the following should work for you:

import csv

with open('files/export.csv','r') as file_csv:
    read = list(csv.reader(file_csv))
    for i, row in enumerate(read):
        if i > 0:
            row[1] = float(row[1])
        print(row)

Though do note, that here, we have to skip the first row (header) to apply the conversion only to the data itself.

answered Dec 11, 2020 at 7:18

costaparas

5,24711 gold badges21 silver badges28 bronze badges

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

Comments

Sohaib Anwaar · Accepted Answer · 2020-12-11 07:16:02Z

1

Try to read it with pandas. Give really strong support to csv files.

Code

import pandas
pandas.read_csv('files/export.csv')

Results

answered Dec 11, 2020 at 7:16

Sohaib Anwaar

1,5572 gold badges15 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to convert csv string to float? [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related