I want to remove the "HKD $" and change to Float object
I use below command line but it doesnt work.
df['price_list_1'] = df['price_list_1'].str.replace("HKD $","")
The result:
/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:1: FutureWarning: The default value of regex will change from True to False in a future version.
"""Entry point for launching an IPython kernel.
0 $14
1 $20
2 $55
3 $20
4 $50
...
647 $58
648 $20
649 $46
650 $70
651 $70
Name: price_list_1, Length: 652, dtype: object
>Solution :
When you use .str.replace(), you should be care that if the string value includes any special characters of regular expressions such as $, ^, and *, in this case, $.
To explicity say ‘$’ is not for regular expression, you can use regex=False.
df['price_list_1'] = df['price_list_1'].str.replace("HKD $","", regex=False)
For your information about using regular expression in str.replace: see https://datascientyst.com/replace-values-regex-pandas/