Where is the place where there are few people during the May Day holiday?

202 1 may day holiday is coming. This time it will last for five days, and it will be a holiday of all sizes. You can organize family and friends to start a new journey together. So where did the May Day holiday that few people played go?

With the coming of the May Day holiday, it is estimated that many people are going 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-week holidays, half a day is Youth Day, and only half a day is Labor Day. This kind of holiday makes many people dissatisfied, including Lao Li of course.

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 encourage people to spend.

Taking two days off is redundant in the number of holidays, but taking five days off and three days off is a qualitative change in stimulating GDP. For example, tourism, five days in the province and three days in the local area. The ability of the former to promote consumption is much higher than that of the latter.

From the actual effect, it can be proved that there is still a whole week before the May Day holiday, and the tickets for train tickets, air tickets, popular attractions and hotel accommodation on major travel apps have 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 can we avoid the peak crowd and enjoy the most cost-effective travel plan? Today, Lao Li deliberately 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

Let's not talk about the capture of data sources here. This is a simple crawling process. You can refer to Lao Li's previous articles. * * * 3,605 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 obtain data directly from the database, which is suitable for enterprise-level big data extraction. Of course it's not necessary here. Just import an excel table:

After importing the data, we can create a new self-service data set for processing. Why create a new one? The reason is to prevent data change and destruction caused by directly processing the source data table, which is equivalent to copying a table. No matter what you do to this table, the data in the source table will not be destroyed:

The data to be analyzed this time is relatively clean and does not need much processing. Create a visual component directly:

In the visualization background, just drag and drop the analyzed fields onto the horizontal and vertical axes, 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 yourself. Here, we will show you the analysis results directly.

Visual analysis

1. Where do you go most often 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 in China 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 popular tourist destinations in recent years, while Shandong, Henan and Shaanxi provinces have attracted many people with their cultural heritage.

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 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 and Shanghai.

The above picture is mainly based on the positive rate received by app. It can be seen that the cities that passengers are most satisfied with are Wuhan, Haikou and Macau. It is a tourist city with few tourists and high praise rate. It is strongly recommended that you go there;

5. What is the best place to discount tickets?

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

6. Where is the cheapest regular ticket?

Zhaoqing, Chengdu, Nanning and other cities have the lowest average air ticket prices, followed by Yangzhou, Yangjiang, Qingyuan and Qingdao.