义乌市恒风行用户公交乘车分析数据

通过收集恒风行APP的用户扫码乘车交易数据，对这些数据进行处理与分析，核算出不同公交路线、公交车辆用户乘坐的人数，通过每一天乘车人数的对比，可以分析得出不同线路、不同车辆的乘客需求度以及乘坐的用户量估计，从而反向对公交车线路、车辆的转型提供数据参考。
(1)数据采集：交易流水号，卡类型，票面金额，路线，车牌，交易日期，结算日期
(2)数据处理：对数据进行清洗、去除无效数据、剔除空数据等操作。
(3)数据加工：利用Python的pandas库，导入交易数据。利用统计函数value_counts对路线和车牌进行统计，得到路线消费次数和车辆消费次数，然后利用merge函数将统计数据根据路线、车牌进行匹配，添加在最右侧。
(4)数据应用：路线消费次数越大，说明该路线当日乘坐的人数越多，车辆消费次数越大，说明该车辆当日乘坐的人数越多。根据时间维度制成统计图，可以直观的反应出线路、车辆的运营情况，帮助运营管理人员能够及时的调整公交运营策略，调整路线、车辆的规格，也有利于运营管理部门进行针对性的优化决策。

This dataset is constructed by collecting user scan-code bus ride transaction data from the Hengfengxing APP. After processing and analyzing the collected data, the passenger volume of different bus routes and individual buses is calculated. By comparing the daily passenger ridership, we can derive the passenger demand and estimate the user volume for each route and vehicle, thereby providing data references for the optimization and transformation of bus routes and fleets.
(1) Data Collection: Transaction serial number, card type, ticket face value, bus route, license plate number, transaction date, settlement date.
(2) Data Preprocessing: Conduct operations such as data cleaning, removing invalid data and deleting empty records.
(3) Data Processing & Enrichment: Use Python's pandas library to import the transaction data. Employ the value_counts statistical function to count the passenger trips for each route and vehicle, obtaining the consumption frequency of each route and individual bus. Then use the merge function to match the counted data based on routes and license plate numbers, and append the matched results to the rightmost column of the dataset.
(4) Data Application: A higher consumption frequency of a route indicates more passengers taking that route on the same day, while a higher consumption frequency of a vehicle indicates more passengers using that vehicle on the same day. Generating statistical charts based on the time dimension can intuitively reflect the operational status of routes and vehicles. This helps operation managers timely adjust bus operation strategies, optimize route configurations and vehicle specifications, and also enables operation management departments to make targeted optimization decisions.

搜集汇总

数据集介绍

特点

该数据集包含义乌市恒风行用户公交乘车交易数据，主要用于分析公交路线和车辆的乘坐需求，为公交运营策略调整提供数据支持。数据每日更新，规模为2772条，涉及多个关键字段如路线、车牌、交易日期等。