Skip to content

Instantly share code, notes, and snippets.

@peterskipper
peterskipper / scrape_fares.py
Created October 29, 2014 02:10
Airfare Watchdog web scrape
import mechanize
from BeautifulSoup import BeautifulSoup
URL = "http://www.airfarewatchdog.com/"
def input_destination(dest):
br = mechanize.Browser()
br.open(URL)
formcount = 0
for form in br.forms():
@peterskipper
peterskipper / api.py
Created October 22, 2014 18:02
chords project tests and api
import os.path
import json
from flask import request, Response, url_for, send_from_directory
from werkzeug.utils import secure_filename
from jsonschema import validate, ValidationError
import models
import decorators
import analysis
@peterskipper
peterskipper / sqlalchemy_practice.py
Created October 13, 2014 15:31
SQL Alchemy project
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, Boolean, Text
from sqlalchemy import ForeignKey
from sqlalchemy.orm import relationship, backref
from sqlalchemy.orm import sessionmaker
from sqlalchemy import Table
from sqlalchemy.schema import UniqueConstraint
import logging
@peterskipper
peterskipper / sel-referentiality-demo2.py
Created October 13, 2014 15:02
sql self referentiality
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, Boolean, Text
from sqlalchemy import ForeignKey
from sqlalchemy.orm import relationship, backref
from sqlalchemy.orm import sessionmaker
from sqlalchemy import Table
from sqlalchemy.schema import UniqueConstraint
import logging
@peterskipper
peterskipper / assoc-object-demo.py
Created October 10, 2014 01:02
SQL Alchemy Files
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, Boolean, Text
from sqlalchemy import ForeignKey
from sqlalchemy.orm import relationship, backref
from sqlalchemy.orm import sessionmaker
from sqlalchemy import Table
from sqlalchemy.schema import UniqueConstraint
import logging
@peterskipper
peterskipper / helpers.R
Created October 4, 2014 00:57
A simple shiny app
if (!exists(".inflation")) {
.inflation <- getSymbols('CPIAUCNS', src = 'FRED',
auto.assign = FALSE)
}
# adjusts yahoo finance data with the monthly consumer price index
# values provided by the Federal Reserve of St. Louis
# historical prices are returned in present values
adjust <- function(data) {
@peterskipper
peterskipper / sqltables2.sql
Created October 2, 2014 22:12
Practice with SELECT and UPDATE
SELECT pet.id, pet.name, pet.dead, pet.breed_id, pet.adopted
FROM pet, breed, species
WHERE
pet.breed_id = breed.id AND
breed.species_id = species.id AND
species.id = 2;
UPDATE pet SET adopted = 0 IN (
SELECT pet.adopted
FROM pet, breed, species
@peterskipper
peterskipper / sqltables.sql
Created October 2, 2014 01:26
An early attempt to create SQL tables with sqlite3
CREATE TABLE species (
id INTEGER PRIMARY KEY,
name TEXT
);
CREATE TABLE breed (
id INTEGER PRIMARY KEY,
name TEXT,
species_id INTEGER
);
@peterskipper
peterskipper / callorfold.py
Created September 17, 2014 16:28
A simple program to calculate exact pot odds in Texas Hold'em poker, and use them to determine mathematically when to call or fold
#Evaluate Poker Hands at the flop in Texas Hold'em
import collections
#Some Constants
VALUES = ["A","2","3","4","5","6","7","8","9","10","J","Q","K"]
SUITS = ["s","h","d","c"]
HIGH_STRAIGHT = ["10", "J", "Q", "K", "A"]
#Helper function to check input
def check_card(card):