这个题目主要考查DataFrame的基本用法。
任务1:创建数据框
import pandas as pd
data=pd.DataFrame({'Name':['Oscar','Lucy','Henry','Jim','Nancy','Lily','Bill','Snow','Vivian'],
'Class':[1,1,2,1,2,3,2,3,3],
'Gender':['M','F','M','M','F','F','M','M','F'],
'Writing':[90,92,56,92,90,77,86,51,91],
'Math':[99,81,81,95,80,47,92,58,70],
'Sports':[88,85,93,90,75,88,81,96,78]})
data.info()
任务2:考查loc用法
data.loc[2:5,['Name','Writing','Math']]
任务3:分组统计
data.groupby(data['Gender'])['Sports'].mean()
任务4:排序
data.sort_values(by='Math',ascending=False)
任务5:条件筛选
data[(data['Class']==2) & (data['Writing']<60)]
任务6:增加列、删除列等
data['Score']=data[['Writing','Math','Sports']].sum(axis=1)
data1=data.drop(columns=['Writing','Math','Sports'])
data1['Score'].max()
data1['Score'].min()
data1['Score'].mean()
data1['Score'].std()
运行结果嘛,这里就不给出了,自己尝试运行一下哦。