Original link:tecdat.cn/?p=4557
Original source:Tuo End number according to the tribe public number
Tableau, as a drag-and-drop visualization software, can easily make beautiful and practical data images. And there is no need to do complex programming operations, or download additional packages.
And for geographic data, Tableau has great support. It can identify the names of provinces and cities across the country, and show them on the map according to latitude and longitude, so as to better reflect the regional characteristics of the data.
This paper collected the data of the 8 most beautiful cycling routes in China, analyzed them from different angles with Tableau software, and put forward my own views to share with you. It is all on paper, and there is no field riding. Welcome criticism and correction.
According to the tourist cycling route map, it can be seen intuitively that the recorded number of cycling routes in all provinces of China, among which, the eastern coastal areas represented by Hainan and Taiwan have the largest number of cycling routes, while the northwest and southwest have the smallest number of cycling routes. It can be seen that there are obvious differences between the cycling environment in eastern and western China. That is to say, the southeast has better cycling environment, more cyclists and more popular routes.
In the sequence of traffic volume of specific time routes, we can see that cycling has completely different popularity in different months. 8 compared to the amount of travel route cycling in October 4 to the July increase a lot, show different travel route in cycling quantity, there is a big difference between 8 to belong to the autumn in October, the temperature and degree of rizhao compared with 4 to 7 month is more suitable for cycling, and as most popular cycling route in the south, so the temperature is relatively high, Therefore, most cyclists choose to travel from August to October.
From the scatter chart, we can see that the cost performance ratio of consumption is generally on the rise, indicating that the cost performance ratio from August to October is constantly strengthening. As can be seen from the stations with high cost performance, most of these stations are in the northwest, while the cycle routes in the southeast are relatively low, indicating that the consumption level of the southern cycle routes is high, resulting in low cost performance, while the consumption level of the northwest region is low, so the cost performance is relatively high. Therefore, in terms of overall value for money, riding routes in the Midwest are better than those on the southern coast.