Skip to content

Instantly share code, notes, and snippets.

View axmakarov's full-sized avatar

axmakarov

1 follower · 0 following
View GitHub Profile
@axmakarov
axmakarov / groupby_tutorial_05.py
Created August 14, 2019 20:09
books.groupby('authors')[['ratings_count','average_rating']].describe()
@axmakarov
axmakarov / groupby_tutorial_06.py
Created August 14, 2019 20:12
books[books['authors'] == 'J.K. Rowling-Mary GrandPré']
@axmakarov
axmakarov / groupby_tutorial_07.py
Created August 14, 2019 20:15
values = books[books['authors'] == 'J.K. Rowling-Mary GrandPré']['average_rating'].values
values
@axmakarov
axmakarov / groupby_tutorial_08.py
Created August 14, 2019 20:16
sum(values)/len(values)
@axmakarov
axmakarov / groupby_tutorial_09.py
Created August 14, 2019 20:17
books[books['authors'] == 'J.K. Rowling-Mary GrandPré']['average_rating'].mean()
@axmakarov
axmakarov / groupby_tutorial_10.py
Created August 14, 2019 20:18
books['average_rating'].mean()
@axmakarov
axmakarov / groupby_tutorial_11.py
Created August 14, 2019 20:21
grouped_df = books.groupby('authors').mean()
grouped_df.loc['A.M. Homes']
@axmakarov
axmakarov / groupby_tutorial_12.py
Created August 14, 2019 20:23
books.groupby('authors',as_index=False).mean()
@axmakarov
axmakarov / groupby_tutorial_13.py
Created August 14, 2019 20:25
books.groupby('authors').mean().reset_index()
@axmakarov
axmakarov / 2016-06-01 Metrika API New User Params 02
Last active September 18, 2019 14:41
Yandex.Metrika API request for getting visits data of users with specific first visit date
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')