Say I have:
Date ID
2000-01-01 1
2000-01-02 1
2000-01-03 1
2000-01-01 2
2000-01-01 2
2000-01-01 3
2000-01-10 3
2000-01-04 3
I want to count consecutive dates by ID. how can I get something like:
Date ID count
2000-01-01 1 1
2000-01-02 1 2
2000-01-03 1 3
2000-01-01 2 1
2000-01-01 2 1
2000-01-01 3 1
2000-01-10 3 3
2000-01-04 3 2