Course Content
Analyzing and Visualizing Real-Life Data
2. Preprocessing Data: Part II
Analyzing and Visualizing Real-Life Data
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.
Task
- 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.
Everything was clear?
Section 1. Chapter 5
