金华公交线路节假日客运量分析数据

通过分析节假日的客运量数据，可以了解不同时间段和不同线路的乘客需求，从而优化公交线路的运营计划，调整发车频率和车辆配置，也可以提供更加精准的乘客信息服务，如实时公交到站信息等，提升乘客的出行体验。1.数据采集：利用金华交投公交云平台，采集金华公交的线路管理、车辆管理、以及交易汇总等数据。 2.数据处理：以时间为单位，按月份记录每条线路的营运公里数及客运量总和，并区分工作日与节假日。3.数据加工：百公里客运量=月客运量/（月营运公里数/100），百公里客运量＞100，记为偏高；利用RANK函数对百公里客运量进行升序排名,排名取值范围[1,575]，全部线路中排名末尾50名记为偏低，即排名在526至575的线路计为偏低；其他为正常。4.数据应用：通过“客流分析”可视化界面直观展现各条线路百公里客运量低、高线路的排名情况，从而优化公交线路的运营计划。

By analyzing passenger volume data during holidays and festivals, one can understand passenger demand across different time periods and bus routes, thereby optimizing the operational plans of bus routes, adjusting departure frequencies and vehicle allocations, as well as providing more precise passenger information services such as real-time bus arrival information to enhance passengers' travel experience. 1. Data Collection: Leveraging the Jinhua Transportation Investment Group Bus Cloud Platform, data including route management, vehicle management, and transaction summaries of Jinhua's public transit services are collected. 2. Data Processing: For each bus route, record its monthly operating kilometerage and total passenger volume, and differentiate between workdays and holidays. 3. Data Calculation and Classification: The passenger volume per 100 kilometers is calculated as Monthly Passenger Volume / (Monthly Operating Kilometerage / 100). If the passenger volume per 100 kilometers exceeds 100, it is marked as "high". The RANK function is used to sort the passenger volume per 100 kilometers in ascending order, with the ranking range being [1, 575]. The bottom 50 routes (i.e., those with ranks from 526 to 575) are marked as "low", while the rest are categorized as "normal". 4. Data Application: A "Passenger Flow Analysis" visualization interface is developed to intuitively display the ranking of routes with high and low passenger volume per 100 kilometers, so as to optimize the operational plans of bus routes.