Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Pandas replace string to Float

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:

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

/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/

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading