Course Content
Data Manipulation using pandas
Data Manipulation using pandas
2. Preprocessing Data: Part II
Challenge
Let's find out median number of people dwelling (median is more appropriate since we are working with integers) and mean total income for each type of dwelling.
Task
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Find out median value of the
'hhsize'
column and mean value of the'totinch'
column across each group.
Task
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Find out median value of the
'hhsize'
column and mean value of the'totinch'
column across each group.
Everything was clear?
Challenge
Let's find out median number of people dwelling (median is more appropriate since we are working with integers) and mean total income for each type of dwelling.
Task
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Find out median value of the
'hhsize'
column and mean value of the'totinch'
column across each group.
Task
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Find out median value of the
'hhsize'
column and mean value of the'totinch'
column across each group.
Everything was clear?
Challenge
Let's find out median number of people dwelling (median is more appropriate since we are working with integers) and mean total income for each type of dwelling.
Task
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Find out median value of the
'hhsize'
column and mean value of the'totinch'
column across each group.
Task
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Find out median value of the
'hhsize'
column and mean value of the'totinch'
column across each group.
Everything was clear?
Let's find out median number of people dwelling (median is more appropriate since we are working with integers) and mean total income for each type of dwelling.
Task
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Find out median value of the
'hhsize'
column and mean value of the'totinch'
column across each group.