YouTube link: https://www.youtube.com/watch?v=uCpw9eBYbOw
don't just listen to the audio, you'll miss out on Heather talking with her hands: http://cl.ly/image/3Z2y2c0v1O2i/heather.png
| # path taken from brew install notes | |
| POSTGIS_SQL_PATH=/usr/local/share/postgis | |
| # Creating the template spatial database. | |
| createdb -E UTF8 template_postgis | |
| createlang -d template_postgis plpgsql # Adding PLPGSQL language support. | |
| # Allows non-superusers the ability to create from this template | |
| psql -d postgres -c "UPDATE pg_database SET datistemplate='true' WHERE datname='template_postgis';" |
| all_tracts = lapply(income, function(county) | |
| lapply(county$tracts, function(tract) as.data.frame(c(county[1:3],tract)))) | |
| all_tracts_temp = lapply(all_tracts, function(county) as.data.frame(do.call(rbind, county))) | |
| income_df = as.data.frame(do.call(rbind, all_tracts_temp)) | |
| summary(income_df) | |
| ff = as.numeric(income_df$medianIncome) | |
| ff = as.numeric(as.character(income_df$medianIncome)) | |
| income_df$medianIncome = as.numeric(as.character(income_df$medianIncome)) |
We love solving puzzles at Priceonomics. We also like meeting people who like to solve puzzles. Here are two interesting puzzles we've faced at some point in the past months that we'd like to share with you.
If you have any questions, contact omar@priceonomics.com.
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <title>crime clusters</title> | |
| <script | |
| src='http://mapbox-js.s3.amazonaws.com/mapbox.js/v0.5.5/mapbox.js'></script> | |
| <script type='text/javascript' | |
| src='http://mapbox.com/clustr/dist/clustr.min.js'></script> | |
| <style> | |
| body { margin:0;font: 14px/20px 'Helvetica', 'Helvetica Neue'; background:#eee; } |
| import scipy.io | |
| UNWANTED_KEYS = ('__globals__', '__header__', '__version__') | |
| def load_dataset(path): | |
| data = scipy.io.loadmat(path) | |
| for key in UNWANTED_KEYS: | |
| del data[key] |
| DECLARE @tagname varchar(20) = ##language:string## | |
| select DifficultyGroup, Count(1) Total, | |
| avg(cast(ResponseTime as bigint)) as Average, | |
| stdev(cast(ResponseTime as bigint)) as StandardDev | |
| from | |
| (SELECT | |
| Questions.CreationDate, | |
| Questions.Title, | |
| Tags.TagName, |
| select TagName, | |
| avg(cast(ResponseTime as bigint)) as Average, | |
| stdev(cast(ResponseTime as bigint)) as StandardDev | |
| from | |
| (SELECT | |
| Questions.CreationDate, | |
| Questions.Title, | |
| Tags.TagName, | |
| Answers.CreationDate as ResponseDate, | |
| datediff(minute, Questions.CreationDate, |
A thing made with Squares, WebGL demo.
