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

import sys
import pandas as pd 
import numpy as np

df = pd.read_csv('Nowcoder.csv', dtype={
    'Achievement_value': np.int16,
    'Continuous_check_in_days': np.int16,
    'Num_of_exercise': np.int16,
    'Number_of_submissions': np.int16
    })
result_1 = df.agg({
    'Achievement_value': lambda x: round(x.quantile(q=0.25), 1),
    'Continuous_check_in_days': lambda x: round(x.quantile(q=0.25), 1)
})
print(pd.Series(result_1, name='0.25'))
result_2 = df.agg({
    'Num_of_exercise': lambda x: round(x.quantile(q=0.75), 2), 
    'Number_of_submissions': lambda x: round(x.quantile(q=0.75), 2)
})
print(pd.Series(result_2, name='0.75'))