Extract float from csv python

Question

I have a csv file like this (name,floatNumber):

quirrell,0,000281885
flamel,0,000175286
quirrells,0,000154252

I would like to get from it all the float numbers.

for filename in os.listdir('output'):
    with open("output/"+filename, 'rt') as csvfile:
        readCSV = csv.reader(csvfile, delimiter=',')
        for row in readCSV:
            print(row[0],row[1],row[2])

Using delimiter=',', I have this output

quirrell 0 000281885
flamel 0 000175286
quirrells 0 000154252

where the number is splitted. How can I get this output and put all the float inside some variables?

quirrell, 0,000281885
flamel 0,000175286
quirrells 0,000154252

Martin Evans · Accepted Answer · 2018-02-05 12:28:55Z

1

In this case, you might find it easier not to use the CSV library:

with open('input.csv', 'r') as f_input:
    for row in f_input:
        name, value = row.strip().split(',', 1)
        value = float(value.replace(',', '.'))
        print(name, value)

This would display:

quirrell 0.000281885
flamel 0.000175286
quirrells 0.000154252

answered Feb 5, 2018 at 12:28

Martin Evans

46.9k17 gold badges88 silver badges104 bronze badges

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

Comments

Rakesh · Accepted Answer · 2018-02-05 11:34:22Z

1

You can convert it to a float after joining the string objects

Ex:

print(row[0],float(".".join([row[1],row[2]])))

answered Feb 5, 2018 at 11:34

Rakesh

82.9k17 gold badges86 silver badges122 bronze badges

Collectives™ on Stack Overflow

Extract float from csv python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related