/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

2 votes357 views3 answers
Matplotlib show plot
Python
1 vote305 views2 answers
How to print without space in python 3
Python
0 vote365 views1 answer
Autofield in django
Python Django
0 vote372 views2 answers
Set environment variable heroku django
Python Django
0 vote317 views1 answer
Django authenticate with email
Python
0 vote320 views1 answer
Mirror 2d numpy array
Python
0 vote346 views1 answer
Python r2 score
Python
0 vote375 views1 answer
Add row in db django
Python Django
2 votes292 views1 answer
Give a function a name python
Python
0 vote318 views1 answer
R Return each result with an index
Python