Course Content
Data Manipulation using pandas
Data Manipulation using pandas
2. Preprocessing Data: Part II
Challenge
Let's replace the negative values in the 'empinch'
and 'invsth'
columns with zeros using the .where()
method.
Task
- Select the
'empinch'
and'invsth'
columns. - Apply the
.where()
method to chosen columns. - Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
- Set the parameter what values must be used instead of replaced ones.
Task
- Select the
'empinch'
and'invsth'
columns. - Apply the
.where()
method to chosen columns. - Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
- Set the parameter what values must be used instead of replaced ones.
Everything was clear?
Challenge
Let's replace the negative values in the 'empinch'
and 'invsth'
columns with zeros using the .where()
method.
Task
- Select the
'empinch'
and'invsth'
columns. - Apply the
.where()
method to chosen columns. - Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
- Set the parameter what values must be used instead of replaced ones.
Task
- Select the
'empinch'
and'invsth'
columns. - Apply the
.where()
method to chosen columns. - Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
- Set the parameter what values must be used instead of replaced ones.
Everything was clear?
Challenge
Let's replace the negative values in the 'empinch'
and 'invsth'
columns with zeros using the .where()
method.
Task
- Select the
'empinch'
and'invsth'
columns. - Apply the
.where()
method to chosen columns. - Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
- Set the parameter what values must be used instead of replaced ones.
Task
- Select the
'empinch'
and'invsth'
columns. - Apply the
.where()
method to chosen columns. - Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
- Set the parameter what values must be used instead of replaced ones.
Everything was clear?
Let's replace the negative values in the 'empinch'
and 'invsth'
columns with zeros using the .where()
method.
Task
- Select the
'empinch'
and'invsth'
columns. - Apply the
.where()
method to chosen columns. - Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
- Set the parameter what values must be used instead of replaced ones.