Cleaning Data Basics P12

[genesix32]

Correct

laptops["weight"] = laptops["weight"].str.replace("kgs","").str.replace("kg","").astype(float)

Results in error : ValueError: could not convert string to float: ‘4s’

laptops["weight"] = laptops["weight"].str.replace("kg","").str.replace("kgs","").astype(float)

Why does flipping the order of kg and kgs causes the error? Thanks for the guidance

[Prem]

Hi @genesix32

Please go through the below post, and it will help you to understand why flipping the order gives an error.

Data Cleaning Basics 12/14

Why do I get an error when I tried to do laptops[“weight”] = laptops[“weight”].str.replace(“kg”,"").str.replace(“kgs”,"").astype(float)?It says ValueError: could not convert string to float: ‘4s’ The correct one was laptops[“weight”] =laptops[“weight”].str.replace(“kgs”,"").str.replace(“kg”,"").astype(float); the only difference is the position of “kgs” and “kg”

Thank You