An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20090403/a4e33ce0/attachment-0001.pl>
how to sort and plot data?
7 messages · Hemavathi Ramulu, Dieter Menne, Umesh Srinivasan +3 more
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.
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20090403/e8d719e7/attachment-0001.pl>
2 days later
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20090406/eb929678/attachment-0001.pl>
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.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.
David Winsemius, MD
Heritage Laboratories
West Hartford, CT
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.
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20090406/e26d66a2/attachment-0001.pl>