python dataframe根据多列排名并生成序号_将rank字段添加到pandas dataframe，按唯一组和多列排序...

假设我有这个数据帧，我希望每个唯一的用户ID都有自己的基于日期戳的排名值：In [93]:

df = pd.DataFrame({

'userid':['a', 'a', 'a', 'a', 'b', 'b', 'b', 'b'],

'date_stamp':['2016-02-01', '2016-02-01', '2016-02-04', '2016-02-08', '2016-02-04', '2016-02-10', '2016-02-10', '2016-02-12'],

'tie_breaker':[1,2,3,4,1,2,3,4]})

df['date_stamp'] = df['date_stamp'].map(lambda x: datetime.datetime.strptime(x, "%Y-%m-%d"))

df['rank'] = df.groupby(['userid'])['date_stamp'].rank(ascending=True, method='min')

df

Out[93]:

date_stamp tie_breaker userid rank

0 2016-02-01 1 a 1

1 2016-02-01 2 a 1

2 2016-02-04 3 a 3

3 2016-02-08 4 a 4

4 2016-02-