计算机与现代化 ›› 2023, Vol. 0 ›› Issue (03): 66-70.

• 数据库与数据挖掘 • 上一篇    下一篇

基于Apriori算法的大学生体测项目关联规则挖掘

  

  1. (1.江西中医药大学体育健康学院,江西 南昌 330004; 2.江西农业大学软件学院,江西 南昌 330045;
    3.江西省科技基础条件平台中心,江西 南昌 330003)
  • 出版日期:2023-04-17 发布日期:2023-04-17
  • 作者简介:王劭华(1982—),男,甘肃金昌人,讲师,硕士,研究方向:运动训练,E-mail: 281617223@qq.com; 通信作者:杨松涛,男,副教授,研究方向:体育教育运动训练,民族传统保健体育,E-mail: 444713956@qq.com。
  • 基金资助:
    国家社科基金资助项目(16BTY061); 江西省03专项及5G项目(20204ABC03A26)

Association Rule Mining of Undergraduate Physical Test Items Based on Apriori Algorithm

  1. (1. College of Physical Education and Health, Jiangxi University of Traditional Chinese Medicine, Nanchang 330004, China;
    2. School of Software, Jiangxi Agricultural University, Nanchang 330045, China;
    3. Jiangxi Science and Technology Infrastructure Center, Nanchang 330003, China)
  • Online:2023-04-17 Published:2023-04-17

摘要: 大学生身体素质是力量、速度、耐力、柔韧和灵敏的综合表现,为了测量大学生的身体素质情况并分析改善大学生的身体素质,本文分别测量了大学生中男生的各项指标(引体向上、50 m、1000 m、坐位体前屈和跳远)和女生的各项指标(一分钟仰卧起坐、50 m、800 m、坐位体前屈和跳远)。本文使用Apriori算法分别做了3组实验,即在最小支持度为50%和最小置信度为70%,最小支持度为60%和最小置信度为70%,最小支持度为70%和最小置信度为70%的前提下对某大学近5年的男生和女生的各项指标进行关联规则挖掘。实验结果表明:体重正常的学生每项体测分别及格的最小置信度都为70%以上,在所有关联项结果中最高的最小置信度为肺活量及格与体重正常的最小置信度为87.7%,而体重异常的学生体测分别及格的最小置信度都不大于70%。在所有关联项结果中身高与各项体测之间的最小置信度差异不明显。这验证了Apriori算法在大学生身体素质关联规则挖掘中发挥着重要的作用,利用挖掘出来的频繁项集,能够很好地辅助各大高校改善大学生的身体素质。

关键词: 数据挖掘, Apriori算法, 大学生体测项目, 关联规则挖掘

Abstract: Physical quality of college students is the comprehensive performance of strength, speed, endurance, flexibility and agility. In order to measure the physical quality of college students and analyze the improvement of their physical quality, the various indexes of male students (pull-up, 50 m, 1000 m, sitting forward and long jump) and the various indexs of female students (one-minute sit-up, 50 m, 800 m, sitting forward and long jump) are measured. In this paper, Apriori algorithm is used to carry out three groups of experiments respectively,namely under the premise of support of 50% and confidence of 70%, support of 60% and confidence of 70%, support of 70% and confidence of 70%, association rule mining is carried out on various indicators of male and female students in a certain university in recent five years. The experimental results show that the confidence of normal weight students to pass each body test is more than 70%, and the highest confidence of all related items is 87.7% for passing vital capacity and normal weight, while the confidence of abnormal weight students to pass each body test is less than 70%. There is no significant difference in confidence between height and body measurements among all related items, which verifies that Apriori algorithm plays an important role in the mining of association rules of college students’ physical fitness. Using the mined frequent item set, it can well assist universities to improve the physical fitness of college students.

Key words: data mining, Apriori algorithm, undergraduate physical measurement project, association rule mining