# Get rid of $ and , in the SAL-RATE, then convert it to a float def money_to_float(money_str): return float(money_str.replace("$","").replace(",","")) df['SAL-RATE'].apply(money_to_float)