StreetEasy

How much does it cost to rent in Manhattan?

Find out using scraped data from StreetEasy!

Goal:

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:

Title/Address

Link

Price

Type (Rental, Condo, Commercial-Uses, etc)

# of Bed(s)

# of Bath(s)

Neighborhood

Example:

In this example, we will retrieve all 9257 listings in Manhattan to analyze the cost of each neighborhood.

Worksheet Prerequisites:

None

Code Breakdown:

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

Results:

Tableau Analysis: