Skip to content

Instantly share code, notes, and snippets.

Avatar

Akshay Shah akshayjshah

View GitHub Profile
View knights.py
import functools
moves = {
0: [4, 6],
1: [6, 8],
2: [7, 9],
3: [4, 8],
4: [0, 3, 9],
5: [],
@akshayjshah
akshayjshah / github_archive_query.sql
Last active Feb 23, 2021
Calculate and plot correlations between the most popular languages on GitHub.
View github_archive_query.sql
/* Fetch data from GitHub Archive using Google's BigQuery */
select actor, repository_language, count(repository_language) as pushes
from [githubarchive:github.timeline]
where type='PushEvent'
and repository_language != ''
and PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC('2012-01-01 00:00:00')
and PARSE_UTC_USEC(created_at) < PARSE_UTC_USEC('2013-01-01 00:00:00')
group by actor, repository_language;