Skip to content

Instantly share code, notes, and snippets.

Jehiah Czebotar jehiah

Block or report user

Report or block jehiah

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@jehiah
jehiah / FOIL-2018-858-00481.csv
Created Jan 2, 2020
NYC 311 Service Request Satisfaction Survey Data
View FOIL-2018-858-00481.csv
We can't make this file beautiful and searchable because it's too large.
Date,Complaint Type,Descriptor 1,Agency,"Overall, I am satisfied with the way my Service Request was handled.",Why were you dissatisfied with how your Service Request was handled?
2018-04-06,Street Light Condition,Street Light Out,DOT,0 - Strongly Disagree,The Agency did not correct the issue.
2018-03-30,CFC Recovery,17 CFC Appliance,DSNY,100 - Strongly Agree,
2018-03-30,CFC Recovery,17 CFC Appliance,DSNY,100 - Strongly Agree,
2018-03-30,CFC Recovery,17 CFC Appliance,DSNY,100 - Strongly Agree,
2018-04-04,DOF Property - Reduction Issue,Personal STAR Exemption,DOF,0 - Strongly Disagree,"Status updates were unhelpful, inaccurate, incomplete, and/or confusing."
2018-03-30,CFC Recovery,17 CFC Appliance,DSNY,100 - Strongly Agree,
2018-03-31,CFC Recovery,17 CFC Appliance,DSNY,75 - Agree,
2018-03-30,CFC Recovery,17 CFC Appliance,DSNY,0 - Strongly Disagree,The Agency did not correct the issue.
@jehiah
jehiah / FOIL-2018-858-00481.csv
Created Sep 18, 2019
311 Service Request Satisfaction Data https://a860-openrecords.nyc.gov/request/view/FOIL-2018-858-00481
View FOIL-2018-858-00481.csv
We can't make this file beautiful and searchable because it's too large.
Date,Complaint Type,Descriptor 1,Agency,"Overall, I am satisfied with the way my Service Request was handled.",Why were you dissatisfied with how your Service Request was handled?
2018-04-06,Street Light Condition,Street Light Out,DOT,0 - Strongly Disagree,The Agency did not correct the issue.
2018-03-30,CFC Recovery,17 CFC Appliance,DSNY,100 - Strongly Agree,
2018-03-30,CFC Recovery,17 CFC Appliance,DSNY,100 - Strongly Agree,
2018-03-30,CFC Recovery,17 CFC Appliance,DSNY,100 - Strongly Agree,
2018-04-04,DOF Property - Reduction Issue,Personal STAR Exemption,DOF,0 - Strongly Disagree,"Status updates were unhelpful, inaccurate, incomplete, and/or confusing."
2018-03-30,CFC Recovery,17 CFC Appliance,DSNY,100 - Strongly Agree,
2018-03-31,CFC Recovery,17 CFC Appliance,DSNY,75 - Agree,
2018-03-30,CFC Recovery,17 CFC Appliance,DSNY,0 - Strongly Disagree,The Agency did not correct the issue.
@jehiah
jehiah / over.py
Created May 9, 2018
Script to filter output from `uniq -c` to only items that appear more than `--frequency=n` times.
View over.py
#!/bitly/local/bin/python
import tornado.options
import logging
import sys
if __name__ == "__main__":
tornado.options.define("frequency", type=int)
tornado.options.parse_command_line()
for line in sys.stdin:
@jehiah
jehiah / xls_to_csv.py
Last active Nov 15, 2019
Convert xls to CSV
View xls_to_csv.py
#!/usr/local/bin/python
import openpyxl
from openpyxl.utils.exceptions import InvalidFileException
import tornado.options
import os.path
import csv
import sys
import xlrd
import datetime
@jehiah
jehiah / pizza.py
Last active Jan 13, 2019
Calculate the ratio of ingredients needed for the perfect quantity of pizza dough
View pizza.py
#!/usr/bin/env python
# Calculate the ratio of ingredients needed for the perfect quantity of pizza dough
#
# $ pizza.py --target-oz=49
# target: 49.00oz 1389gram
# flour: 800 grams (400 x 2)
# water: 520 grams
# salt: 16 grams
# sugar: 12 grams
@jehiah
jehiah / semver.py
Created Apr 10, 2017
Semver 2.0.0 compatible version comparison w/o regexes
View semver.py
def compare(a, b):
"""
Compare two version strings.
:return -1, 0, 1
:rtype: int
"""
a = map(_cast_int, a.split('+', 2)[0].split('.'))
b = map(_cast_int, b.split('+', 2)[0].split('.'))
@jehiah
jehiah / bitly_datastream.py
Created Feb 3, 2017
pynsq example for connecting to Bitly Datastream
View bitly_datastream.py
import json
import logging
import nsq
import sys
import tornado
import tornado.options
def handle_message(message):
print json.loads(message.body)['u']
message.finish()
@jehiah
jehiah / cyclists_with_cameras_stats_20161123.txt
Created Nov 23, 2016
Cyclists With Cameras stats for my first 339 TLC reports from 2015/10/27 through 2016/11/23
View cyclists_with_cameras_stats_20161123.txt
A follow up to stats for the first 200 at https://on.jehiah.cz/29J6lIX
Violations Cited
# each ∎ represents a count of 4. total 365
no passing zone - NY VTL 1126 [ 1] (0.27%)
(fhv) use/threat physical force - 54-12(g) [ 1] (0.27%)
no tint below 70% - VTL 375(12-a)(b)(2) [ 1] (0.27%)
(fhv) yield sign violation - 54-13(a)(3)(ix) [ 1] (0.27%)
(taxi) improper passing - 55-13(a)(3)(xi) [ 1] (0.27%)
(fhv) threats - 54-12(f) [ 1] (0.27%)
@jehiah
jehiah / pivot_csv.py
Last active Feb 10, 2017
View pivot_csv.py
#!/usr/bin/env python
"""
Pivot a CSV file
$ cat <<EOF | python pivot_csv.py --numeric --headers
> row,column,value
> r1,c1,1
> r1,c2,1
> r1,c1,5
@jehiah
jehiah / cyclists_with_cameras_stats_20160715.txt
Created Jul 16, 2016
Cyclists With Cameras stats for my first 200 TLC reports from 2015/10/27 through 2016/7/15
View cyclists_with_cameras_stats_20160715.txt
A follow up to stats for the first 100 at https://bit.ly/1Se07j7
Violations Cited
# each ∎ represents a count of 3. total 221
no tint below 70 % - VTL 375(12-a)(b) [ 1] (0.45%)
use/threat of physical force - 54-12(g) [ 1] (0.45%)
no passing zone - NY VTL 1126 [ 1] (0.45%)
(fhv) unsafe lane change - 55-13(a)(3)(xii) [ 1] (0.45%)
obstructed license plate - NY VTL 402(b) [ 1] (0.45%)
(taxi) yield sign violation - 54-13(a)(3)(ix) [ 1] (0.45%)
You can’t perform that action at this time.