Try looking at the examples in :
?order
perhaps:
dta.frm[order(user_id), ]
.... especially the one that demonstrates how to sort dataframes
with three indices. And if that does not satisfy your needs, then you
absolutely must provide a simple example and an explicit layout of
what the output should look like.
--
David Winsemius
On Apr 5, 2009, at 11:01 PM, Hemavathi Ramulu wrote:
hi Erin,
Thanks for your reply to my problems. I tried and it works, but it
sorted
all the column. In my case, I want it to sort d user_id column and
another
information in other column will follow it. Now, after I sorted, the
information which website viewed by user was wrong. I want to as how
we can
sort or filter in excel.
Thank you.
regards,
hema
On Fri, Apr 3, 2009 at 4:44 PM, Umesh Srinivasan <umesh.sriniva...@gmail.com
wrote:
Hi,
There is definitely a more elegant way of doing this which I don't
know
about (without a for loop), but try this:
mat <- matrix(NA, nrow = max(user_id), ncol = 2)
mat[,1] <- 1:max(user_id) # 1st column of matrix is the user ID
for (i in 1:max(user_id)){
temp1 <- subset(data, user_id = i)
temp2 <- unique(temp1$website)
mat[2,i] <- length(temp2)
}
The matrix will give you user id and number of sites visited,
provided user
id ranges from 1 to the number of users. There must be a way to do
this
using table, but I cant figure it out.
Cheers,
Umesh
On Fri, Apr 3, 2009 at 1:42 PM, Dieter Menne
<dieter.me...@menne-biomed.de>wrote:
Hem wrote:
user_id website time
20 google 0930
21 yahoo 0935
20 facebook 1000
25 facebook 1015
61 google 0940
...
My problem is how to sort the data? So that, I can get information
about
one
user_id viewed how many website perday?
Maybe you were looking at the wrong item, because what you want is
not
sorting, but a table.
Check the documentation of table or ftable.
Dieter
--
View this message in context:
http://www.nabble.com/how-to-sort-and-plot-data--tp22861661p22863918.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
[[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.
[[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.
David Winsemius, MD
Heritage Laboratories
West Hartford, CT
______________________________________________
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.