Conteúdo do Curso
Data Manipulation using pandas
Data Manipulation using pandas
2. Preprocessing Data: Part II
Challenge
Practice grouping data by finding out average prices for each dwelling type.
Tarefa
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Select the
'valueh', 'grosrth'
columns. - Calculate mean values across groups.
Tarefa
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Select the
'valueh', 'grosrth'
columns. - Calculate mean values across groups.
DESCRIPTION | CODE |
Single-detached house | 1 |
Apartment in build. 5+ storeys | 2 |
Apartment in build. <5 storeys | 3 |
Semi-detached house | 4 |
Apartment in a detached duplex | 5 |
Row house | 6 |
Other single-attached house | 7 |
Mobile home or other movable | 8 |
Tudo estava claro?
Challenge
Practice grouping data by finding out average prices for each dwelling type.
Tarefa
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Select the
'valueh', 'grosrth'
columns. - Calculate mean values across groups.
Tarefa
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Select the
'valueh', 'grosrth'
columns. - Calculate mean values across groups.
DESCRIPTION | CODE |
Single-detached house | 1 |
Apartment in build. 5+ storeys | 2 |
Apartment in build. <5 storeys | 3 |
Semi-detached house | 4 |
Apartment in a detached duplex | 5 |
Row house | 6 |
Other single-attached house | 7 |
Mobile home or other movable | 8 |
Tudo estava claro?
Challenge
Practice grouping data by finding out average prices for each dwelling type.
Tarefa
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Select the
'valueh', 'grosrth'
columns. - Calculate mean values across groups.
Tarefa
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Select the
'valueh', 'grosrth'
columns. - Calculate mean values across groups.
DESCRIPTION | CODE |
Single-detached house | 1 |
Apartment in build. 5+ storeys | 2 |
Apartment in build. <5 storeys | 3 |
Semi-detached house | 4 |
Apartment in a detached duplex | 5 |
Row house | 6 |
Other single-attached house | 7 |
Mobile home or other movable | 8 |
Tudo estava claro?
Practice grouping data by finding out average prices for each dwelling type.
Tarefa
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Select the
'valueh', 'grosrth'
columns. - Calculate mean values across groups.
DESCRIPTION | CODE |
Single-detached house | 1 |
Apartment in build. 5+ storeys | 2 |
Apartment in build. <5 storeys | 3 |
Semi-detached house | 4 |
Apartment in a detached duplex | 5 |
Row house | 6 |
Other single-attached house | 7 |
Mobile home or other movable | 8 |