/Python/Pandas replace % with calculated

Pandas replace % with calculated

def FormatPerc(x): # Create the function to be applied
    perc = 0
    x = str(x)
    
    if '%' in x:
        x = x.replace("%","")
        perc = float(x)*0.001
    else:
        x = x.replace("%","")
        perc = float(x)   
    
    return perc
  
# in your pandas script:
investments['WithdrawPercentage'] = investments['WithdrawPercentage'].apply(FormatPerc)
# any values like "xx.x%" will now be formatted as 0.xxx

Source: stackoverflow.com

Similar codes

0 vote226 views1 answer
How to remove blank lines from string in python
Python
0 vote228 views1 answer
How to show Screen keyboard ubuntu with python
Python
8 votes205 views2 answers
How to clear the list in python
Python
0 vote251 views1 answer
Get nonzero min numpy
Python
0 vote253 views1 answer
Unable to import flask pylint
Python Flask
0 vote220 views1 answer
Split a string by comma in python
Python
0 vote255 views1 answer
Whitelist the ip address django
Python Django
0 vote225 views1 answer
Sqlalchemy filter between dates
Python
1 vote218 views1 answer
Django sites framework
Python Django
0 vote235 views1 answer
Check cudann
Python