202 1 where are the few people during the may day holiday?

202 1 may day holiday is coming, and this time it will take five days, which is a long holiday. Everyone can organize family and friends to start a new journey together, so where is the May Day holiday less crowded and fun?

With the May Day holiday coming, it is estimated that many people are planning to travel. However, Lao Li looked at this year's May Day holiday arrangement and calculated it carefully, and found that the May Day holiday was only one day.

Because of the euphemistic five-day holiday, two days are weekends, two days are two weeks before and after, half a day is Youth Day, and only half a day is Labor Day, which makes many people feel dissatisfied, including Lao Li.

In fact, this year's holiday arrangement is to make up for the tourism industry that was hit hard by the epidemic last year. The main purpose is to stimulate economic growth and promote consumption.

Taking two days off is redundant in terms of the number of days off, but five days off and three days off are qualitative changes in stimulating GDP. For example, if you travel, you can travel out of the province for five days and only travel locally for three days. The former is much more capable of promoting consumption than the latter.

From the actual effect, it can be proved that there is still a whole week before the May Day holiday, and the train tickets, air tickets, tickets for popular attractions and hotel accommodation on major travel apps have all been sold out. This year's travel will be the hottest content of the May Day holiday.

Every year, holiday attractions are crowded with people. How to avoid the peak crowd and enjoy the most cost-effective travel plan? Today, Lao Li grabbed more than 3,000 pieces of data from the Internet, packaged them into three Excel tables, and imported them into FineBI for data analysis to see where it is most worth going this year!

data preparation

I won't mention the capture of data sources here. The grabbing process is very simple. You can refer to Lao Li's previous articles during the crawling process. A total of 3605 pieces of data were captured, some of which are as follows:

The following is a simple data processing and processing. Generally, simple data cleaning can be realized in excel, but the visualization degree of Excel is too low, so this time I choose to use a professional data analysis tool-fine bi for data visualization (see the end of the article): Finebi visualization.

First, import data. FineBI can directly import local data sources, such as excel tables and sql tables. , or connect to the database and get data directly from the database, which is suitable for enterprise-level big data extraction. Of course, you don't need it here, just import the excel table directly:

After importing the data, we can create a new self-service data set for processing. Why should we create a new one? The reason is that in order to prevent data change and destruction caused by direct processing of the source data table, it is equivalent to copying a table. No matter how to process this table, the data of the source table will not be destroyed:

The data to be analyzed this time is relatively clean, so it doesn't need much processing. Just create a visual component directly:

In the visualization background, just drag the analyzed field to the vertical axis and the horizontal axis, and select the corresponding chart type, as shown in the following figure:

The process is not introduced in detail. If you are interested, you can download and try it yourself. Below, I will show you the analysis results directly.

Visual analysis

1. Where are the most tourists in China?

It can be seen that most people still choose to travel to the south during the May Day holiday. Jiangxi is the province with the most tourists during the May Day holiday, and Hunan, Guizhou, Guangdong and Fujian are all popular tourist provinces.

In recent years, more and more people like to travel to the west. Xinjiang, Gansu and Ningxia are all very popular tourist destinations in recent years, while Shandong, Henan and Shaanxi provinces rely on cultural heritage to attract many people.

Surprisingly, there are not many tourists in the three northeastern provinces and Sichuan.

2. The province with the highest tourism income in China.

Jiangxi province is undoubtedly the champion of tourism revenue and the number of tourists during the May Day holiday, and the overall situation is similar to the above picture;

3. Which cities are the most popular?

The above picture shows the 10 city with the most ticket sales during the May Day holiday. It can be seen that although Jiangsu and Hunan are the provinces with the most tourists, Hangzhou, Shanghai, Beijing and Hong Kong in Zhejiang are the most popular tourist cities.

4. Which cities have the highest praise?

The above picture is mainly based on the favorable rate received by app. It can be seen that the cities that passengers are most satisfied with are Wuhan, Haikou and Macau. They are all tourist cities with a small number of tourists and high praise rate. It is strongly recommended that you go;

5. Where is the best discount for air tickets?

During the May Day holiday, the promotion in qionghai city was the strongest, with an average discount of 6.9%, followed by Macau, Yangzhou and Chongqing.

6. Where is the cheapest regular ticket?

Zhaoqing, Chengdu and Nanning have the lowest average fares, followed by Yangzhou, Yangjiang, Qingyuan and Qingdao.