Dear all, I'm trying to process a log file which logs the date, the username
and the computer number accessed. The table looks like this:
>table.users
Date UserName Machine
1 2008-11-25 John 641
2 2008-11-25 Clive 611
3 2008-11-25 Jeremy 641
4 2008-11-25 Walt 722
5 2008-11-25 Tony 645
6 2008-11-26 Tony 645
7 2008-11-26 Tony 641
8 2008-11-26 Tony 641
9 2008-11-26 Walt 641
10 2008-11-26 Walt 645
11 2008-11-30 John 641
12 2008-11-30 Clive 611
13 2008-11-30 Tony 641
14 2008-11-30 John 641
15 2008-11-30 John 641
..................etc
What I want to do is to find out how many unique users logged on each day, and
how many individual machines where accessed per day. In the above example,
therefore on 2008-11-25 there were 5 separate users accessing 4 machines, on
2008-11-26 there were 2 unique users who used 2 machines (although both logged
on more than once).
I've got as far as apply(table.users, 2, FUN=table) which gives me an output of
date, or username or machine and how many times they were accessed, but not
really what I want.
Any help appreciated
Jabez
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
