Python - 我想group_by 10 年的间隔并将其合并回来

Question

我的数据如下所示：

Pkey    CalenderYear
1   1996
2   2005
3   2010
4   2019
5   1985

我想按十年间隔对其进行分类

decade = 10 * (df_CNratio['CalenderYear'] // 10)
decade = decade.astype(str) + 's'
decade.name = 'decade'
My desired outcome:
Pkey  CalenderYear Interval
1      1996         1990
2      2005         2000
3      2010         2010
4      2019         2010
5      1985         1980

在熊猫中怎么做？

Answer 1

只需要将解决方案分配给新列：

df['Interval'] = (10 * (df['CalenderYear'] // 10)).astype(str) + 's'
print (df)
   Pkey  CalenderYear Interval
0     1          1996    1990s
1     2          2005    2000s
2     3          2010    2010s
3     4          2019    2010s
4     5          1985    1980s