austinogilvie

import pandas as pd
pd.set_printoptions(max_columns=25)

from pandasql import sqldf
from pandasql import load_meat, load_births

meat = load_meat()
births = load_births()

print meat.head()

austinogilvie

#################################################
# SQL FUNCTIONS
# e.g. `RANDOM()`
#################################################
q = """SELECT 
    *
    FROM
        meat
    ORDER BY RANDOM()
    LIMIT 10;"""

austinogilvie

q = """
    SELECT
        date
        , beef
        , veal
        , pork
        , lamb_and_mutton
    FROM
        meat
    WHERE

austinogilvie

# joining meats + births on date
q = """
    SELECT
        m.date
        , b.births
        , m.beef
    FROM
        meat m
    INNER JOIN
        births b

austinogilvie

def pysqldf(q):
    return sqldf(q, globals())
    
q = """
    SELECT
        *
    FROM
        births
    LIMIT 10;"""

austinogilvie

# births per year
q = """ 
    SELECT
        strftime("%Y", date)
        , SUM(births)
    FROM births
    GROUP BY 1
    ORDER BY 1; 
"""

austinogilvie

q = """
    SELECT
        *
    FROM
        meat
    LIMIT 10;"""

print sqldf(q, locals())

#                   date  beef  veal  pork  lamb_and_mutton broilers other_chicken turkey

austinogilvie

from pandas.io import sql

help(sql)
# Help on module pandas.io.sql in pandas.io:

# 	NAME
# 	    pandas.io.sql

# 	FILE
# 	    /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/pandas/io/sql.py

austinogilvie

!!!
%html
  %head
    %title= full_title(yield(:title))
    = render 'layouts/stylesheets'
    = javascript_include_tag "application"
    = csrf_meta_tags
  %body
    #wrapper
      = render 'layouts/header'

austinogilvie

var app     = require('express')()
  , server  = require('http').createServer(app)
  , io      = require('socket.io').listen(server)
  , Series  = require('./series').Series;

app.use(require('connect').static(__dirname + '/public'))
server.listen(8080);

app.get('/', function (req, res) {
  res.sendfile(__dirname + '/index.html');