Hi
r-help-boun...@r-project.org napsal dne 06.04.2009 05:01:56:
> 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.
If you want to sort and filter like in excel why not using excel
rowSums(table(test$user_id, test$website))
gives you info how many of websites were visited by each user_id. It is
not clear how days are coded so it is difficult to come with any
reasonable way how to compute numbers per day.
I would try to split/lapply way but there could be better means.
Regards
Petr
>
> 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.
______________________________________________
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.
