philadams-zz’s gists

philadams-zz / many_csvs.applescript

Created June 30, 2011 16:04

Excel: save all sheets as individual .csv files

	set f to choose file
	set outputDirectory to (path to downloads folder as text) & "Excel:converted:"

	-- make sure the outputDirectory exists and if not create it
	if outputDirectory ends with ":" then set outputDirectory to text 1 thru -2 of outputDirectory
	do shell script "mkdir -p " & quoted form of POSIX path of outputDirectory

	-- save all worksheets as csv files
	set csvPaths to {}
	tell application "Microsoft Excel"

philadams-zz / gist:1545745

Created January 1, 2012 00:20

	# PIL doesn't know OS X comes with freetype. Add links before (re)installing.
	# Now you can just install jpeg using homebrew, and then PIL with pip.
	ln -s /usr/X11/include/freetype2 /usr/local/include/
	ln -s /usr/X11/include/ft2build.h /usr/local/include/
	ln -s /usr/X11/lib/libfreetype.6.dylib /usr/local/lib/
	ln -s /usr/X11/lib/libfreetype.6.dylib /usr/local/lib/libfreetype.dylib

philadams-zz / webgl-detect.js

Created January 31, 2012 07:47

WebGL Javascript Detection

	// JQuery only used for selecting and removing elements,
	// mostly left in for the below ALERT.
	// the console.log statements are for your sanity checks.

	var asa; var canvas; var dcanvas; var gl; var expmt;

	canvas = $('#my-canvas');
	console.log(canvas);

	// check to see if we can do webgl

philadams-zz / grep_emails.sh

Created June 28, 2012 15:18

grep all email addresses from a file

grep -E -o "\b[a-zA-Z0-9.-]+@[a-zA-Z0-9.-]+\.[a-zA-Z0-9.-]+\b" filename.txt

philadams-zz / Read SPSS file with custom headers in R

Created December 10, 2012 21:03

Read SPSS file with custom headers in R

	library('memisc')
	args = commandArgs(trailingOnly=TRUE)
	fname = args[1]
	myData = as.data.set(spss.system.file(fname))

philadams-zz / x256 colors

Created February 23, 2013 00:27

print all xterm-256 and -16 colors

	#! /usr/bin/env python

	# Display the colors available in a terminal.

	print "16-color mode:"
	for color in range(0, 16) :
	for i in range(0, 3) :
	print "\033[0;%sm%02s\033[m" % (str(color + 30), str(color)),
	print

philadams-zz / Copy R data for pasting into a spreadsheet

Created July 2, 2013 16:18

write.table(file=pipe("pbcopy"), mydata, row.names=FALSE, sep="\t")

philadams-zz / R split one column into multiple others

Last active December 19, 2015 07:29

Sometimes in a survey you have a question of the type, "... please select all that apply". In super awesome survey software, the returned data arrives with a column for each of the options so your software and graphs can easily know about each option's presence of absence. In super awesome survey software that only fails on this one point (like …

	splitcol = function(x, newcols, targetCol) {

	# delete commas IN THE STATEMENTS SEPARATED BY COMMAS ROFLMAO
	x[[targetCol]] = sub('tablet, such', 'tablet such', x[[targetCol]])
	x[[targetCol]] = sub('phone, tablet, or', 'phone tablet or', x[[targetCol]])

	# check for presence of known examples (newcols[2])
	for (i in newcols) {
	x[[i[1]]] = ifelse(grepl(i[2], x[[targetCol]]), 1, 0)
	}

philadams-zz / gist:6271864

Last active December 21, 2015 07:29

brew upgrade git issues...

	> brew doctor
	Warning: An outdated version of Git was detected in your PATH.
	Git 1.7.10 or newer is required to perform checkouts over HTTPS from GitHub.
	Please upgrade: brew upgrade git

	> brew upgrade git
	==> Upgrading 1 outdated package, with result:
	git 1.8.3.4
	==> Upgrading git
	git: No `python` found in your PATH! Consider to `brew install python`.

Phil Adams philadams-zz