판다스 groupby 활용법_Day 32

When should I use a 'groupby' in pandas?

import pandas as pd

drinks = pd.read_csv("http://bit.ly/drinksbycountry")

drinks.head()

 

drinks.beer_servings.mean()

106.16062176165804

 

drinks.groupby('continent').beer_servings.mean()

continent

Africa 61.471698

Asia 37.045455

Europe 193.777778

North America 145.434783

Oceania 89.687500

South America 175.083333

Name: beer_servings, dtype: float64

drinks.groupby('continent').beer_servings.agg(['count','min','max','mean'])

drinks[drinks.continent=='Africa']

drinks.groupby('continent').mean()

%matplotlib inline

drinks.groupby('continent').mean().plot(kind='bar')

출처 : youtu.be/qy0fDqoMJx8