Skip to content

Instantly share code, notes, and snippets.

View sjengle's full-sized avatar
👩‍🏫

Sophie Engle sjengle

👩‍🏫
View GitHub Profile
@sjengle
sjengle / Affordability_Wide_2015Q3_Public.csv
Last active February 24, 2016 00:32
Zillow Affordability Heatmap
We can't make this file beautiful and searchable because it's too large.
"RegionID","RegionName","SizeRank","Index","HistoricAverage_1985thru1999","1979-03","1979-06","1979-09","1979-12","1980-03","1980-06","1980-09","1980-12","1981-03","1981-06","1981-09","1981-12","1982-03","1982-06","1982-09","1982-12","1983-03","1983-06","1983-09","1983-12","1984-03","1984-06","1984-09","1984-12","1985-03","1985-06","1985-09","1985-12","1986-03","1986-06","1986-09","1986-12","1987-03","1987-06","1987-09","1987-12","1988-03","1988-06","1988-09","1988-12","1989-03","1989-06","1989-09","1989-12","1990-03","1990-06","1990-09","1990-12","1991-03","1991-06","1991-09","1991-12","1992-03","1992-06","1992-09","1992-12","1993-03","1993-06","1993-09","1993-12","1994-03","1994-06","1994-09","1994-12","1995-03","1995-06","1995-09","1995-12","1996-03","1996-06","1996-09","1996-12","1997-03","1997-06","1997-09","1997-12","1998-03","1998-06","1998-09","1998-12","1999-03","1999-06","1999-09","1999-12","2000-03","2000-06","2000-09","2000-12","2001-03","2001-06","2001-09","2001-12","2002-03","2002-06","2002-09",
@sjengle
sjengle / MarketHealthIndex_State.csv
Last active February 24, 2016 19:41
Zillow Market Health Bubble Chart
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 7.
"RegionType","RegionName","City","State","Metro","CBSATitle","SizeRank","MarketHealthIndex","SellForGain","PrevForeclosed","ForeclosureRatio","ZHVI","MoM","YoY","ForecastYoYPctChange","StockOfREOs","NegativeEquity","Delinquency","DaysOnMarket"
"State","Alaska",,"AK",,,,9.6,85.46,,,263900,0.456794822992006,3.00546448087432,0.0544410761652141,12.2,0.133051017998153,0.0127879928929157,89
"State","Alabama",,"AL",,,,2,79.11,11.2475,5.3108,122700,0.0815660685154976,0.491400491400491,0.033716381418093,25.8,0.163747493402736,0.03344252224344,128
"State","Arkansas",,"AR",,,,4.2,77.42,6.4771,2.5227,115100,0.261324041811847,3.3213644524237,0.0291920069504779,31.5,0.146923643975339,0.030851303923143,110
"State","Arizona",,"AZ",,,,4.6,81.91,7.9186,3.357,204200,0.789733464955577,7.58693361433088,0.0365915768854064,73,0.176208332385921,0.0250151422782854,76
"State","California",,"CA",,,,7.4,88.7,6.412,2.2965,454700,0.530621269069202,6.31283610007014,0.029566747305916,56.8,0.0944519577924134,0.0339595696138096,74
"Stat
@sjengle
sjengle / README.md
Created April 3, 2016 04:10
Adding Click for Tick Labels
@sjengle
sjengle / .block
Last active February 8, 2017 08:26
SF Monthly Property Crime 2005 to 2015
license: mit
@sjengle
sjengle / README.md
Last active April 20, 2017 23:27
Java 8 API Hierarchy
@sjengle
sjengle / README.md
Last active April 24, 2017 03:40
Coauthorship Network
@sjengle
sjengle / README.md
Last active February 12, 2019 20:10
Letter Count Bar Chart (d3v5)

Letter Count Bar Chart

In this demo, we asynchronously load a text file, use JavaScript to count the number of times each letter appears in that file, and generate a bar chart showing the letter count in D3.js v5.

This is meant to be an introductory demo to expose students to HTML, CSS, JavaScript, D3.js, bl.ocks.org, and blockbuilder.org for the first time.

References

This is based off the following example:

@sjengle
sjengle / README.md
Last active February 14, 2019 19:34
Mobility Bubble Chart (D3 v5, Tableau Desktop)

Mobility Rate by College Bubble Chart

This example will demonstrate how to prototype a bubble chart in Tableau Desktop and then implement a version of that bubble chart in D3.js version 5.

The data comes from Opportunity Insights, which is a "non-partisan, not-for-profit organization based at Harvard University" that puts out public datasets produced for on their research.

We will specifically use data from the Mobility Report Cards project. The dataset is titled "Mobility Report Cards: Preferred Estimates of Access and Mobility Rates by College" and can be accessed via these direct links:

mrc_table1.csv
Codebook-MRC-Table-1.pdf

@sjengle
sjengle / README.md
Created April 8, 2019 02:37
Java 11 API Hierarchy
@sjengle
sjengle / README.md
Last active September 13, 2019 12:17
Letter Count Bar Chart

Letter Count Bar Chart

In this demo, we asynchronously load a text file, use JavaScript to count the number of times each letter appears in that file, and generate a bar chart showing the letter count in D3.js.

This is meant to be an introductory demo to expose students to HTML, CSS, JavaScript, D3.js, bl.ocks.org, and blockbuilder.org for the first time.

Videos

Below you can find videos related to this demo. Please note that some content is discussed in-class only.