Displaying 1 result from an estimated 1 matches for "id1564271".
Did you mean:
id1564270
2007 Feb 20
1
Reshape (pivot) question
...6 12:00 5555 1 NA ID1564264 1365 14.2.2006 14:35
5555 1 50 ID1564265 1342 7.4.2006 14:30 2222 2 50 ID1564266 1648 7.4.200614:30
2222 2 50 ID1564267 1263 10.2.2006 15:45 2222 2 10 ID1564267 1263
10.2.200615:45
3333 3 10 ID1564269 5646 13.5.2006 17:02 3333 3 10 ID1564270 7561
13.5.200617:02
6666 1 10 ID1564271 1676 15.5.2006 20:41 2222 2 20
How can I do a new (pivot?) data.frame in R which I can achieve by MS SQL:
select eala,
datepart(month, date) as month,
datepart(year, date) as year,
count(distinct id) as id_count,
count(distinct patient_id) as patient_count,
count(distinct(case when class =...