题解 | #用分位数分析牛客网用户活动#

import pandas as pd
f=pd.read_csv('Nowcoder.csv',sep=',')
pd.set_option('display.width',300)
pd.set_option('display.max_rows',None)
pd.set_option('display.max_columns',None)

s1=pd.Series(data=[f.loc[:,'Achievement_value'].quantile(0.25),\
f.loc[:,'Continuous_check_in_days'].quantile(0.25)],name='0.25',\
index=['Achievement_value','Continuous_check_in_days'])

s2=pd.Series(data=[f.loc[:,'Num_of_exercise'].quantile(0.75),\
f.loc[:,'Number_of_submissions'].quantile(0.75)],name='0.75',\
index=['Num_of_exercise','Number_of_submissions'])

print(s1,s2,sep='\n')
#选择了最复杂的写法