Skip to content

Instantly share code, notes, and snippets.

@darrenjaworski
darrenjaworski / markup.html
Last active August 29, 2015 14:06
Hamburger to X transition
<a href="" class="toggle"><span class="top"></span><span class="middle"></span><span class="bottom"></span></a>
@darrenjaworski
darrenjaworski / gist:b7766e23165320aff417
Created September 29, 2014 19:08
Update comments and pingback on wordpress site DB
UPDATE wp_posts SET ping_status='closed' WHERE post_status = 'publish' AND post_type = 'post';
UPDATE wp_posts SET ping_status='closed' WHERE post_status = 'publish' AND post_type = 'page';
@darrenjaworski
darrenjaworski / index.html
Last active August 29, 2015 14:07
Mercator - OK school districts
<!DOCTYPE html>
<meta charset="utf-8">
<style>
.schooldistrict {
fill: #eee;
stroke: #777;
}
.schooldistrict:hover {
fill: steelblue;
@darrenjaworski
darrenjaworski / index.html
Created October 1, 2014 02:10
Mercator - OK rivers and lakes
<!DOCTYPE html>
<meta charset="utf-8">
<style>
.lake {
fill: steelblue;;
}
.river {
fill: none;
stroke: #777;
}
@darrenjaworski
darrenjaworski / 2014-1.csv
Last active August 29, 2015 14:07
scrapy - AF Grade Scraper
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
01C019105
01C022105
01C024105
01C028105
01C029105
01C032105
01I004105
01I004705
01I011105
01I011205
@darrenjaworski
darrenjaworski / pdftotxt.py
Last active August 29, 2015 14:07
pdf to txt - AF Grade Scraper
import subprocess
import glob
for file in glob.glob("afgradespdfs/*.pdf"):
cmd = 'pdftotext -enc UTF-8 -layout %s' % (file)
run = subprocess.Popen(cmd, shell=True, stdout=subprocess.PIPE, stderr=subprocess.PIPE)
out, err = run.communicate()
# display errors if they occur
if err:
@darrenjaworski
darrenjaworski / txttocsv.py
Last active August 29, 2015 14:07
txt to csv - AF Grade Scraper
import csv
import glob
def lineParse(line):
return lines[line].strip()
def lineSpliceParse(line, start, stop):
return str(lines[line].strip()[start:stop]).strip()
high = []
@darrenjaworski
darrenjaworski / readme.md
Last active August 29, 2015 14:07
txt to csv - OU payroll 2013
pdftotext -enc UTF-8 -layout payroll2013.pdf

requires pdftotext from poppler

and this txt file

@darrenjaworski
darrenjaworski / quakes.csv
Created October 24, 2014 14:28
quakes.csv
year Magnitude-1 Magnitude-2 Magnitude-3 Magnitude-4
2000 8 9 1 0
2001 16 14 0 0
2002 22 17 3 0
2003 22 25 0 0
2004 30 32 2 0
2005 12 7 2 0
2006 6 12 3 0
2007 5 23 1 0
2008 2 20 2 0
@darrenjaworski
darrenjaworski / index.html
Last active August 29, 2015 14:08
bivariate choropleth
<!DOCTYPE html>
<meta charset="utf-8">
<style>
.schooldistrict {
stroke: #000;
}
.schooldistrictv1, .schooldistrictv2 {
opacity: .5;
}