Pandas - convert to float

Question

I have a column where many of the values has double dot structure. e.g. 0.00076181.1.

I would like to convert them into a normal float64 value.

Is there any easy way to do this?

Thanks

Answer 1

I use regex to delete last occurance of dot when string contains two dots. i use also numpy.float64 to convert string to float64.

Finally you can do like this :

import numpy
import re

list1 = ["0.00076181.1", "0.00076181.2", "0.00076181.3", "0.000761813", "0.1"]
for i in range(0,len(list1)):
    if list1[i].count(".") == 2:
        list1[i] = re.sub(r".(\w)$", r"\1", list1[i])
        
print([numpy.float64(i) for i in list1])

Output :

[0.000761811, 0.000761812, 0.000761813, 0.000761813, 0.1]