Removing Characters: Method 2
As mentioned, there are two ways to remove a character from all column values. The second method uses a lambda function. How does it work? You define a lambda function that removes a certain character/characters from a function variable, and apply it to the selected column. Then you convert obtained values to the necessary type and save them.
Swipe to start coding
- Define a lambda function with a single argument
xthat will look for and delete any of the characters'$°C%'from both the left and right sides (using the.strip()method). Assign the function to thermvariable. - Apply the
rmfunction to the'Fuel_Price'column and then convert it to numerical type (float) using the.astype()method. Assign the obtained result to the same column. - Perform the same actions described in the step 2 for the
'Unemployment'column. - Perform the same actions described in the step 2 for the
'Temperature'column. - Display the first row of the
dfdataframe and data types of thedfdataframe.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 3.45Removing Characters: Method 2
Swipe to show menu
As mentioned, there are two ways to remove a character from all column values. The second method uses a lambda function. How does it work? You define a lambda function that removes a certain character/characters from a function variable, and apply it to the selected column. Then you convert obtained values to the necessary type and save them.
Swipe to start coding
- Define a lambda function with a single argument
xthat will look for and delete any of the characters'$°C%'from both the left and right sides (using the.strip()method). Assign the function to thermvariable. - Apply the
rmfunction to the'Fuel_Price'column and then convert it to numerical type (float) using the.astype()method. Assign the obtained result to the same column. - Perform the same actions described in the step 2 for the
'Unemployment'column. - Perform the same actions described in the step 2 for the
'Temperature'column. - Display the first row of the
dfdataframe and data types of thedfdataframe.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
Awesome!
Completion rate improved to 3.45single
