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

import pandas as pd
data = pd.read_csv('Nowcoder.csv')
# 方法一：使用.quantile()函数求百分位数
# print(data[['Achievement_value', 'Continuous_check_in_days']].quantile(q=0.25))
# print(data[['Num_of_exercise', 'Number_of_submissions']].quantile(q=0.75))
# 方法二：对.describe()的dataframe使用.loc方法取出相应数据
total_data = data.describe().rename(index={'25%':'0.25','75%':'0.75'}) # 对行索引重命名
print(total_data.loc['0.25',['Achievement_value', 'Continuous_check_in_days']])
print(total_data.loc['0.75',['Num_of_exercise', 'Number_of_submissions']])