Challenge
Let's compare mean and median prices for each dwelling type.
Tarefa
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).
Solução
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']))
Tudo estava claro?
Obrigado pelo seu feedback!
Seção 4. Capítulo 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(['___', '___']))
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo