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

book
Challenge

Let's find out how many dwellings of each type are in the dataframe. Below the task description you can find code meanings.

Oppgave

Swipe to start coding

  1. Group the values of the df dataframe by the 'dtypeh' column values.
  2. Get the number of rows (size) within each group.

Løsning

# 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 sizes
print(df.groupby('dtypeh').size())
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

Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 3. Kapittel 3
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.___('___').___)

Spør AI

expand

Spør AI

ChatGPT

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

some-alt