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

  
## 2016-06-01 Metrika API New User Params 02
https://beta.api-metrika.yandex.ru/stat/v1/data?dimensions=ym:s:specialUser,ym:s:dateTime,ym:s:lastTrafficSource,ym:s:lastSourceEngine&metrics=ym:s:visits,ym:s:avgDaysSinceFirstVisit&date1=2016-05-01&date2=2016-05-31&ids=<id>&oauth_token=<token>&limit=100000&offset=1&filters=EXISTS(ym:u:userFirstVisitDate=='2016-05-13')

## 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é']
	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