axmakarov

## groupby_tutorial_04.py
books.groupby('authors').describe()

## groupby_tutorial_05.py
books.groupby('authors')[['ratings_count','average_rating']].describe()

## groupby_tutorial_06.py
books[books['authors'] == 'J.K. Rowling-Mary GrandPré']

## groupby_tutorial_07.py
values = books[books['authors'] == 'J.K. Rowling-Mary GrandPré']['average_rating'].values
values

## groupby_tutorial_08.py
sum(values)/len(values)

## groupby_tutorial_09.py
books[books['authors'] == 'J.K. Rowling-Mary GrandPré']['average_rating'].mean()

## groupby_tutorial_10.py
books['average_rating'].mean()

## groupby_tutorial_11.py
grouped_df = books.groupby('authors').mean()
grouped_df.loc['A.M. Homes']

## groupby_tutorial_12.py
books.groupby('authors',as_index=False).mean()

## groupby_tutorial_13.py
books.groupby('authors').mean().reset_index()
	values = books[books['authors'] == 'J.K. Rowling-Mary GrandPré']['average_rating'].values
	values
	grouped_df = books.groupby('authors').mean()
	grouped_df.loc['A.M. Homes']