Challenge
Practice grouping data by finding out average prices for each dwelling type.
Aufgabe
Swipe to start coding
- Group the data in the
df
dataframe by the values of the'dtypeh'
column. - Select the
'valueh', 'grosrth'
columns. - Calculate mean values across groups.
Lösung
9
1
2
3
4
5
6
7
8
# 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())
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 |
War alles klar?
Danke für Ihr Feedback!
Abschnitt 3. Kapitel 5
single
9
1
2
3
4
5
6
7
8
# 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
Fragen Sie AI
Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen