| EMPLOYER contribs names total | |
| ---------------------------------------- ---------- ---------- ---------------------------------------- | |
| SELF 1632 367 1980834.72 | |
| N/A 1582 253 4507011.83 | |
| RETIRED 950 240 1763236.27 | |
| SELF-EMPLOYED 12118 239 3802360.59 | |
| SELF EMPLOYED 615 183 812667.3 | |
| NONE 1384 154 2407922.75 | |
| NOT EMPLOYED 655 120 1880945.0 | |
| PFIZER INC 3685 119 956146.349999986 |
| Select ST_AsText( | |
| ST_Transform( | |
| ST_SetSRID( | |
| ST_MakePoint(xcoord,ycoord), | |
| 2263) | |
| , 4326) | |
| ) from nyc_pluto limit 10; | |
| -- PostgreSQL | |
| -- combine data for all years into one table | |
| -- to find distinct addresses & BBL numbers | |
| create table dhcr_all ( | |
| zip integer, | |
| bldgno1 text, | |
| street_name1 text, | |
| street_suffix1 text, | |
| bldgno2 text, | |
| street_name2 text, |
| #!/bin/bash | |
| # escape sequences http://ascii-table.com/ansi-escape-sequences.php | |
| # http://www.climagic.org/mirrors/VT100_Escape_Codes.html | |
| wget http://www.opendatacache.com/bronx.lehman.cuny.edu/api/views/4iu9-f7ju/rows.csv --progress=bar:force -O rows1.csv 2>log1.log & | |
| wget http://www.opendatacache.com/bronx.lehman.cuny.edu/api/views/4iu9-f7ju/rows.csv --progress=bar:force -O rows2.csv 2>log2.log & | |
| wget http://www.opendatacache.com/bronx.lehman.cuny.edu/api/views/4iu9-f7ju/rows.csv --progress=bar:force -O rows3.csv 2>log3.log & | |
| for logfile in $( ls *.log ); do |
| # create a new session if there isn't one already | |
| # new-session | |
| # look good | |
| set -g default-terminal "xterm-256color" | |
| # # doesn't work :( | |
| # # Pasteboard | |
| # set-option -g default-command "reattach-to-user-namespace -l \"$SHELL\"" | |
| # bind-key 'P' run-shell "tmux set-buffer \"$(pbpaste)\"; tmux paste-buffer" |
| eval "$(rbenv init -)" | |
| export EDITOR=vim | |
| set -o vi | |
| # Git completion and other things | |
| source ~/.git-completion.bash | |
| GIT_PS1_SHOWDIRTYSTATE=true | |
| export PS1=${PS1}' \W$(__git_ps1) ' |
| { | |
| "version": "2", | |
| "header": { | |
| "title": "NYC 311 Data", | |
| "description": "The last 3 million NYC 311 complaints", | |
| "navigation": [ | |
| { | |
| "label": "Download", | |
| "url": "" | |
| } |
We're thinking of creating a new repo, research-worklogs in which we post daily worklogs.
We would have a template as the README, to copy-paste and fill out each day.
Each sprint would have a folder, and each team member would have a file with all of that sprint's worklogs in it. Each daily log would be prepended to the file by the end of the day.
Examples:
Tools:
| import json | |
| def main(): | |
| businesses_by_id = {} | |
| with open('yelp_academic_dataset_business.json') as business_file: | |
| # for every line in this file (every business) | |
| # load the json in from that line into an object (json.loads) | |
| # | |
| # save the object to the businesses_by_id dict by its `business_id` |