Challenge
Let's compare mean and median 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'
column. - For each group calculate mean and median (in this order).
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')
# Mean and median price for each dwelling type
print(df.groupby('dtypeh')['valueh'].agg(['mean', 'median']))
War alles klar?
Danke für Ihr Feedback!
Abschnitt 4. Kapitel 2
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')
# Mean and median price for each dwelling type
print(df.___('___')___.agg(['___', '___']))
Fragen Sie AI
Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen