Convert 2.9k to 2900 in python

def value_to_float(x):
    if type(x) == float or type(x) == int:
        return x
    if 'K' in x:
        if len(x) > 1:
            return float(x.replace('K', '')) * 1000
        return 1000.0
    if 'M' in x:
        if len(x) > 1:
            return float(x.replace('M', '')) * 1000000
        return 1000000.0
    if 'B' in x:
        return float(x.replace('B', '')) * 1000000000
    return 0.0

    df."Insert data series column" = df."Insert data series column" .apply(value_to_float)

Source: stackoverflow.com

Similar codes

114 votes141 views6 answers
Amc price
Python
0 vote147 views1 answer
Replace one row with another in python
Python
1 vote145 views1 answer
What does [::-1] mean in python
Python
2 votes145 views1 answer
How to square each term of numpy array python
Python
0 vote139 views1 answer
Find maximum element in stack
Python
0 vote146 views2 answers
Numpy random normal seed time
Python
29 votes164 views3 answers
Print python float precision
Python
0 vote166 views1 answer
Earthpy
Python
0 vote200 views1 answer
Django-mathfilters
Python Django
1 vote156 views1 answer
Reshape wide to long in pandas
Python