pandas 作业

通过pandas的相关方法来实现数据在excel表中的写入、读取、文件数据更改、删除、表格合并等操作

利用数生成表格并存储文excel文件

import pandas as pd import numpy as np stu_names = ["胡歌","林更新","金世佳","丑娟"] courses = ['语文', '数学', '英语', 'Python', '体育'] data = np.array([[87., 74., 98., 84., np.nan],[79., 69., 61., 99., np.nan],[84., 84., 94., 66., np.nan],[90., 60., 72., 90., np.nan]]) lesson_score = pd.DataFrame(data,index = stu_names, columns = courses) lesson_score

lesson_score.to_excel("学生成绩表.xlsx") ele_names = ["胡歌","林更新","金世佳","丑娟"] ele_courses = ['统计学', '日语'] data = np.array([ [1,np.nan], [np.nan , 20], [20,30], [666,666] ]) lesson_df = pd.DataFrame(data, index = ele_names,columns = ele_courses) lesson_df .to_excel("选修成绩表.xlsx") lesson_df

读取文件

excel_1 = pd.read_excel("学生成绩表.xlsx",index_col=[0]) excel_1 excel_2 = pd.read_excel("选修成绩表.xlsx",index_col=[0]) excel_2

删除行

excel_1.drop("体育",axis = 1) excel_1

两个表格的合并

lesson_score["统计学"] = lesson_df["统计学"] lesson_score["日语"] = lesson_df["日语"] lesson_score

算总成绩

lesson_score["总成绩"] = lesson_score.sum(axis = 1) lesson_score.to_excel("总表.xlsx") lesson_score