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

0 vote389 views1 answer
Save multiple df to pkl
Python
0 vote367 views1 answer
How to add phone number to django user model
Python Django
0 vote333 views1 answer
C# script for download music from telegram channel
Python
0 vote370 views1 answer
%%writefile jupyter
Python
0 vote345 views2 answers
Python int to ascii string
Python
0 vote346 views2 answers
Convert iterator to list python
Python
22 votes356 views6 answers
Factorial in python
Python
0 vote334 views2 answers
Pandas convert entries in a column after groupby in list
Python
0 vote345 views1 answer
Convert a pdf folder to excell pandas
Python
-2 votes334 views1 answer
No connection could be made because the target machine actively refused it python
Python