Where is the Best Omakase?

I am really interested in Omakase, and I really want to try some during my postgraduate year in Hong Kong. Therefore, it would really useful to analyse the data of Omasake Reseaurants in OpenRice.

I select Kowloon and Hong Kong Island as the areas I would explore. The omakase restaurants in Hong Kong Island is over 130, and Kowloon 30+, totally more than 220+ can be found in Openrice. I was thinking about only use data of Hong Kong Island, but 30+ of Kowloon is not a too bid database to include. So I select both areas. And why not New Territories? Maybe because I would like to explore somewhere beyond our uni.

I scraped the name, price ranges, location, collections, good review amount and bad review amount from openrice. And then I clean the data with openrefine. I rename the columns, split the price range into pricemin and price max, and removes the “$”, replace “k” in collection into the thousand in number. And I also delete the pricemax column, because in my understanding, omakase is so expensive that I cannot and would not be so brave to order the most expensive meal set. So it would be better for me to only look at the minimum price instead. I also drop the duplicate data, some of then are advertisement.
Then I move to pandas and SQL.I set up my own (subjective) calculation for Omakase restaurant ranking in Hong Kong.
Reviewscore = (Collection * 1 + Goodreview *2 + Badreview * -2)
If someone put the restaurant into their collcetion, it means the restaurant must have something attractive, it counts 1 points. Goodreviews are usually after eating, it counts 2 points. Since usually few people woule give bad reviews, bad review means there must be something terrible about the restaurant, it counts -2.
In this way, I use SQL to calculate the reviewsocore and show the top10 restaurants with highest reviewscore with panda,and also the worst 10 in Hong Kong Island and Kowloon.Also, I calculate the average reviewscore among all restaurant selected, which is about 6532.19.

So far so good. However, I was also wondering that which price group that restaurants above the average score belong to? It is becuase my first understanding of Omakase is EXPENSIVE. On social media, with omakase in Shenzhen or Shanghai, the price of one meal goes up to 1,500 CNY, or even above 2,500 CNY in mainland China.I am extremly curious about this phenomenon. Is it a norm? Do most of the “nice” restaurant cost that much?

So, I group the restaurants above the average reviewsources by their minimum price, and show them through pie chart.

Although more than half of the restaurant with reviewscore above the average have the minimun price of 801 HKD, there are still a lot popular ones cost less than 801 HKD. SO, mayeb the nice quality and popularity of Omakase restaurants do not mean to we need to PAY a lot.

I am so happy to find out this result, and my wallet says she is ready!

More information can be found in this page.