wordcloud-0a690a68

Analysis of restaurants in Yuen Long District

ByJie SONG

Hello! Welcome to read my analysis report. In this report, Yuen Long District is chosen as the study area. First, through ParseHub, the information on 1040 restaurants in Yuen Long District in Openrice is collected. Then, I use Python to preprocess the data. There are 840 valid data after removing duplicate and null values. Besides, I extract the information to form new columns and export a new dataset. The data is then analyzed by SQL and visualized by Python to form the final data report.

The report mainly studies the following questions:
1. What are the highest-rated and most reviewed restaurants in Yuen Long District?
2. What are the TOP 10 most popular types of restaurants in Yuen Long District?
3. How are the ratings, number of reviews, and per capita spending of restaurants in Yuen Long District distributed?
4. What is the relationship between ratings and restaurant reviews in Yuen Long District?
5. For restaurants in Yuen Long District, what is the connection between rating and price per capita?

If you want to learn more in detail, you can visit my page.

During the analysis process, I feel that Python is very powerful in data analysis and visualization because of its package, including pandas and matplotlib. Similarly, the syntax of SQL is not that much, but the combinations of syntax are diverse and can answer many questions.

Because I am not skilled in Python, I am a bit rusty in data preprocessing and visualization, and I need to study more in these aspects in the future. However, collecting data from scrapers, organizing data, and analyzing data to get a conclusion, this process has been very beneficial to me. Without this assignment, I probably wouldn’t have had this experience.

Similar Posts

food1-a72516c1

Assignment2: How to find the lowest-priced and most popular Hong Kong-style restaurant in Tai Wai?

ByZi LIN
The streets of Tai Wai are intricate, and it takes me at least 15 minutes to get from home to the market, so I always don’t have the patience to go to all the restaurants to explore the food for fear of spending time only to encounter a restaurant that is not good. Coming from…
how-much-data-feature-51df08fc

Taste Data Analysis With SQL Before Tasting Food With My Friends

ByMungChit TSUI
When I was thinking about which districts I should work on, Mong Kok popped up in my mind first as my friends and I always find it difficult to choose a restaurant when we have been there as there are numerous restaurants for us to choose from. Upon deciding on Mong Kok as my target…
1 2-f17bf1be

BTA#2| OpenRice Tsuen Wan – Applying “Likes Rate” to Restaurant-selection

ByWenjing QIAN
Personally, I take OpenRice as a reference to go to when I’m trying to find somewhere to eat, especially in a rather unfamiliar area for me. Instead of simply looking at the numbers shown on the page, I decided to apply a new criteria to help with making wiser decisions.
pexels-dana-tentis-691114-e4cbe5d3

Attractive Restaurants In Ma On Shan

ByQi WENG
The second assignment gave me a complete experience of the data collection, cleaning, and analysis process. You can access my website here. First, I chose the Ma On Shan area where I live and scratched the data of Ma On Shan restaurants in openrice, including restaurant name, number of favorites, categories, price range, number of…
aluminous-749358_1280-9cf282af

Come and find some Korean restaurants! (My struggle with scraping)

ByLingxiang SUN
Hello, everyone! This is my journal for assignment 2. You can see my results here. I will share my feelings and experience from the following aspects. 1. The time for scraping was much longer than I thought I observed the OpenRice website for some time and I wrote down the properties needed for my analysis….