浙江省杭州市周边四校2022-2023学年高二上学期信息技术2月期末联考卷

import pandas as pd

import matplotlib.pyplot as plt

plt.rcParams['font.sans-serif']=['SimHei'] #正常显示汉字

df=pd.read_excel('学考成绩.xlsx')

df.折算分= 

#对df 以“班级”为主要关键字升序、“A 总数”为次要关键词降序进行排序

df_sort=df.sort_values(['班级','A  总数'],ascending=[True,False])

result=df_sort.head(5)

for i in range(2,7):

    result=result.append( .head(5),ignore_index=True)

result.to_excel('各班前5名统计.xlsx')

df=df[df.折算分>92]

df_count=df.groupby('班级').count()

#修改“折算分”  列名为“上线人数”

df_count = df_count.rename(columns={'折算分':'上线人数'})

x=df_count.index

y= 

plt.figure(figsize=(8,4))

plt.bar(x,y, label='上线人数')

plt.ylim(15,30)

plt.legend()

plt.show()

#图像输出程序略

图-2

from PIL import Image

#输入起始点坐标(xs,ys)，信息点宽度高度(fw, fh)，间隔宽度高度(sw ,sh)，代码略

num = 5                              #判分个数

def bw_judge(R, G, B):      # bw_judge用于判断一个像素的填涂情况

代码略

def fill_judge(x, y):            # fill_judge用于判断信息点的填涂情况

    count = 0

    for i in range(x, x + fw + 1):

        for j in range(y, y + fh + 1):

            R, G, B = pixels[i, j]

            if bw_judge(R, G, B) = = True:

                count = count + 1

    if count >=:

        return True

total_width = fw+ sw

total_height = fh + sh

image = Image.open("t2.bmp")

pixels = image.load()

number = ""

bz=[""]*num

df=0

bzd=input('请输入标准答案：')

da={"A":"1000","B":"0100","C":"0010","D":"0001"}

for i in range(len(bzd)):

    bz[i]=

    for row in range(num):

        for col in range(4):

            y = ys + total_height * row

            if fill_judge(x, y) == True :

                number = number + '1'

            else:

                number = number + '0'

        if number = = bz[row]：

            df+=2

            number=""

print("得分为： ",df)

#分数判定