Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Challenge | Preprocessing Data: Part II
Data Manipulation using pandas
course content

Course Content

Data Manipulation using pandas

Data Manipulation using pandas

1. Preprocessing Data: Part I
2. Preprocessing Data: Part II
3. Grouping Data
4. Aggregating and Visualizing Data
5. Joining Data

bookChallenge

Let's replace the negative values in the 'empinch' and 'invsth' columns with zeros using the .where() method.

Task
test

Swipe to show code editor

  1. Select the 'empinch' and 'invsth' columns.
  2. Apply the .where() method to chosen columns.
  3. Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
  4. Set the parameter what values must be used instead of replaced ones.

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 2. Chapter 5
toggle bottom row

bookChallenge

Let's replace the negative values in the 'empinch' and 'invsth' columns with zeros using the .where() method.

Task
test

Swipe to show code editor

  1. Select the 'empinch' and 'invsth' columns.
  2. Apply the .where() method to chosen columns.
  3. Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
  4. Set the parameter what values must be used instead of replaced ones.

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 2. Chapter 5
toggle bottom row

bookChallenge

Let's replace the negative values in the 'empinch' and 'invsth' columns with zeros using the .where() method.

Task
test

Swipe to show code editor

  1. Select the 'empinch' and 'invsth' columns.
  2. Apply the .where() method to chosen columns.
  3. Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
  4. Set the parameter what values must be used instead of replaced ones.

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!

Let's replace the negative values in the 'empinch' and 'invsth' columns with zeros using the .where() method.

Task
test

Swipe to show code editor

  1. Select the 'empinch' and 'invsth' columns.
  2. Apply the .where() method to chosen columns.
  3. Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
  4. Set the parameter what values must be used instead of replaced ones.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Section 2. Chapter 5
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt