I have a panda’s dataframe with strings, but I want floats. The units on the strings are different though. One column might be in mm with a few in cm. The next column might be g with a few in kg, and so on.

How can I convert each to floats in the same units? (i.e. if I’m changing everything to floats in mm, then “4.56 cm” should convert to 45.6, not 4.56).