Colin Weinshenker caweinshenker

caweinshenker / active-issues.sql

Created August 5, 2017 07:45 — forked from alysonla/active-issues.sql

Queries that power the open source section of the 2016 Octoverse report https://octoverse.github.com/

	-- Active issues
	-- Count of total active issues in the specified time frame
	-- Source: githubarchive public data set via Google BigQuery http://githubarchive.org/

	SELECT
	COUNT(DISTINCT JSON_EXTRACT_SCALAR(events.payload, '$.issue.id')) AS events_issue_count
	FROM (SELECT * FROM TABLE_DATE_RANGE([githubarchive:day.],TIMESTAMP('2015-09-01'),TIMESTAMP('2016-08-31')))
	AS events

	-- 10,723,492 active issues

caweinshenker / min-char-rnn.py

Created September 20, 2016 14:20 — forked from karpathy/min-char-rnn.py

Minimal character-level language model with a Vanilla Recurrent Neural Network, in Python/numpy

	"""
	Minimal character-level Vanilla RNN model. Written by Andrej Karpathy (@karpathy)
	BSD License
	"""
	import numpy as np

	# data I/O
	data = open('input.txt', 'r').read() # should be simple plain text file
	chars = list(set(data))
	data_size, vocab_size = len(data), len(chars)