Starting A Restaurant Business in Philadelphia with An Interactive and Comprehensive Tool
Duration
3 weeks, 2022/10
Team
Qianru Zhang
(UX Designer)
Tools
Python
Streamlit
DESIGN GOAL
Help Business Owners Decide Restaurant Type and Location in Philadelphia Using Interactive Data Science
Business owners want to navigate multiple factors of existing restaurants when considering opening a restaurant. These information can be easily accessed through public dataset from Yelp. However, interpreting raw data can be a challenge. To address this need, we decided to design an interactive data app to help business owners review restaurant price range, ratings, location, and categories with ease.
Taking into account data availability and completeness, we've chosen to focus on Yelp data specifically from Philadelphia.
DEVELOPMENT
Using Python and Streamlit Tools to Build An Interactive Restaurant Insights Tool
To fulfill the design goal, we researched available tools and nailed down the following features:
- Filter restaurants according to categories and display details.
- For a selected area, visualize the distribution of price range, star, and numbers of different restaurants.
- For a selected price range and star, display the number of restaurants under different categories.
To implement these features, we began by conducting Exploratory Data Analytics to clean the data. Subsequently, we adopted multiple tools within Python and Streamlit to develop the interactive features of showing different levels of interactions between data.
OUTCOMe
01
Check out Existing Restaurants by Categories on An Interactive Map
02
Review Numbers, Ratings and Price of Different Restaurant Categories in A Specific Region
03
Locate Restaurant Category by Targeted Price Range and Star Rating
A fun insight from the data exploration: In Philadelphia, bars are significantly more than other restaurants. And the price range of bars are relatively higher. Also, bars usually have good star ratings. It might be a good idea to open a bar in Philadelphia!