Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"metadata": { | |
"name": "", | |
"signature": "sha256:b558204f751fde84d16bf429dd76b6bd17dc0901bd51c746c7dbfc3e3a09f71e" | |
}, | |
"nbformat": 3, | |
"nbformat_minor": 0, | |
"worksheets": [ | |
{ | |
"cells": [ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Connect to database | |
import os | |
import pandas as pd | |
from sqlalchemy import create_engine | |
hostname = "127.0.0.1" | |
username = os.environ['DB_USERNAME'] | |
db_name = os.environ['DB_NAME'] | |
password = os.environ['MYSQL_PWD'] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!doctype html> | |
<html> | |
<head> | |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> | |
<title>D3.js sandbox</title> | |
<script src="http://d3js.org/d3.v2.js"></script> | |
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> | |
<script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- La première requète pour les projets ayant le plus de fork | |
SELECT repository_name, MIN(repository_forks) as mini, MAX(repository_forks) as maxi, MAX(repository_forks) - MIN(repository_forks) as diff | |
FROM githubarchive:github.timeline WHERE type = "ForkEvent" AND LENGTH(actor_attributes_location) > 3 AND repository_forks > 200 | |
GROUP BY repository_name | |
ORDER BY maxi DESC; | |
-- La deuxième requète pour la localisation et le nombre de fork en fonction du temps | |
SELECT created_at, actor_attributes_location, repository_forks | |
FROM githubarchive:github.timeline WHERE type = "ForkEvent" AND LENGTH(actor_attributes_location) > 3 AND repository_name = "bootstrap" AND repository_owner = "twitter" AND repository_fork = "false" | |
ORDER BY repository_forks |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<html> | |
<head> | |
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/> | |
<title>d3.js Spinny Globe from Mike Bostock's SVG Open 2011 keynote</title> | |
<script src="http://mbostock.github.com/d3/d3.js"></script> | |
<script src="http://mbostock.github.com/d3/d3.geo.js"></script> | |
<link type="text/css" rel="stylesheet" href="http://mbostock.github.com/d3/talk/20111018/style.css"/> | |
<link type="text/css" rel="stylesheet" href="http://mbostock.github.com/d3/talk/20111018/colorbrewer/colorbrewer.css"/> | |
<style type="text/css"> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def chunks(l, n): | |
""" Yield successive n-sized chunks from l. | |
Cf. http://stackoverflow.com/a/312464 | |
""" | |
for i in xrange(0, len(l), n): | |
yield l[i:i+n] |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
"""UTC time conversion functions. | |
""" | |
from calendar import timegm | |
from datetime import datetime | |
def utcdt2epoch(utcdatetime): | |
"""Convert a datetime object expressed in UTC to a Unix timestamp expressed | |
in seconds since the epoch (Jan 1st 1970). | |
""" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-----BEGIN PGP PUBLIC KEY BLOCK----- | |
Version: GnuPG v1.4.9 (GNU/Linux) | |
mQGhBEqdGmsRBACATgfXCQEbnW+OEjVxC41zALr9onmMeKiMIK1HT0D44Wm2BK4A | |
+w0CFgp+86FLFx+BBQlnWwmHAJDhietAgkcrKpbhh/bK2KsZcRLiL7qtu/ljuHVK | |
ZOryVCnGomDOSIkg4gyNJaSFqxh0u8rm/iHqA7Emdzh9qvVC1cZAgnWCewCg6INj | |
Ca2JUcD42wagxE66uvWRNQcD+M4bTYjdghMKjWdw4MvzXNrx3ewuJIsZoEvHQvkS | |
S4jDxRuubp6qVDiGFdGkgWO/mrWThuWMpmOrqY0AXdvzxstmQa2X4lhkpoj444II | |
XVQ91R29lIZWNV7j4UBOR5Kncpn0ZS5bt2P1yOlFcMswbryhK2AZgu8B4mi7CmJ/ | |
trED/1kwTrwehIYxer/hxnTwGKqr+CsRNRTaO4800ftUoD/dmSWEOc7Kxpuo/V/d |
OlderNewer