Task: Pandas Count Distinct Equivalent

Task: Pandas Count Distinct Equivalent: a task in Terminal-Lego-15k (Harbor dataset). You need to implement the SQL COUNT(DISTINCT) functionality using Pandas. Given a dataset containing client transaction records with columns including YEARMONTH and CLIENTCODE , you need to count the number of…

The task

You need to implement the SQL `COUNT(DISTINCT)` functionality using Pandas. Given a dataset containing client transaction records with columns including `YEARMONTH` and `CLIENTCODE`, you need to count the number of unique clients for each year-month period.

Part of PrimeIntellect/Terminal-Lego-15k.