/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 vote299 views1 answer
Apply 2d mask to 3d array python
Python
0 vote320 views2 answers
Reset repo
Python
0 vote300 views2 answers
Random seed generator minecraft
Python
-1 vote320 views1 answer
Set form field disabled django
Python Django
0 vote343 views1 answer
Python elasticsearch docker from within other container
Python
1 vote313 views1 answer
Py file open with
Python
1 vote317 views1 answer
Order by listview django
Python
0 vote327 views1 answer
Seeparate string without split function python
Python
0 vote319 views1 answer
Selenium page down key python
Python
0 vote294 views1 answer
Check if array is monotonic python
Python