求,annaconda,jupter,pandas.DataFrame

img

这个题目主要考查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()

运行结果嘛,这里就不给出了,自己尝试运行一下哦。