Paul Gambill paulgambill

Cofounder/board director of @nori-dot-eco. Interested mainly in solving large-scale social problems.

paulgambill / gist:7146202

Created October 24, 2013 22:24

This Ruby script parses the dataset from https://catalog.data.gov/dataset/baby-names-from-social-security-card-applications-data-by-state-and-district-of- to find the top name for each sex/year/state permutation. The result is a .csv with a row for each year/sex/top name combination. Be sure to replace the path on line 7 with your local path.

	require 'csv'

	year = 1910

	CSV.open("stateNamesParsed.csv", "ab") do \|csv\|

	Dir.glob('PATH/*.TXT') do \|file\|
	next if file == '.' or file == '..'
	File.open(file).readlines.each do \|line\|
	array = line.split(',')

paulgambill / import_json_appsscript.js

Last active November 13, 2024 23:51 — forked from chrislkeller/import_json_appsscript.js

	/**
	* Retrieves all the rows in the active spreadsheet that contain data and logs the
	* values for each row.
	* For more information on using the Spreadsheet API, see
	* https://developers.google.com/apps-script/service_spreadsheet
	*/
	function readRows() {
	var sheet = SpreadsheetApp.getActiveSheet();
	var rows = sheet.getDataRange();
	var numRows = rows.getNumRows();