如何获取Python重采样函数来计算UNIQUE值

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