How to overcome the Could not convert String to Float?

Question

Hi Everyone I'm Having This Two Columns: Mi_Meteo['Measurement'] = Mi_Meteo['Measurement'].str.rstrip(' Measure') Mi_Meteo['Measurement'].head() 0 0.8 1 0.6 2 0.4 3 0.4 4 0 Name: Measurement, dtype: object And: Mi_Meteo['Sensor_ID'] = Mi_Meteo['Sensor_ID'].str.rstrip(' ID') Mi_Meteo['Sensor_ID'].head() 0 14121 1 14121 2 14121 3 14121 4 14121 Name: Sensor_ID, dtype: object So , i tried to convert both of them to float , nut was got an error: Mi_Meteo['Measurement'] = Mi_Meteo['Measurement'].astype(float) ValueError: could not convert string to float: And: Mi_Meteo['Sensor_ID'] = Mi_Meteo['Sensor_ID'].astype(float) ValueError: could not convert string to float: Any Suggestion , would be much appreciated , thank U all. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

One possible reason could be some white space in your data which didn't clear out. Add in str.strip() before converting to float. Mi_Meteo['Measurement'] = Mi_Meteo['Measurement'].str.rstrip(' Measure').str.strip() Mi_Meteo['Measurement'] = Mi_Meteo['Measurement'].astype(float)