Hugues Demers hdemers

## pydata-science.sh
mkvirtualenv datascience
sudo apt-get install python-scipy libblas-dev liblapack-dev gfortran
sudo apt-get install libffi-dev  # for cryptography from scrapy
sudo apt-get install libxslt-dev  # for libxml from scrapy
export BLAS=/usr/lib/libblas.so
export LAPACK=/usr/lib/liblapack.so
pip install numpy
pip install scipy
pip install scikit-learn
pip install pandas

## index.html
<!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">

## bigqueries.sql
-- 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

## d3sandbox.html
<!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>
	mkvirtualenv datascience
	sudo apt-get install python-scipy libblas-dev liblapack-dev gfortran
	sudo apt-get install libffi-dev # for cryptography from scrapy
	sudo apt-get install libxslt-dev # for libxml from scrapy
	export BLAS=/usr/lib/libblas.so
	export LAPACK=/usr/lib/liblapack.so
	pip install numpy
	pip install scipy
	pip install scikit-learn
	pip install pandas
	<!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">
	-- 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