Replacing Unicode character in pandas Dataframe column

Question

I have a problem with a pandas Dataframe that amongst other things contains the number of rooms in an apartment (type String).

This data consists of a unicode character u"\u00BD" (https://www.fileformat.info/info/unicode/char/00bd/index.htm).

How do i effectively replace this character with decimal values so that instead of the unicode character the data will read 2.5, 3.5, 4.5 etc (Still String format).

It currently looks like this: 2½, 3½, 4½ etc And i want the values in the column to be 2.5, 3.5, 4.5 etc.

Possible duplicate of How do I convert unicode characters to floats in Python? — Minje Jeon
– Minje Jeon, Commented Mar 24, 2018 at 18:52
If Udi's code had not worked I could have tried this, thanks for the help! — DGrannas
– DGrannas, Commented Mar 25, 2018 at 9:51

Udi · Accepted Answer · 2018-03-24 19:45:20Z

1

You can fix your column with:

df['rooms'] = df['rooms'].str.replace("½", ".5")

To make it a float:

df['rooms'] = df['rooms'].str.replace("½", ".5").apply(float)

answered Mar 24, 2018 at 19:45

Udi

30.8k9 gold badges105 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Replacing Unicode character in pandas Dataframe column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related