# Project Benson: ## Strategies for Optimizing Street Team Placements Dean / Dereck / Joseph / Kendall 01/22/2018

Methodology

  • Assumptions
  • Data Cleaning/Aggregation
  • Recommendations

Data Cleaning & Aggregation

Data Issues

  • Reset Counts
  • Turnstiles rolling backwards
  • Different time intervals
  • How to standardize the counts

Data Cleaning

  • Three methods explored
  • Resampling and Interpolation
  • Weighted Averages
  • Min/Max per day

Data Aggregation

  • Pivot table (groupby)
  • Total traffic by station and date

Top Stations with Most Traffic

chart

Top Stations with Most Traffic

chart chart chart

Observations #1

More high traffic stations on weekdays chart

Observations #2

More high traffic between 4 to 8pm chart

Recommendations

Recommendation #1

The Common Sense Approach
  • Spring Weekdays 4-8pm
  • Penn Station
  • Grand Central
  • Time Square
  • etc.
 chart

Recommendation #2

Quality over Quantity Approach
(next steps)
  • Location targeting
    (Tech companies, Universities, Pro-women Groups)
  • Find highest traffic stations in nearby zip codes
 chart

Recommendation #3

The Opportunistic Approach
(next steps)
  • Events targeting (Tech/Women’s Conferences, Concerts)
  • Identify events date/time/location and stations nearby
 chart chart

Thank You