This sample uses New York City Property Sales (2014-2018) provided by Enigma with a free subscription.
The code retrieves data sets between 2014 and 2018, enumerates data set revisions, exports latest CSV assets to S3, downloads the files to a local temporary location, imports the CSVs, calculates the median sale price in each neighborhood for all sales over $100,000, and displays the 10 most expensive neighborhoods.
To run the sample, set AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN and AWS_REGION, subscribe to the product on AWS Data Exchange and replace the data set IDs and the S3 bucket name in the code.
$ bundle exec ruby most-expensive-neighborhoods-in-nyc.rb
NYC Property Sales 2017: Records of over 80,000 property sales transactions.
96023397ee826914fefcef392b218c7b (Oct-17-2019) created 2019-10-28 16:01:46 UTC
e591f6f30d29c5d566c34a7436be701a 2017_NYC_Property_Sales__10172019 .csv
Exporting 2017_NYC_Property_Sales__10172019 .csv to S3 ......... done.
Loading 2017_NYC_Property_Sales__10172019 .csv ........... done.
NYC Property Sales 2018: A table of 80,000+ New York City property sales occurring in 2018, organized by borough, including sale price and sale date.
b0457c8b3c201115daa0f6ca8f2c4140 (2018 Property Sales from 10172019) created 2019-10-28 16:01:47 UTC
01535eb11937b7f6ee825c512cb58582 2018_NYC_Property_Sales__10172019.csv
Exporting 2018_NYC_Property_Sales__10172019.csv to S3 ......... done.
Loading 2018_NYC_Property_Sales__10172019.csv ........... done.
10 Most Expensive NYC Neighborhoods:
EAST RIVER: $11,200,000
CIVIC CENTER: $4,737,500
LITTLE ITALY: $3,709,377
SOHO: $2,983,750
TRIBECA: $2,797,500
FLATIRON: $2,450,000
FASHION: $2,394,614
NAVY YARD: $2,050,000
ROSSVILLE-PORT MOBIL: $1,950,000
RED HOOK: $1,910,000