Challenge
Let's find out the average prices for each pair of number of rooms - number of bedrooms in a dwelling.
Tarea
Swipe to start coding
- Group the values in the
dfdataframe by values of'roomh', 'broomh'columns. - Select the
'valueh'column. - Calculate means for each group.
Solución
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')
# Grouping and aggregating data
print(df.groupby(['roomh', 'broomh'])['valueh'].mean())
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 3. Capítulo 7
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')
# Grouping and aggregating data
print(df.___([___])___.___())
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
