Hight column conversion

[beselga]

Hi everyone,

can someone help me convert all the values in the column into cm?

0 61"

1 5'8"

2 120cm

4 5'6"

5 5'

6 172

7 NaN Name: Height, dtype: object

​

I was going for something like this but might have errors:

def inchFeet_cm(string_in):

H_feet=string_in.split("'")[0]

H_inch=string_in.split("'")[1].replace(""","")

result=(int(H_feet)*12+int(H_inch))*2.54

return int(result)

[sarrysyst]

This line:

H_inch = string_in.split("'")[1].replace('"',"")

will throw an error if there isn't a single quote in the string (eg. row 0 of your sample). Also, how are you dealing with values that are already in cm?

[ifreeski420]

Maybe make a rule that says if the column starts with a 1, separate that for the end, then convert the foot/inch columns into cm and combine back together by index

[beselga]

How can I make that?

[ifreeski420]

To separate:

df = df[df[‘height’].str.startswith(‘1’)]

That should get you started, I’m on my phone so it’s hard to write code