我有这样的数据帧
Game date | Team | Player |
---|---|---|
2020-09-12 | Liverpool | A |
2020-09-12 | Liverpool | B |
2020-09-12 | Liverpool | C |
2020-09-12 | Man Utd | D |
2020-09-12 | Man Utd | E |
2020-09-12 | Man Utd | F |
2020-09-12 | Arsenal | G |
2020-09-12 | Arsenal | H |
2020-09-12 | Arsenal | I |
2020-09-15 | Liverpool | A |
2020-09-15 | Liverpool | B |
2020-09-15 | Liverpool | C |
2020-09-15 | Man Utd | D |
2020-09-15 | Man Utd | E |
2020-09-15 | Man Utd | Q |
2020-09-15 | Arsenal | G |
2020-09-15 | Arsenal | O |
2020-09-15 | Arsenal | I |
2020-09-18 | Liverpool | A |
2020-09-18 | Liverpool | B |
2020-09-18 | Liverpool | C |
2020-09-18 | Man Utd | M |
2020-09-18 | Man Utd | H |
2020-09-18 | Man Utd | Q |
2020-09-18 | Arsenal | G |
2020-09-18 | Arsenal | H |
2020-09-18 | Arsenal | I |
我想统计一下与前一场比赛(准确地说是上一场比赛)相比,球队中出现了多少独特的价值.如果球员出现在第一局,第二次失误,出现在第三局,他应该是唯一的价值在第三局).
期望输出
Game date | Team | Unique players |
---|---|---|
2020-09-15 | Liverpool | 0 |
2020-09-15 | Man Utd | 1 |
2020-09-15 | Arsenal | 1 |
2020-09-18 | Liverpool | 0 |
2020-09-18 | Man Utd | 2 |
2020-09-18 | Arsenal | 1 |
有什么高雅的方法可以做到这一点吗?