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

book
Challenge

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

Aufgabe

Swipe to start coding

  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.

Lösung

# Importing the library
import pandas as pd

# Reading the file
df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/f2947b09-5f0d-4ad9-992f-ec0b87cd4b3f/data4.csv')

# Group data and calculate means
print(df.groupby('dtypeh')[['valueh', 'grosrth']].mean())
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

War alles klar?

Wie können wir es verbessern?

Danke für Ihr Feedback!

Abschnitt 3. Kapitel 5
single

single

# Importing the library
import pandas as pd

# Reading the file
df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/f2947b09-5f0d-4ad9-992f-ec0b87cd4b3f/data4.csv')

# Group data and calculate means
print(df.___('___')[['___', '___']].___)

Fragen Sie AI

expand

Fragen Sie AI

ChatGPT

Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen

some-alt