Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Challenge | Grouping Data
Data Manipulation using pandas
course content

Зміст курсу

Data Manipulation using pandas

Data Manipulation using pandas

1. Preprocessing Data: Part I

What is Data Preprocessing?Types consistencyPoor Data PresentationManipulating StringsChallengeReplacing Specific ElementsSimultaneous ReplacementChallenge

2. Preprocessing Data: Part II

Logical InconsistencyRemoving RowsChallengeOutliersChallengeMissing ValuesFilling NA valuesChallenge

3. Grouping Data

What is Grouping Data?Grouping in pandas [1/2]ChallengeGrouping in pandas [2/2]ChallengeGrouping by Several ColumnsChallenge

4. Aggregating and Visualizing Data

Advanced Aggregation [1/2]ChallengeAdvanced Aggregation [2/2]ChallengeHistogramsChallengeBar and Scatter PlotsOther Types of GraphsChallenge 1Challenge 2

5. Joining Data

What is Joining Data?Left JoinRight JoinInner JoinOuter JoinConcatenation

Challenge

Practice grouping data by finding out average prices for each dwelling type.

Завдання

  1. Group the data in the df dataframe by the values of the 'dtypeh' column.
  2. Select the 'valueh', 'grosrth' columns.
  3. Calculate mean values across groups.

Завдання

  1. Group the data in the df dataframe by the values of the 'dtypeh' column.
  2. Select the 'valueh', 'grosrth' columns.
  3. Calculate mean values across groups.
DESCRIPTIONCODE
Single-detached house1
Apartment in build. 5+ storeys2
Apartment in build. <5 storeys3
Semi-detached house4
Apartment in a detached duplex5
Row house6
Other single-attached house7
Mobile home or other movable8

Все було зрозуміло?

Секція 3. Розділ 5
toggle bottom row

Challenge

Practice grouping data by finding out average prices for each dwelling type.

Завдання

  1. Group the data in the df dataframe by the values of the 'dtypeh' column.
  2. Select the 'valueh', 'grosrth' columns.
  3. Calculate mean values across groups.

Завдання

  1. Group the data in the df dataframe by the values of the 'dtypeh' column.
  2. Select the 'valueh', 'grosrth' columns.
  3. Calculate mean values across groups.
DESCRIPTIONCODE
Single-detached house1
Apartment in build. 5+ storeys2
Apartment in build. <5 storeys3
Semi-detached house4
Apartment in a detached duplex5
Row house6
Other single-attached house7
Mobile home or other movable8

Все було зрозуміло?

Секція 3. Розділ 5
toggle bottom row

Challenge

Practice grouping data by finding out average prices for each dwelling type.

Завдання

  1. Group the data in the df dataframe by the values of the 'dtypeh' column.
  2. Select the 'valueh', 'grosrth' columns.
  3. Calculate mean values across groups.

Завдання

  1. Group the data in the df dataframe by the values of the 'dtypeh' column.
  2. Select the 'valueh', 'grosrth' columns.
  3. Calculate mean values across groups.
DESCRIPTIONCODE
Single-detached house1
Apartment in build. 5+ storeys2
Apartment in build. <5 storeys3
Semi-detached house4
Apartment in a detached duplex5
Row house6
Other single-attached house7
Mobile home or other movable8

Все було зрозуміло?

Practice grouping data by finding out average prices for each dwelling type.

Завдання

  1. Group the data in the df dataframe by the values of the 'dtypeh' column.
  2. Select the 'valueh', 'grosrth' columns.
  3. Calculate mean values across groups.
DESCRIPTIONCODE
Single-detached house1
Apartment in build. 5+ storeys2
Apartment in build. <5 storeys3
Semi-detached house4
Apartment in a detached duplex5
Row house6
Other single-attached house7
Mobile home or other movable8

Секція 3. Розділ 5
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
We're sorry to hear that something went wrong. What happened?
some-alt