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

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

Let's find out the average prices for each pair of number of rooms - number of bedrooms in a dwelling.

Task

  1. Group the values in the df dataframe by values of 'roomh', 'broomh' columns.
  2. Select the 'valueh' column.
  3. Calculate means for each group.

Task

  1. Group the values in the df dataframe by values of 'roomh', 'broomh' columns.
  2. Select the 'valueh' column.
  3. Calculate means for each group.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 3. Chapter 7
toggle bottom row

Challenge

Let's find out the average prices for each pair of number of rooms - number of bedrooms in a dwelling.

Task

  1. Group the values in the df dataframe by values of 'roomh', 'broomh' columns.
  2. Select the 'valueh' column.
  3. Calculate means for each group.

Task

  1. Group the values in the df dataframe by values of 'roomh', 'broomh' columns.
  2. Select the 'valueh' column.
  3. Calculate means for each group.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 3. Chapter 7
toggle bottom row

Challenge

Let's find out the average prices for each pair of number of rooms - number of bedrooms in a dwelling.

Task

  1. Group the values in the df dataframe by values of 'roomh', 'broomh' columns.
  2. Select the 'valueh' column.
  3. Calculate means for each group.

Task

  1. Group the values in the df dataframe by values of 'roomh', 'broomh' columns.
  2. Select the 'valueh' column.
  3. Calculate means for each group.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Let's find out the average prices for each pair of number of rooms - number of bedrooms in a dwelling.

Task

  1. Group the values in the df dataframe by values of 'roomh', 'broomh' columns.
  2. Select the 'valueh' column.
  3. Calculate means for each group.

Switch to desktop for real-world practiceContinue from where you are using one of the options below
Section 3. Chapter 7
Switch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt