• 第十八届全国大学生智能车竞赛分赛区比赛成绩汇总

01 成绩与奖项

一、单车越野组

二、电能接力组

三、独轮车组

四、负压电磁组

五、极速越野组

六、摄像头组

七、声音信标组

八、完全模型组

九、智能视觉组

十、专科电磁组

02 成绩汇总

一、学校和队伍数量

• 学校数量：82
• 队伍数量：366

二、参赛学生、指导教师

• 参赛学生： 1235
• 指导教师： 356

三、各组别队伍数量

#!/usr/local/bin/python
# -*- coding: gbk -*-
#============================================================
# HUADONG.PY                   -- by Dr. ZhuoQing 2023-08-02
#
# Note:
#============================================================
from headm import *
import openpyxl
excelfile = r'H:\SmartCar\2023\Division\华东赛区\第十八届全国大学生智能汽车比赛--华东赛区成绩终版.xlsx'
wb = openpyxl.load_workbook(excelfile)
wbs = wb.active
#------------------------------------------------------------
firstline = []
allstr = ''
lastgroup = ''
linedim = []
groupnumber = 0
#------------------------------------------------------------
groupdim = []
groupnamedim = []
universityname = []
student = []
teacher = []
numstr = '一二三四五六七八九十'
#------------------------------------------------------------
for id, l in enumerate(wbs):
    groupstr = ''
    if id == 0:
        firstline.append('<font face=宋体 color=slateblue size=3>序号</font>')
        for ll in l:
            firstline.append('<font face=宋体 color=slateblue size=3>%s</font>'%str(ll.value))
    else:
        ldim = []
        for ll in l:
            ldim.append(str(ll.value).replace('\n','').replace('\r',''))
        for i in range(5):
            sn = ldim[3+i]
            if sn != 'None':
                student.append(sn)
        for i in range(2):
            tn = ldim[8+i]
            if tn != 'None':
                teacher.append(tn)
        universityname.append(ldim[0])
        if ldim[2] != lastgroup:
            groupnumber += 1
            if len(lastgroup) > 0:
                groupdim.append(len(linedim))
                groupnamedim.append(lastgroup)
                allstr = allstr + '## <font  face=黑体 color=#7a37ab>%s、%s</font>\n\n\n\n'%(numstr[groupnumber-2], lastgroup)
                groupstr = '|'.join(firstline) + '\n'
                groupstr += '|'.join(['--']*len(firstline)) + '\n'
                for iidd,line in enumerate(linedim):
                    groupstr += '%d|'%(iidd+1)
                    groupstr += '|'.join(line) + '\n'
                allstr = allstr + groupstr + '\n\n\n\n'
#                printf(groupstr)
                #--------------------------------------------
                linedim = []
                linedim.append(ldim)
                lastgroup = ldim[2]
            else:
                lastgroup = ldim[2]
                linedim = []
                linedim.append(ldim)
        else:
            linedim.append(ldim)
#------------------------------------------------------------
if len(ldim) > 0:
    groupdim.append(len(linedim))
    groupnamedim.append(lastgroup)
    groupstr = '|'.join(firstline) + '\n'
    groupstr += '|'.join(['--']*len(firstline)) + '\n'
    for iidd,line in enumerate(linedim):
        groupstr += '%d|'%(iidd+1)
        groupstr += '|'.join(line) + '\n'
    allstr = allstr + '## <font  face=黑体 color=#7a37ab>%s、%s</font>\n\n\n\n'%(numstr[groupnumber-1], lastgroup)
    allstr = allstr + groupstr + '\n\n\n\n'
#------------------------------------------------------------
allstr = allstr.replace('None', '')
clipboard.copy(allstr)
#------------------------------------------------------------
#printf(firstline)
printf(groupnumber)
printf(groupdim)
printf(groupnamedim)
universityname = list(set(universityname))
groupnamedim = [s.replace('组','') for s in groupnamedim]
printf("University : %d"%len(universityname))
printf("Team:%d"%sum(groupdim))
student = list(set(student))
teacher = list(set(teacher))
printf("Student:%d"%len(student))
printf("Teacher:%d"%len(teacher))
#------------------------------------------------------------
gnstr = ' '.join(groupnamedim)
numstr = ' '.join([str(n) for n in groupdim])
printf(gnstr, numstr)
#------------------------------------------------------------
colors = ['gold', 'yellowgreen', 'lightcoral', 'lightskyblue', 'green', 'blue', 'gray', 'red', 'black']
plt.bar(groupnamedim, groupdim, 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 : HUADONG.PY
#============================================================

■ 相关文献链接:

• 第十八届全国大学生智能车竞赛分赛区比赛成绩汇总