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
- 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.
Task
- 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.
Everything was clear?
Challenge
Now it's your turn to remove rows with wrong data!
Task
- 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.
Task
- 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.
Everything was clear?
Challenge
Now it's your turn to remove rows with wrong data!
Task
- 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.
Task
- 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.
Everything was clear?
Now it's your turn to remove rows with wrong data!
Task
- 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.