Course Content
Data Manipulation using pandas
Data Manipulation using pandas
2. Preprocessing Data: Part II
Challenge
Now it's your turn to remove rows with wrong data!
Task
Swipe to begin your solution
- Get indexes of rows having 'inconsistent' data. Follow the next steps:
-
Apply the
.loc[]
property to thedf
dataframe. -
Set condition on rows: row sums of 2-14 columns (
[2:15]
) must be not equal to values in the'hhsize'
column. -
Use the
.index
attribute.
- Drop rows using indexes saved within
ind
variable. Set theinplace
parameter to rewrite the changes.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?
Thanks for your feedback!
Section 2. Chapter 3
Challenge
Now it's your turn to remove rows with wrong data!
Task
Swipe to begin your solution
- Get indexes of rows having 'inconsistent' data. Follow the next steps:
-
Apply the
.loc[]
property to thedf
dataframe. -
Set condition on rows: row sums of 2-14 columns (
[2:15]
) must be not equal to values in the'hhsize'
column. -
Use the
.index
attribute.
- Drop rows using indexes saved within
ind
variable. Set theinplace
parameter to rewrite the changes.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?
Thanks for your feedback!
Section 2. Chapter 3
Switch to desktop for real-world practiceContinue from where you are using one of the options below