Skip to content

Instantly share code, notes, and snippets.

@axmakarov
axmakarov / 0_reuse_code.js
Created June 1, 2016 08:35
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@axmakarov
axmakarov / 2016-06-01 Metrika API New User Params 01.txt
Last active June 1, 2016 08:44
Yandex.Metrika API request for getting search engines and search queries with grouping by user ID
https://beta.api-metrika.yandex.ru/stat/v1/data?dimensions=ym:s:specialUser,ym:s:dateTime,ym:s:lastSourceEngine,ym:s:lastSearchPhrase&metrics=ym:s:users,ym:s:visits&date1=2016-05-01&date2=2016-05-31&ids=<ids>&oauth_token=<token>&limit=100000&offset=1&filters=ym:s:lastTrafficSource==%27organic%27
@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')
@axmakarov
axmakarov / 2016-06-01 Metrika API New User Params 03
Last active June 1, 2016 12:50
Yandex.Metrika API request for getting users info
https://beta.api-metrika.yandex.ru/stat/v1/data?dimensions=ym:u:userID,ym:u:userVisits,ym:u:totalVisitsDuration,ym:u:userFirstVisitDate,ym:u:firstSourceEngine,ym:u:gender&metrics=ym:u:users&date1=2016-05-01&date2=2016-05-31&ids=<id>&oauth_token=<token>&limit=100000&offset=1
@axmakarov
axmakarov / 2016-06-01 Metrika API New User Params 04
Created June 1, 2016 12:50
Yandex.Metrika API request for getting users info with filter by user source
https://beta.api-metrika.yandex.ru/stat/v1/data?dimensions=ym:u:userID,ym:u:userVisits,ym:u:totalVisitsDuration,ym:u:userFirstVisitDate,ym:u:firstSourceEngine,ym:u:gender&metrics=ym:u:users&date1=2016-05-01&date2=2016-05-31&ids=<ids>&oauth_token=<token>&limit=100000&offset=1&filters=EXISTS(ym:s:searchEngineRoot=='google')
@axmakarov
axmakarov / 2016-06-01 Metrika API New User User Params 05
Created June 1, 2016 14:12
Yandex.Metrika API request for getting Yandex.Direct campaigns and phrases with grouping by user ID
https://beta.api-metrika.yandex.ru/stat/v1/data?dimensions=ym:s:specialUser,ym:s:directID,ym:s:lastDirectSearchPhrase&metrics=ym:s:users,ym:s:visits&date1=2016-05-01&date2=2016-05-31&ids=<id>&oauth_token=<token>&limit=100000&offset=1&filters=ym:s:lastAdvEngine='ya_direct'
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
import pandas as pd
books = pd.read_csv('books.csv',sep=',',error_bad_lines=False)
display(books)
books.groupby('authors').mean()