校园“一卡通”消费行为数据分析

以陕西工业职业技术学院校园"一卡通"中教职工交易流水数据为研究对象,通过对提取的数据进行预处理、整理与分析、最终实现数据可视化,以满足后勤餐饮部门的管理要求。提取了118249条交易数据,使用Python、SPSS 24、Excel 2010对数据进行预处理和统计分析。首先,讨论了职工餐厅与学生餐厅中教职工消费数据的综合关系;然后,整体研究了职工餐厅近一年来消费情况;最后,从不同方向进一步研究教职工的就餐规律,为学校优化资源配置和科学决策提供参考依据。

Consuming Behavior Data Analysis Based on Campus E-Card System

In this paper, we study the consuming transaction in E-Card system of Shanxi Polytechnic Institute by preprocessing, sorting and analyzing the extracted data, and realize data visualization to meet the management requirements of logistics and catering department. There are 118 249 records from transaction data are extracted from E-Card system. First of all, we discuss the relationship between the consumption data of staff restaurant and the student restaurant. Then, the consumption of the staff restaurant in the past year is studied. Finally, it is significant to provide a reference for the optimization of resource allocation and scientific decision-making of the school through further researching the dining rules of teachers.