preface

Last time we shared our analysis of 5,500 Douban TV dramas, so this time we bring some benefits to foodies. Our theme is “Finding the best Hotpot”. Before entering the theme, we will first bring a delicious hot pot to all the foodies as a starter.


The data collection

This time, we collected all the restaurants with hot pot labels on the mobile app Dianping, as shown in the picture below.

Select a hot pot restaurant and click on the page for details

This time, the information to be collected is the name of the restaurant, price per person, number of reviewers and restaurant ratings (taste). Environment, services) for later analysis.


The data analysis

A total of 22,554 hot pot restaurants in 100 cities and 15.97 million comments were collected as the basis for our analysis. Let’s take a look at the national heat map of hotpot.

Is it a little different from what you think? Indeed, xiaobian did not think of it. The number of hot pot restaurants is still large in east and north China. Let’s take a look at the number of hot pot restaurants in the TOP20 cities.

It can be seen that the number of hot pot in the top 10 cities is not far apart, and the number of hot pot in the last 10 cities is not much different, which shows that the audience and demand of hot pot is relatively large from the national point of view. Eating hot pot is also a very “popular” thing. Take a look at the number of comments for the TOP20 cities.

It can be seen that the number of comments in Shanghai is far ahead of other cities. There may be two factors: A. There are a large number of hot pot restaurants in Shanghai, which has a large consumer group. B. Dianping is headquartered in Shanghai, and there are a large number of merchants in Shanghai. If interested friends can carry out further research.

After talking about hot pot numbers and comments, let’s take a look at the per capita consumption of hot pot in the TOP20 cities.

Can see not only the number of hotpot restaurant in Shanghai is more, its price is the highest of the city, the price reached 147 yuan, per capita and chengdu price is 88 yuan per capita, and finally a wuhan hotpot restaurant price is 83 yuan per capita, the price of the hot pot of chongqing are not in the list above, shows that its price is less than 83 yuan per capita. Let’s take a look at the average score of hot pot restaurants in the TOP20 cities. The average score is calculated using the hot pot restaurant score (taste). Environment, services) divided by 3.


Unsurprisingly, chongqing, the hotpot capital, topped the list, with Wuhan coming in second and Nanjing third. So here we have our own conclusion, Wuhan and Chongqing are the two cities that have the most cost-effective hot pot, hot pot restaurants in their cities not only score high, the price is more affordable. Besides, there are many famous scenic spots in these two cities, so it would be wonderful not only to see the beautiful scenery but also to eat delicious hot pot during our trip. Especially in Wuhan, where xiaobian is located, in addition to hot pot, there are a lot of other food. If you are a foodie and love to travel, these two cities should be your first choice. Finally we put the delicious hot pot.

Well, don’t say, xiaobian to eat hot pot.


Need source code readers can leave a message, xiaobian will see the first time to reply to you.

For those who are interested in crawlers, data analysis and algorithms, please add the wechat official account TWcoding and let’s play Python together.

If it works for you.Please,star.



God helps those who help themselves