python pandas爬取网页成绩表格，计算各个类别学分

最新推荐文章于 2022-12-24 17:04:43 发布
原创 最新推荐文章于 2022-12-24 17:04:43 发布 · 1.2k 阅读 · 4 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
收录于
python

当前文章被收录于：

python
1 篇文章 0 人学习
订阅专栏 查看详情
本文介绍了如何使用Python的pandas库从网页抓取成绩表格，并详细展示了计算各个类别学分的过程，包括编写程序代码及运行的部分结果。

一、以下是个人成绩表格

二、下面是我的程序：

# -- coding: utf-8 --
import pandas as pd
import csv

def credit_points_sum(df,title):
    df.to_csv('E:\\scores_'+title+'.csv',  encoding='utf_8_sig')  # index=False,header=False
    sum=0
    for i in range(df.shape[0]):
        sum+=float(df.iloc[i][4])
    print(title+':'+str(sum))


url='E://scores.html'
tb=pd.read_html(url)[1]
tb=tb[1:70]
print(tb.iloc[0][6])
tb[4].astype(float)
print(tb)

# 总学分
credit_points_sum(tb, u'总学分')

# 专选
tb_zhuanXuan=tb[tb[6]=='专选']
credit_points_sum(tb_zhuanXuan,'专选')


# 必修
tb_biXiu=tb[tb[6]=='必修']
credit_points_sum(tb_biXiu,'必修')


# 素质
tb_suZhi=tb[tb[6]=='素质']
credit_points_sum(tb_suZhi,'素质')

# 专选非限
tb_suZhi=tb[tb[6]=='专选(非限)']
credit_points_sum(tb_suZhi,'专选(非限)')

三、下面是运行的部分结果

四、下面是个人下载下来的静态html


<html>
<title>学生个人总成绩查询</title>
<head>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="/include/style.css" type=text/css rel=stylesheet>
</head>
<body >

<center>
<table BORDER="0" cellspacing="0"   height="80%">
<tr>
<td>
</td></tr>
<tr>
<td align="center">


<p><B><font size="3">重庆大学学生成绩单</font></B></p>
                                                                                   

<p><B>学号：</B>20161590　　<B>姓名：</B>谭植尹　　<B>专业：</B>软件工程 <B>GPA：</B>3.22</B>　</p>
<table BORDER="1" cellspacing="0" cellpadding="2" bordercolorlight="#000000"
bordercolordark="#FFFFFF" bordercolor="#FFFFFF" width="877">
  <tr>
    <td width="32"><b>序号</b></td>
    <td width="84"><b>课程编码</b></td>
    <td width="210"><b>课程名称</b></td>
    <td width="43"><b>成绩</b></td>
    <td width="43"><b>学分</b></td>
    <td width="53"><b>选修</b></td>
    <td width="52"><b>类别</b></td>
    <td width="60"><b>教师</b></td>
    <td width="54"><b>考别</b></td>
    <td width="38"><b>备注</b></td>
    <td width="140"><b>时间</b></td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      1
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE31029
    </td>
    <td VALIGN="center" width="210" height="23"> 
      .NET框架及C#程序设计
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	76
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       祝伟华
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-12-1
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      2
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE31209
    </td>
    <td VALIGN="center" width="210" height="23"> 
      DirectX图形程序设计
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	81
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       曾骏
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-1-10
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      3
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE21023
    </td>
    <td VALIGN="center" width="210" height="23"> 
      Java EE程序设计
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	82
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       黄晟
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-16
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      4
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE31107
    </td>
    <td VALIGN="center" width="210" height="23"> 
      Web开发技术
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	95
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       王成良
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-1-18
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      5
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE21021
    </td>
    <td VALIGN="center" width="210" height="23"> 
      操作系统原理
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	96
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       洪明坚
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-15
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      6
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE11005
    </td>
    <td VALIGN="center" width="210" height="23"> 
      程序设计基础
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	84
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      4
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       黄晟
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-1-17
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      7
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE24061
    </td>
    <td VALIGN="center" width="210" height="23"> 
      程序设计实训
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	80
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       雷跃明
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-9-11
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      8
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      HG00046
    </td>
    <td VALIGN="center" width="210" height="23"> 
      大学国文（上）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	82
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      素质 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       彭磊
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2016-12-30
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      9
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      HG00047
    </td>
    <td VALIGN="center" width="210" height="23"> 
      大学国文（下）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	81
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      素质 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       刘扬
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-6-20
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      10
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      PYS10013
    </td>
    <td VALIGN="center" width="210" height="23"> 
      大学物理Ⅱ-1
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	76
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3.5
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       苏荀
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-7-7
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      11
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      PYS12010
    </td>
    <td VALIGN="center" width="210" height="23"> 
      大学物理实验
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	77
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1.5
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       余沛
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-7-7
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      12
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      5200080
    </td>
    <td VALIGN="center" width="210" height="23"> 
      大学英语(国家四级)
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	453
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      任选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       国家四级
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-9-12
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      13
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE31207
    </td>
    <td VALIGN="center" width="210" height="23"> 
      多媒体技术
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	79
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       桑军
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-1-17
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      14
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SSG00038
    </td>
    <td VALIGN="center" width="210" height="23"> 
      法律与文学
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	92
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      素质 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       颜丽媛
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-12
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      15
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      MTH20041
    </td>
    <td VALIGN="center" width="210" height="23"> 
      概率论与数理统计Ⅰ
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	86
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       胥斌
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-12-14
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      16
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      MTH10012
    </td>
    <td VALIGN="center" width="210" height="23"> 
      高等数学1（电子信息类）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	71
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      5
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       杨向东
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-1-14
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      17
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      MTH10022
    </td>
    <td VALIGN="center" width="210" height="23"> 
      高等数学2（电子信息类）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	62
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      6
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       杨向东
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-7-8
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      18
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE21015
    </td>
    <td VALIGN="center" width="210" height="23"> 
      汇编语言程序设计
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	87
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       陈蜀宇
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-26
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      19
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE31313
    </td>
    <td VALIGN="center" width="210" height="23"> 
      机器学习与模式识别
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	86
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       陈飞宇
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-1-17
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      20
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE31027
    </td>
    <td VALIGN="center" width="210" height="23"> 
      计算机图形学
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	86
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       杨梦宁
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-1-17
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      21
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE21019
    </td>
    <td VALIGN="center" width="210" height="23"> 
      计算机网络与通信
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	87
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       胡海波
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-17
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      22
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE21011
    </td>
    <td VALIGN="center" width="210" height="23"> 
      计算机组成与结构
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	78
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       杨正益
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-17
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      23
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      MET11000
    </td>
    <td VALIGN="center" width="210" height="23"> 
      军事课（含军事训练、军事理论）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	88
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       朱云清
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2016-11-18
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      24
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE10009
    </td>
    <td VALIGN="center" width="210" height="23"> 
      离散数学
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	77
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       王森
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-6-16
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      25
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      IPT10300
    </td>
    <td VALIGN="center" width="210" height="23"> 
      马克思主义基本原理
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	82
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       庞永红
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-13
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      26
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      IPT10400
    </td>
    <td VALIGN="center" width="210" height="23"> 
      毛泽东思想和中国特色社会主义理论体系概论
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	75
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       刘昕
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-16
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      27
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      IPT13400
    </td>
    <td VALIGN="center" width="210" height="23"> 
      毛泽东思想和中国特色社会主义理论体系概论实践
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	良
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       刘昕
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-16
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      28
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE21007
    </td>
    <td VALIGN="center" width="210" height="23"> 
      面向对象程序设计
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	80
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       雷跃明
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-6-30
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      29
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE31105
    </td>
    <td VALIGN="center" width="210" height="23"> 
      面向对象技术与UML
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	91
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       徐玲
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-1-13
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      30
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE31113
    </td>
    <td VALIGN="center" width="210" height="23"> 
      软件测试
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	79
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       雷晏
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-5-27
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      31
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE21101
    </td>
    <td VALIGN="center" width="210" height="23"> 
      软件工程导论
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	88
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       张毅
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-14
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      32
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE34063
    </td>
    <td VALIGN="center" width="210" height="23"> 
      软件工程实训
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	85
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       杨正益
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-7-18
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      33
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE31111
    </td>
    <td VALIGN="center" width="210" height="23"> 
      软件架构与设计模式
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	87
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       蔡海尼
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-7-5
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      34
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE30109
    </td>
    <td VALIGN="center" width="210" height="23"> 
      软件项目管理
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	84
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       任海军
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-6-21
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      35
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE30103
    </td>
    <td VALIGN="center" width="210" height="23"> 
      软件需求分析
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	81
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       张毅
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-1-13
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      36
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE20205
    </td>
    <td VALIGN="center" width="210" height="23"> 
      色彩与平面构成
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	93
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       马跃
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-17
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      37
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE21013
    </td>
    <td VALIGN="center" width="210" height="23"> 
      数据结构与算法
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	63
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       文俊浩
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-26
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      38
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE25012
    </td>
    <td VALIGN="center" width="210" height="23"> 
      数据结构与算法课程设计
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	优
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       文俊浩
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-26
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      39
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE25018
    </td>
    <td VALIGN="center" width="210" height="23"> 
      数据库课程设计
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	良
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       柳玲
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-5
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      40
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE21017
    </td>
    <td VALIGN="center" width="210" height="23"> 
      数据库原理与设计
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	81
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       柳玲
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-2
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      41
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      IPG00003
    </td>
    <td VALIGN="center" width="210" height="23"> 
      数学模型
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	86
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      素质 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       胥斌
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-13
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      42
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      FSS18033
    </td>
    <td VALIGN="center" width="210" height="23"> 
      数学与交叉学科建模
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	85
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选(非限)
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       龚劬
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-8-24
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      43
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE31213
    </td>
    <td VALIGN="center" width="210" height="23"> 
      数字动画与游戏设计
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	90
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       陈远
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-6-17
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      44
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE21203
    </td>
    <td VALIGN="center" width="210" height="23"> 
      数字摄影
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	84
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       黄勇
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-23
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      45
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE20201
    </td>
    <td VALIGN="center" width="210" height="23"> 
      数字作品创意策划
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	92
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       马跃
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-26
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      46
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      IPT10100
    </td>
    <td VALIGN="center" width="210" height="23"> 
      思想道德修养与法律基础
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	83
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       陈迅
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-1-17
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      47
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      IPT13100
    </td>
    <td VALIGN="center" width="210" height="23"> 
      思想道德修养与法律基础实践
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	良
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       陈迅
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-2-24
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      48
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      PSS12010
    </td>
    <td VALIGN="center" width="210" height="23"> 
      体育健康知识
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	合格
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       体育学院
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-12
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      49
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      PSS22040
    </td>
    <td VALIGN="center" width="210" height="23"> 
      体育项目(长跑)
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	合格
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       纪建敏
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-1-7
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      50
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      PSS22039
    </td>
    <td VALIGN="center" width="210" height="23"> 
      体育自选项目(网球)
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	合格
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       体育学院
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-6-24
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      51
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      PSS22041
    </td>
    <td VALIGN="center" width="210" height="23"> 
      体育自选项目(校园马拉松)
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	合格
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       体育学院
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-12
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      52
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      EDS20505
    </td>
    <td VALIGN="center" width="210" height="23"> 
      西方建筑文化与翻译
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	84
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       沈立
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-23
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      53
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      MTH10032
    </td>
    <td VALIGN="center" width="210" height="23"> 
      线性代数(II)
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	76
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      3
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       胡小兵
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-1-14
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      54
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE10001
    </td>
    <td VALIGN="center" width="210" height="23"> 
      新生研讨课
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	合格
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       陈蜀宇
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-1-7
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      55
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE30501
    </td>
    <td VALIGN="center" width="210" height="23"> 
      信息安全导论
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	96
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       胡海波
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-1-17
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      56
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE10003
    </td>
    <td VALIGN="center" width="210" height="23"> 
      信息系统基础
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	88
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       葛永新
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-1-7
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      57
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      IPT10000
    </td>
    <td VALIGN="center" width="210" height="23"> 
      形势与政策（1）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	90
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      .5
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       王丹云
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-1-17
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      58
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      IPT10001
    </td>
    <td VALIGN="center" width="210" height="23"> 
      形势与政策（2）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	90
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      .5
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       周大秋
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-7-2
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      59
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      IPT20000
    </td>
    <td VALIGN="center" width="210" height="23"> 
      形势与政策（3）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	89
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      .5
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       常进
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-1-19
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      60
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      IPT20001
    </td>
    <td VALIGN="center" width="210" height="23"> 
      形势与政策（4）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	95
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      .5
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       王丹云
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-11
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      61
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      EUS10021
    </td>
    <td VALIGN="center" width="210" height="23"> 
      学业素养英语（2）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	80
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       晏生宏
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-1-13
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      62
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      EUS10031
    </td>
    <td VALIGN="center" width="210" height="23"> 
      学业素养英语（3）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	84
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       晏生宏
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-7-9
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      63
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE31305
    </td>
    <td VALIGN="center" width="210" height="23"> 
      移动应用开发
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	93
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       Feno
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2019-7-1
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      64
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      EUS10121
    </td>
    <td VALIGN="center" width="210" height="23"> 
      英语口语交际技能（2）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	76
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       Karlene
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-1-12
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      65
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      EUS10131
    </td>
    <td VALIGN="center" width="210" height="23"> 
      英语口语交际技能（3）
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	83
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      1
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       朱永蓉
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-7-7
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      66
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      EDS20401
    </td>
    <td VALIGN="center" width="210" height="23"> 
      英语学术论文写作
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	90
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       孙凌
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-12
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      67
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      IPT10200
    </td>
    <td VALIGN="center" width="210" height="23"> 
      中国近现代史纲要
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	88
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      必修 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       黄艳
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2017-7-10
    </td>
  </tr>

  <tr>

    <td align="center" VALIGN="center" width="32" height="23"> 
      68
    </td>
    <td align="center"  VALIGN="center" width="84" height="23"> 
      SE20025
    </td>
    <td VALIGN="center" width="210" height="23"> 
      专业英语文体和写作
    </td>
    <td  align="center" VALIGN="center" width="43" height="23">
	90
    </td>
    <td  align="center" VALIGN="center" width="43" height="23"> 
      2
    </td>
    <td  align="center" VALIGN="center" width="53" height="23"> 
      
	  正常
      
    </td>
    <td  align="center" VALIGN="center" width="52" height="23"> 
      
      专选 
      
    </td>
    <td align="center"  VALIGN="center" width="60" height="23"> 
       外教2
    </td>
    <td align="center"  VALIGN="center" width="54" height="23"> 
	正考
    </td>
    <td align="center"  VALIGN="center" width="38" height="23"> 
	  正
    </td>
    <td align="center"  VALIGN="center" width="140" height="23"> 
	  2018-7-19
    </td>
  </tr>

</table>
<p><font size="3"><center>重庆大学教务处　　　查询时间：2019-8-30 20:24:50</center></font> </p>

</td></tr>
<tr>
<td>
</td></tr>
</table></center>
   
</body>
</html>

 

用C++实现一个班级学生的学期成绩管理
小灰的博客
06-14 6129
实现一个班级学生的学期成绩管理个人信息类CPerson的数据成员有姓名、年龄、性别。 课程类CCourse的数据成员有课程名、学分、成绩。 学生类CStudent从CPerson类派生，并增加数据成员学号、CCourse类对象成员数组（大小为8）总成绩、总学分和平均成绩。 班级类CClass类的数据成员由CStudent类对象数组（大小由构造函数确定）、班号、班级人数等。
高校辅导员自动化工具设计：RPA与Python实战解析
最新发布
靓靓软件工作室
06-16 378
机器人流程自动化（RPA）是一种模拟人类操作、自动执行重复性任务的软件技术，其核心原理是通过录制或脚本控制界面元素，实现跨系统、跨应用的数据搬运与流程串联。这项技术的核心价值在于将人力从规则明确、耗时易错的繁琐工作中解放出来，显著提升工作效率与准确性。在校园服务与行政管理领域，RPA与Python等脚本技术结合，能有效应对信息收集、通知触达、数据核对等高频场景。例如，通过Python的Pandas库进行多源数据清洗与比对，结合自动化平台实现定时触发与消息推送，可以构建起智能化的信息处理闭环。本文以“辅导员C
多态和继承（2）——多重继承、子类互为友元
u010959041的专栏
06-09 1013
完成“学生cpp成绩计算”之后，修改Person和Student类，各自增加两个无参构造函数。 /*仍以Person类为基础，建立一个派生类Teacher，增加以下成员数据： int ID;//教师工号 Student stu[100];//学生数组 int count;//学生数目，最多不超过100 float cpp_average;//班级cpp平均分 增加以下成员函数： Te
利用pandas解决期末总成绩的计算（python）
weixin_45044349的博客
12-23 5850
1.从excel文件中读出本班同学的成绩册，并处理好缺失值。 2.根据‘加分’和‘减分’两列统计出平时成绩。 3.将实验报告成绩从ABCD转换为百分制，统计出实验成绩。A为90分，B为75分，C为60分，D为40分。 4.随机生成假设的期末成绩，取值区间为40-100分。将自己的期末成绩改成你觉得可能考到的分数。 5.按照平时成绩20%，实验成绩30%，期末成绩50%的比例计算综合成绩。 6.输出你自己的平时成绩，实验成绩，期末成绩和综合成绩。 7.统计全班综合成绩[90,100],[80,89],[70,
Python Pandas实现数据分组求平均值并填充nan
jiangjiane
05-29 1万+
Python实现按某一列关键字分组，并计算各列的平均值，并用该值填充该分类该列的nan值。DataFrame数据格式fillna方式实现DataFrame数据格式以下是数据存储形式： fillna方式实现按照industryName1列，筛选出业绩筛选出相同行业的Series计算平均值mean，采用fillna函数填充append到新DataFrame中循环遍历行业名称，完成2,3,4步骤fact...
pandas fillna_机器学习教程之小白入门Pandas
weixin_39860732的博客
11-27 622
如果你想要利用python来学习数据分析和机器学习，你将很有可能使用非常强大的Pandas库。Pandas是python的一个可供数据操纵和分析的开源库。今天的内容是小编带你对Pandas进行简单的入门。1 读取数据这有一种很简单的方式，就是你可以用Python加载数据表(tables)以及excel文件：Pandas可以让我们读取电子表格并且用python程序化地操纵它们。Pandas的核心是D...
pandas数据分析
changan
08-03 975
将指定多个聚合函数，分组统计，指定数组
Python实践之Pandas的使用——分析统计学生期末成绩并绘图
m0_61934621的博客
12-24 9012
1.从18.student_score.csv文件中读取同学的成绩册，处理好缺失值。 2.将实验报告成绩从ABCD转换成百分制，统计出实验成绩。A为90分，B为75分，C为60分，D为40分。 3.按照平时成绩20%，实验成绩30%，期末成绩50%的比例计算综合成绩，形成新的综合成绩列。 4.统计全班综合成绩[90,100],[80,89],[70,79],[60-69],[0,59]各段成绩的人数并画饼图。 5.将完整的成绩保存到score.csv文件中，打开excel检查输出是否正确。
python编程题15-统计学生成绩最高分 pandas
打土豆的小篮球
07-30 4665
题目：从excel文件中读取学生历次考试成绩，并统计最高分写入另一个文件 import pandas as pd #处理excel常用的库 如果要处理2003以前版本的excel文件，则要安装xlrd库 如果要处理2007以后版本的excel文件，则要安装openpyxl库 fn = '学生测试成绩.xlsx' #打开当前目录下的学生测试成绩.xlsx，需要要安装openpyxl库，如果不是同一目录，则要指明 df = pd.read_excel(fn) #df = pd.read_exc
pandas_VS_Excel统计各班成绩的最大最小平均分合格优秀尖子人数
fsyuheduo的博客
10-11 3784
pandas_VS_Excel统计各班成绩的最大最小平均分合格优秀尖子人数 [要求] 1.先分组再显示describe()情况 2.只统计“语文”“数学”“英语”三科各班的成绩最高分，最低分，平均分， 2.以上面的基础上设计自定义函数，增加统计：大于60分个数，大于80分个数，大于100分个数 【代码】 # -*- coding: utf-8 -*- import pandas as pd df...
PY-pandas | 作业-体测成绩转换
CY3761的博客
01-08 773
#%% # CY3761 | 2022-01-08 15:33 #%% # 套用模版后记住先执行-全部运行 #%% # 导入项 import numpy as np import pandas as pd np, pd #%% def printData(o): oItems = dict(dtype=None,dtypes=None,shape=None,size=None,index=None,columns=None) for (k,v) in oItems.items():
pandas批量处理体育成绩
Wind_know的博客
06-24 2118
目录 导包 读取数据 取前45行 图表中存在不规范数据，去掉该类数据 缺失数据填充 查看是否有空数据 处理数字 评分，还要读取评分表 将列属性时间数据转化为浮点数据 两张表索引不太对应，改变一下 增加字段 先转化数据 计算成绩 同理处理体前屈，引体，肺活量。 调整顺序 BMI指数 统计分析 画图 Pandas在处理千万行级别的数据中有非常高的实用价值，pandas 本质上是对表格数据的封装，而表格数据处理必然需要遍历数据。然而，在实际使用 pandas 过程中，一般都不
利用pandas进行数据清洗，利用神经网络预测成绩（参考数据酷客，学生成绩预测）
ArrogantT的博客
05-09 1881
111
pandas VS excel给成绩赋值等级
fsyuheduo的博客
10-05 2461
** pandas VS excel给成绩赋值等级 ** 【问题】有一张成绩表如下 【要求】 在总分后面添加一列，按如下要求输入等级 【知识点】 apply函数 apply函数是pandas里面所有函数中自由度最高的函数。该函数如下： DataFrame.apply(func, axis=0, broadcast=False, raw=False, reduce=None, args=(), ...
python爬虫爬取table数据-超简单
曼夭的博客
04-09 1万+
用pandas的read_html()方法 for df in pd.read_html(url): df.to_csv(path, mode='a',encoding='utf-8',header=0,index=False) 每一个页面的多个表格循环写入csv文件
python + pandas爬取网页表格数据
热门推荐
zhang862520682的博客
01-30 2万+
这里以工标网标准数据为例  http://www.csres.com/notice/50655.html   先请求页面，xpath定位表格区域 res = requests.get('http://www.csres.com/notice/50655.html') res_elements = etree.HTML(res.text) table = res_elements.xpat...
用pandas快速统计学生年龄班级等分组信息
wulishinian的博客
04-24 5809
最近收到一个求助邮件，他的需求如下： 我是小学的一名统计员，因长期做统计工作，近期，自学一点python，但如何把excel中的8位数出生日期转成年龄，一直做不好，现请您帮忙一下，不知能否帮！ 这个问题其实比较简单，做出来的最终形式如下： 主要涉及格式转换和分组统计的需求，那么我们就开始一步一步的完成这一次的任务。 1、读入excel文件 import pandas as pd file_nam...
爬虫爬取网页上的表格
幸运的Alina的博客
03-12 1万+
最近有个爬虫的需求，然后在做爬虫的过程中涉及到要去爬取网页中的表格内容，鉴于直接采用常规方法有点傻，于是记录了如何直接提取表格内的方法在此，以便后续再回顾。 from bs4 import BeautifulSoup import urllib import re import config #自己定义的配置文件 def spider_data(url): head = {} ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值