(df['Currency'].replace( '[$,)]','', regex=True ) .replace( '[(]','-', regex=True ).astype(float)) Currency 0 1 1 2000 2 -3000