這個問題在這里已經有了答案:
uj5u.com熱心網友回復:
采用:
df['backlog_wish_req_mean_days']=(df.groupby(['stud_id','sub_code'])['backlog_wish_req_diff']
.transform('mean'))
print (df)
stud_id sub_code ques_date resp_date marks next_ques_date \
3 101 CSE01 2016-03-27 29/03/2016 90 2017-11-11
2 101 CSE01 2017-11-11 14/11/2017 55 2018-01-10
1 101 CSE01 2018-01-10 11/1/2018 86 2020-11-13
0 101 CSE01 2020-11-13 NaN 77 NaT
7 101 CSE02 2006-02-27 28/02/2006 67 2007-01-11
6 101 CSE02 2007-01-11 NaN 80 2008-11-10
5 101 CSE02 2008-11-10 NaN 90 2010-05-13
4 101 CSE02 2010-05-13 NaN 65 NaT
backlog_wish_req_diff backlog_wish_req_mean_days
3 594.0 564.0
2 60.0 564.0
1 1038.0 564.0
0 NaN 564.0
7 318.0 512.0
6 669.0 512.0
5 549.0 512.0
4 NaN 512.0
轉載請註明出處,本文鏈接:https://www.uj5u.com/yidong/426994.html
標籤:Python 熊猫 数据框 麻木的 熊猫-groupby
