Home:ALL Converter>Complicated string manipulation in pandas without regex

Complicated string manipulation in pandas without regex

Ask Time:2023-01-03T04:58:01         Author:Favour Onyido

Json Formatter

I just looped over a pandas column to it from out[156] to out[157] in the image attached below.

enter image description here

Now I have another column that is very complicated, is it possible to achieve the same thing without using regex (I am completely unfamiliar with regex)? I basically want the figures in float format (eg. 9ft 2in to the equivalent in inches) but there are so many different ways it was entered. enter image description here

I would appreciate any advice.

Author:Favour Onyido,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/74987001/complicated-string-manipulation-in-pandas-without-regex
yy