axmakarov

## praktikum_10.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                axmakarov
                / praktikum_10.md
            
            
              Last active
              November 12, 2019 14:06
            
          
    Скачиваем в локальную репу yum последние версии постгреса
sudo yum localinstall https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Устанавливаем 10ый постгрес
sudo yum install -y postgresql10-server.x86_64 postgresql10-contrib.x86_64 postgresql10-libs.x86_64

  
## groupby_tutorial_13.py
books.groupby('authors').mean().reset_index()

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

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

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

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

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

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

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

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