I have a df with currency:
df = pd.DataFrame({'Currency':['$1.00','$2,000.00','(3,000.00)']})
Currency
0 $1.00
1 $2,000.00
2 (3,000.00)
I want to convert the 'Currency' dtype to float but I am having trouble with the parentheses string (which indicate a negative amount). This is my current code:
df[['Currency']] = df[['Currency']].replace('[$,]','',regex=True).astype(float)
which produces an error:
ValueError: could not convert string to float: (3000.00)
What I want as dtype float is:
Currency
0 1.00
1 2000.00
2 -3000.00
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…