Python语言程序设计教程第十章课后习题答案

import pandas as pd

import numpy as np

import matplotlib.pyplot as plt

import matplotlib

excel = pd.read_excel('score.xlsx', sheet_name=[0,1])

score = excel[0]

duty = excel[1]

print(score)

print('*******************************************')

print('数据总行数：')

print(score.shape[0])

print('前3行数据：')

print(score.head(3))

print('新增总分列：*******************************************')

score['总分'] = score['语文']+score['数学']+score['英语']

print(score)

print('按总分降序排列：*******************************************')

score = score.sort_values(by=['总分'], ascending=False)

print(score)

print('男女平均分：*******************************************')

group = score.groupby('性别')

print(group.mean())

print('男女最高分：*******************************************')

print(group['总分'].max())

print(score[score['总分']==group['总分'].max()['男']])

print(score[score['总分']==group['总分'].max()['女']])

print('新增等级列：*******************************************')

score.loc[(score['总分'] >= 270), '等级'] = 'A'

score.loc[(score['总分'] < 270) & (score['总分'] >=210), '等级'] = 'B'

score.loc[(score['总分'] < 210), '等级'] = 'C'

#score.loc[score['等级'].isnull(), '等级'] = 'B'

print(score)

print('合并成绩表与职务表：*******************************************')

students = pd.merge(score,duty, on='学号', how='left')

print(students)

students.to_excel('Students.xlsx', sheet_name='sheet1')

students.to_csv('Students.csv', encoding=\"gb2312\")

students.to_html('Students.html')