/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 vote157 views1 answer
Time counter in python
Python
26 votes306 views6 answers
Flask run
Python Flask
0 vote143 views1 answer
What will be the output of the following program?
Python
133 votes167 views6 answers
Input function in python
Python
2 votes145 views1 answer
Get all occurrence indices in list python
Python
-1 vote144 views1 answer
How to print memory address in python
Python
2 votes152 views2 answers
Python include another python file
Python
-1 vote148 views1 answer
Python : search file for string
Python
1 vote159 views1 answer
Discord.py owner only commands
Python
0 vote152 views1 answer
Get admin url of instance django
Python