How much does it cost to rent in Manhattan?
Find out using scraped data from StreetEasy!
1 – Use Excel VBA to scrape tweets on Streeteasy.com, retrieving each listing in Manhattan into an Excel worksheet
2 – Map / Chart data in Tableau to rank the most expensive and cheapest neighborhood
For each listing, scrape the following:
Type (Rental, Condo, Commercial-Uses, etc)
# of Bed(s)
# of Bath(s)
In this example, we will retrieve all 9257 listings in Manhattan to analyze the cost of each neighborhood.
Open browser window
Browse to https://streeteasy.com/for-rent/manhattan
Loop Step 1: For each search result, retrieve the Title/Address, Link, Price, Type (Rental, Condo, Commercial-Uses, etc), # of Bed(s), # of Bath(s), Neighborhood, Loop Step 2: Click “Next Page”
Loop Step 2: Click “Next Page”
Apply page limit, or as in this example, scrape all pages