really like the number funcation a lot since i am using regex and getting a lot of funny data for numbers.
but what about when they express a negative with () instead of a negative symbol?
this does regex does not always work on data and cleaning with your parseNumber would be a great combo.
df = df.replace('[\$,)]', '', regex=True).replace('[(]', '-', regex=True).astype(float)
really like the number funcation a lot since i am using regex and getting a lot of funny data for numbers.
but what about when they express a negative with () instead of a negative symbol?
this does regex does not always work on data and cleaning with your parseNumber would be a great combo.