s = "hello % world" s.replace(' %', '') # Need space before % else output is "hello world" # Output: "hello world"
df['col'] = df['col'].str.rstrip('%').astype('float') / 100.0