Attractive Restaurants In Ma On Shan

Attractive Restaurants In Ma On Shan

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…
Assignment 2: Looking at the data instead of looking at the food review on OpenRice

Assignment 2: Looking at the data instead of looking at the food review on OpenRice

For my second assignment, I collected data from Openrice, which is a food and restaurant guide website that operates in Hong Kong, Among all the districts in Hong Kong, I selected the place where I have lived for over 20 years – Sham Shui Po. You may find the page in Openrice here. Parsehub was…
Have a Look at The Fierce Japanese Cuisine Competition in HongKong

Have a Look at The Fierce Japanese Cuisine Competition in HongKong

It is generally known that Japanese stuff always receives popularity in HK. For the first time I dig into the Openrice filter, the number and proportion of Japanese restaurants still shock me. In the richest areas like TST and Causeway Bay, Japanese food wins over all the foreign restaurants. In the relatively poorer areas, the…
SQL is a Great Tool for Data Analysis

SQL is a Great Tool for Data Analysis

Scraping is a useful source for obtaining data among the various methods that are available out there. Nevertheless, the work does not stop there as the scraped data often needs to be cleaned and transformed into the proper format and structure until it can be further used. In the 2nd assignment, ParseHub and Open Refine…