Programming Question

Introduction

A new taxi company hired an advertising agency to advertise their services on screens at Times Square in New York, NY. The marketing company was tasked to identify the five best screens for their client. In order to reach the maximum number of potential clients for the new taxi company the criterion they decided to use was the average number of taxi pickups in close proximity to an advertising screen.

The marketing company found two public datasets that they are going to use:

1. The list of screens at Times Square: See the attached.

2. Public taxi ridership data (for NYC):

https://www.nyc.gov/site/tlc/about/tlc-trip-record…

Large datasets like this one are usually consist of a) data dictionary, a table that lists all the fields in the dataset; b) and the actual dataset in a variety of formats (Excel compatible comma separated values (.cvs), XML or JSON).

Large datasets like this one usually consist of a) data dictionary, a table that lists all the fields in the dataset; b) and the actual dataset in a variety of formats (Excel compatible comma-separated values (.cvs), XML or JSON).

Screen Name
Dave & Buster’s Screen
Ripley’s Odditorium Screen
Wrigley’s Screen
JVC Screen
Hard Rock Cafe Screen
MTV Screen
Toys R Us Screen
Kodak Screen
Forever 21 Main Screen
Forever 21 Decorative Pane Screen
American Eagle Main Screen
American Eagle Above Main Screen
CNN Screen
Hershey’s Screen
Toshiba Below Highest Toshba Screen
Walgreens Storefront Screen
Toshiba Highest Screen
Anheuser-Busch Budlight Screen
Sony News Corp Screen
Walgreens Diagnol Screen
Walgreens 42nd Street Screen
LG Screen
Morgan Stanely Screen
Morgan Stanely Text Screens
M&M Screen
Bank of America Screen
Prudential Screen
Samsung Screen
Coca-Cola Screen
Hyundai Screen
Reuters Screen
NASDAQ Main Screen
Nasdaq Marquee Screen
Champs Sports Screen
NBC Screen
ABC Screen
Chase Screen
Type
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
LED
Building Address
234 W 42nd St
234 W 42nd St
1500 Broadway
1500 Broadway
1501 Broadway
1530 Broadway
1530 Broadway
1535 Broadway
1540 Broadway
1540 Broadway
1551 Broadway
1551 Broadway
1567 Broadway
1593 Broadway
1 Times Sq
1 Times Sq
1 Times Sq
1 Times Sq
1 Times Sq
1 Times Sq
1 Times Sq
120 W 45th St
1585 Broadway
1585 Broadway
1600 Broadway
1633 Broadway
2 Times Sq
2 Times Sq
2 Times Sq
2 Times Sq
3 Times Sq
4 Times Sq
4 Times Sq
5 Times Sq
5 Times Sq
7 Times Sq
787 Seventh Ave
Location Description
Next to the Ripley’s Odditorium
Marquee Level
to the right of ABC above Sephora
to the right of Wringly’s above Starbucks
On the corner of 43rd and 7th
Above the Footlocker
At the entrance of Toys R Us
Within the Vinyl Billboard for Kodak
Video Camera Billboard of the Plaza
Centrally Located on block
Main Screen- Above entrance and Store
Above Main Screen
Above Blue Fin
Text Strip on Hershey’s building
Below Highest Toshiba Screen
Store front LED Screen
Above Budlight- Tallest Point on 1 Times Sq
High Level- Above Sony News Corp
Below the Budlight Screen
Diagnol Screen
42nd Street Screen
Above Planet Holleywood
One Screen on the Corner of 48th
3 Text Screens
Corner of 48th Street
Wraps around corner of 46th Street
Highest Screen behind TKTS booth
Above Hyundai, behind TKTS Booth
Above Hyundai Screen
Lowest Screen on Stack by TKTS Booth
5 LED Screens Wrapped around Corner
Main Screen on Corner of 43rd
At the entrance of Nasdaq building
Wraps Around Corner of 42nd Street
Above Champs Sports
Wrapped around the corner of 42nd Street
Above Quicksilver Marquee
Borough Code
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Borough
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
Postcode
10036
10036
10036
10036
10036
10036
10036
10036
10036
10036
10036
10036
10036
10019
10036
10036
10036
10036
10036
10036
10036
10036
10036
10036
10019
10019
10036
10036
10036
10036
10036
10036
10036
10036
10036
10036
10019
Latitude
40.75675
40.75675
40.75686
40.75686
40.7571
40.75767
40.75767
40.75827
40.75785
40.75785
40.75881
40.75881
40.75925
40.76022
40.75663
40.75663
40.75663
40.75663
40.75663
40.75663
40.75663
40.75712
40.76022
40.76022
40.76035
40.76157
40.75931
40.75931
40.75931
40.75931
40.75638
40.75618
40.75618
40.75571
40.75571
40.75592
40.76196
Longitude
-73.9887
-73.9887
-73.986
-73.986
-73.9862
-73.9851
-73.9851
-73.9855
-73.985
-73.985
-73.9853
-73.9853
-73.9852
-73.9848
-73.9863
-73.9863
-73.9863
-73.9863
-73.9863
-73.9863
-73.9863
-73.9835
-73.9853
-73.9853
-73.9847
-73.984
-73.9849
-73.9849
-73.9849
-73.9849
-73.9867
-73.9862
-73.9862
-73.9872
-73.9872
-73.9867
-73.9826
Community Board
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
Council District
3
3
4
4
3
4
4
3
4
4
3
3
3
3
3
3
3
3
3
3
3
4
3
3
4
3
4
4
4
4
3
4
4
3
3
3
4
Census Tract
113
113
119
119
119
119
119
119
119
119
125
125
125
125
119
119
119
119
119
119
119
119
125
125
125
131
125
125
125
125
119
119
119
113
113
113
131
BIN
1024665
1024665
1022610
1022610
1024706
1022624
1022624
1024727
1076844
1076844
1083727
1083727
1024742
1076195
1022581
1022581
1022581
1022581
1022581
1022581
1022581
1069581
1076193
1076193
1087187
1024812
1024757
1024757
1024757
1024757
1024686
1085682
1085682
1024656
1024656
1086069
1023157
BBL
NTA
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
1010000000 Midtown-Midtown South
Location
(40.756747, -73.988659)
(40.756747, -73.988659)
(40.756856, -73.985973)
(40.756856, -73.985973)
(40.757103, -73.986193)
(40.757674, -73.985121)
(40.757674, -73.985121)
(40.758267, -73.985468)
(40.757847, -73.985009)
(40.757847, -73.985009)
(40.758805, -73.985312)
(40.758805, -73.985312)
(40.759247, -73.985168)
(40.760221, -73.984796)
(40.756628, -73.986287)
(40.756628, -73.986287)
(40.756628, -73.986287)
(40.756628, -73.986287)
(40.756628, -73.986287)
(40.756628, -73.986287)
(40.756628, -73.986287)
(40.757117, -73.983544)
(40.760216, -73.985334)
(40.760216, -73.985334)
(40.76035, -73.984713)
(40.761574, -73.983962)
(40.75931, -73.984857)
(40.75931, -73.984857)
(40.75931, -73.984857)
(40.75931, -73.984857)
(40.756376, -73.986713)
(40.756181, -73.986244)
(40.756181, -73.986244)
(40.755709, -73.987208)
(40.755709, -73.987208)
(40.755915, -73.986681)
(40.761955, -73.982622)
．The illustration above (which was created by importing
created by importing a given dataset to Google Maps) visualizes the locations of the screens.