Challenge
Let's compare mean and median prices for each dwelling type.
Tâche
Swipe to start coding
- Group the data in the
dfdataframe by the values of the'dtypeh'column. - Select the
'valueh'column. - For each group calculate mean and median (in this order).
Solution
# 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']))
Tout était clair ?
Merci pour vos commentaires !
Section 4. Chapitre 2
# 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(['___', '___']))
