1 of 16

London Transportation and Restaurant Reviews

Caleb Han

Mason Mines

2 of 16

Introductions

Caleb Han

Computer Science & Physics, ‘28

Mason Mines

Computer Science, ‘28

3 of 16

Understanding the Problem

Attention

Proximity

Audience

Restaurants further away could receive lesser/poorer reviews

Distance from accessible areas could affect restaurant traffic

Small business owners and tourists would be affected.

4 of 16

Does the location of a restaurant affect its reviews?

Question:

5 of 16

Does the location of a restaurant affect its reviews?

Location

Reviews

  • The number of reviews
  • The average review ratings (polarity, 0-10)
  • Greater London area
  • Proximity to a metro station
  • Proximity to a bus stop

6 of 16

Data Set 1/3: TourPedia API

​

Source: TourPedia Statistics Page

Our Choice: London

7 of 16

Data Set 2/3: London Metro

Source: London Stations (doogal.co.UK)

London Metro (Web)

London Metro (Recreated)

8 of 16

Data Set 3/3: London Buses

Source: Transport for London (TfL) Bus Stop Locations and Routes (London Datastore)

​

London Bus Data (Web)

London Bus System (Recreated)

9 of 16

Data Preprocessing

Obtaining Data

Accessed API endpoints

Filtering Data Types

Only looked at reviews relevant to our analysis

Removing Outliers

Removed data not indicative of an average experience.

Calculating Distance

Measured distance between restaurant & closest station

01

03

04

02

10 of 16

TourPedia Review Data

Polarity (Rating)

Frequency

11 of 16

Frequency Findings

The data shows that a restaurant tends to have more reviews the closer they are to a transportation stop.

​

  • There are also more restaurants with low review counts for distances under 800
  • Data suggests that most restaurants are within about 800 meters of a transportation stop
  • Similar trend for the two modes of transportation

12 of 16

Polarity Findings

The data shows that a restaurant tends to have stronger reviews the closer they are to a transportation stop.

​

  • There are much more top reviews for distances below 800 meters than in other distances
  • We also see more variety in reviews for small distances
  • Pattern of people express a 5/10 polarity
  • Similar trend for the two modes of transportation

13 of 16

Impact

Tourists

London Area

Tourists could have access to less biased restaurant data.

Better economic health when local businesses are supported

Small Businesses

Distant restaurants could gain equal footing for reviews

14 of 16

Outlook

​

01

02

Locals will support locals: encourage locals to advertise other local business

​

Removing confounding variables, increasing data set, etc.

Advertisement

Further Research

15 of 16

References

  • http://tour-pedia.org/api/
  • https://www.doogal.co.uk/london_stations
  • https://data.london.gov.uk/dataset/tfl-bus-stop-locations-and-routes

16 of 16

Questions?

Please keep this slide for attribution

CREDITS: This presentation template was created by Slidesgo, including icons by Flaticon, infographics & images by Freepik and illustrations by Stories

​