Help with months
Hi !
I have data that is organized like this
Grid Date
1 11/10/12
1 11/10/12
1 15/10/12
1 1/1/13
1 5/1/13
1 10/1/13
2 4/12/12
2 5/12/12
2 7/12/12
2 10/4/13
3 1/1/12
3 2/1/12
3 3/1/12
3 4/1/12
4 10/6/11
4 11/6/11
4 15/6/11
4 17/6/11
5 19/6/11
5 20/5/11
5 22/5/11
So what I'd like to know is how many days each grid has. For eg:grid 1 has been sampled form 11/10/12 to 15/10/12 in Oct, that's 5 days and similarly in January 13 it has 5 days. grid 2 worked in dec12 for 4 days from 4th to 7th.
So I would like my output to look like this
grid Jan11 Feb11 MAr11 ....Oct12...dec12
1 5 0 0 5 0
2 0 0 0 0 4
Please help !
Thanks in advance!
|