Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Removing Characters: Method 2 | Preprocessing Data: Part I
Analyzing and Visualizing Real-World Data
close
SectionΒ 1. ChapterΒ 5
single

single

bookRemoving 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.

Task

Swipe to start coding

  1. Define a lambda function with a single argument x that 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 the rm variable.
  2. Apply the rm function 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.
  3. Perform the same actions described in the step 2 for the 'Unemployment' column.
  4. Perform the same actions described in the step 2 for the 'Temperature' column.
  5. Display the first row of the df dataframe and data types of the df dataframe.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 5
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

some-alt