[R] how to sort and plot data?

Petr PIKAL petr.pikal at precheza.cz
Mon Apr 6 09:48:20 CEST 2009


Hi

r-help-bounces at 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.srinivasan at 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.menne at 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 at 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 at 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 at 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.




More information about the R-help mailing list