第十八届全国大学生智能汽车竞赛东北赛区比赛结果及颁奖典礼--中国汽车技术研究中心 02 竞赛统计

---

一、参赛队伍、学校

  东北赛区十个竞速组别参赛学校和队伍数量如下：

• 参赛学校： 43所
• 参赛队伍： 204支

二、参赛学生、指导教师

• 参赛学生：697
• 指导教师：115

三、赛题组别

  各赛题组参赛队伍数量如下表所示：

单车越野	电能接力	独轮车	负压电磁	极速越野	摄像头三轮	声音信标	完全模型	智能视觉	专科电磁
18	20	21	38	23	29	13	15	23	4

▲ 图2.3.1 各赛题组比赛队伍

#!/usr/local/bin/python
# -*- coding: gbk -*-
#============================================================
# READINFO.PY                  -- by Dr. ZhuoQing 2023-07-22
#
# Note:
#============================================================

from headm import *
import openpyxl

excelfile = r'H:\SmartCar\2023\Division\东北赛区\第十八届全国大学生智能汽车竞赛东北赛区成绩统计表-20230717.xlsx'

wb = openpyxl.load_workbook(excelfile)


#------------------------------------------------------------

universitydim = []
teamdim = []
groupnamedim = []
groupteamnumber = []

studentdim = []
teacherdim = []


#------------------------------------------------------------
for i in range(10):
    wbstitle = str(wb._sheets[i]).split('"')[1]
    printf(wbstitle)

    #--------------------------------------------------------
    wbst = wbstitle[1:]
    if ord(wbst[0]) < 0x80:
        wbst = wbst[1:]

    groupnamedim.append(wbst)
    printf(wbst)

    #--------------------------------------------------------
    wbs = wb.get_sheet_by_name(wbstitle)
    count = 0
    titlestrdim = []
    for id, l in enumerate(wbs):
        if id < 1: continue

        if id == 1:
            for ll in l:
                titlestrdim.append(str(ll.value))

            continue
        #----------------------------------------------------
        universitydim.append(l[1].value)
        teamdim.append(l[2].value)

        count += 1

        #----------------------------------------------------
        for j in range(5):
            sid = '学生%d'%(j+1)
            if sid in titlestrdim:
                sidindex = titlestrdim.index(sid)
                sname = l[sidindex].value
                if sname != 'None':
                    studentdim.append(sname)

        for j in range(2):
            sid = '指导教师%d'%(j+1)
            if sid in titlestrdim:
                sidindex = titlestrdim.index(sid)
                tname = l[sidindex].value
                teacherdim.append(tname)



    groupteamnumber.append(count)

#------------------------------------------------------------
universitydim = list(set(universitydim))
#printf(universitydim, teamdim, groupnamedim, groupteamnumber)
printf("Univesrity:%d"%len(universitydim))
printf("Team:%d"%len(teamdim))
printff("Team Number:", groupteamnumber)
printff("Group Name", groupnamedim)

studentdim = list(set(studentdim))
teacherdim = list(set(teacherdim))

#printf(studentdim, teacherdim)

printf("Student:%d"%len(studentdim))
printf("Teacher:%d"%len(teacherdim))


#------------------------------------------------------------
gnstr = ' '.join(groupnamedim)
tnstr = ' '.join([str(n) for n in groupteamnumber])
printf(gnstr, tnstr)


#------------------------------------------------------------
colors = ['gold', 'yellowgreen', 'lightcoral', 'lightskyblue', 'green', 'blue', 'gray', 'red', 'black']

plt.bar(groupnamedim, groupteamnumber, color=colors)

plt.xlabel("赛题组名称")
plt.ylabel("队伍数量")
plt.grid(color = '#958080', linestyle='--', linewidth=1, axis='y', alpha=0.7)
plt.tight_layout()
plt.show()




printf('\a')





#------------------------------------------------------------
#        END OF FILE : READINFO.PY
#============================================================

• 比赛成绩EXCEL 表格：