[datatable-help] Summarising by recurrance

tsuimark tsuimark at hotmail.co.uk
Wed Jan 13 15:34:35 CET 2016


I have a very large dataset showing logins to a website. I'm trying to
calculate the frequency of logins by username.

what I hope to get is a table like the below where the period is listed as
row names and the frequency is the column header.i.e.

[count of log in][   1][    2][    3][   4][    5][   6][    7][    8][   9]  
[Monday         ][120][210][540][240][150][456][410][240][540]
[Tuesday        ][150][280][140][640][180][123][210][320][240]

The data is simply login id, date/time login. I've been able to add columns
appending the month, name of the day, and day number based on the date of
login.

ideally I'd like to be able to get the same sort of summary as above for
each category (Month, day of month, day name). 

My knowledge of R is rudimental at best

I hope someone can help me.

Kind regards,

Mark.



--
View this message in context: http://r.789695.n4.nabble.com/Summarising-by-recurrance-tp4716393.html
Sent from the datatable-help mailing list archive at Nabble.com.


More information about the datatable-help mailing list