如何使Python重采样函数计数唯一值？

Question

我希望我的代码能够计算唯一的值，而不是所有的值一起计算。

数据样本：

Date        Status        Proj_ID

2021-09-30  Started       p1
2021-09-30  Started       p3
2021-10-19  Started       p4
2021-10-22  Not Started   p2
2021-10-22  Started       p5

当前代码的输出：

Week         #
2021-09-27   2
2021-10-04   0
2021-10-11   0
2021-10-18   3 

我想要的是：

Week         Status       #
2021-09-27   Started      2
2021-10-04   0
2021-10-11   0
2021-10-18   Started      2
             Not Started  1

我现在的代码是：

val3.set_index('Migration/Delete Date', inplace=True)
        
nf_all = val3.resample('W-MON', label='left',closed='left').size()

Answer 1

试试这个：

df.groupby('Status').resample('W-Mon', label='left',closed='left')['Status']\
  .count().swaplevel(0,1).sort_index(level=0).to_frame()

输出：

                        Status
Date       Status             
2021-09-27 Started           2
2021-10-04 Started           0
2021-10-11 Started           0
2021-10-18 Not Started       1
           Started           2