Identifying the particular X or Y in a sorted list
simply change the specification in the subset command to >0 John Kane Kingston ON Canada -----Original Message----- From: shankarlanke at gmail.com Sent: Thu, 3 May 2012 16:51:50 -0400 To: jrkrideau at inbox.com Subject: Re: [R] Identifying the particular X or Y in a sorted list Dear John, Thank you very much for your response, I appreciate your input. I am able to subtract the two columns, (B - C) , the subset information I need is how many "A"s and who are the "A". For example P,Q,R,S,T, persons earned $ 7, 2, 3, 6, 9 in 1 st month and $ 4, 6, 9, 2, 5 in 2nd month. I want to identify who earned more on 1st month + the difference (only if it is positive). In this case P,S,T earned $3,4,4, in 2nd month. mydata <- data.frame( a = c(1, 2, 3, 4 , 5), b = c(7, 2, 3, 6, 9), c = c(4, 6, 9, 2, 5)) mydata$d <- mydata$b - mydata$c mydata subset(mydata, mydata$d ==max(mydata$d))
On Thu, May 3, 2012 at 2:47 PM, John Kane <[1]jrkrideau at inbox.com> wrote:
I'm sorry, it's still not clear what you are doing but perhaps this is close? mydata <- data.frame( a = c(1, 2, 3, 4 , 5), b = c(7, 2, 3, 6, 9), c = c(4, 6, 9, 2, 5)) mydata$d <- mydata$b - mydata$c mydata subset(mydata, mydata$d ==max(mydata$d)) John Kane Kingston ON Canada -----Original Message----- From: [2]shankarlanke at gmail.com Sent: Thu, 3 May 2012 14:14:17 -0400 To: [3]jrkrideau at inbox.com Subject: Re: [R] Identifying the particular X or Y in a sorted list Dear All, Thank you very much in advance. I have a data sets as shown below A (Patient ID ), B and C are the Concentration of drug in blood on day 1 and day 4, D is the difference in conc. To do this in R I have written a code as follows, identified the number of patients who have more concentration on day 4 . Here I want to identify specifically the patient ID (is he patient 1 or 2 or 5 and 7), whose concentration is more. How to write a code to get the list of A (patient ID whose difference is more on day 4). A 1 2 3 4 5 B 7 2 3 6 9 C 4 6 9 2 5 (B-C) 3 -4 -6 4 4 DF1<-list(A,B,C) DF1 DF2<-(DF1$C-DF1$B) length(DF2) sum(DF2>0) #I want to subtract B from C to see and identify how many patients have greater concentrations and who are these patients (A).
On Thu, May 3, 2012 at 12:15 PM, John Kane <[4]jrkrideau at inbox.com> wrote:
You do not seem to have suppied either code nor data. Please supply both.
John Kane
Kingston ON Canada
> -----Original Message-----
> From: [5]shankarlanke at gmail.com
> Sent: Wed, 2 May 2012 22:06:54 -0400
> To: [6]r-help at r-project.org
> Subject: [R] Identifying the particular X or Y in a sorted list
>
> Dear All,
>
> I have a data sets as shown below A (Patient ID ), B and C are the
> Concentration of drug in blood on day 1 and day 4, D is the difference in
> conc. To do this in R I have written a code as follows, identified the
> number of patients who have more concentration on day 4 . Here I want to
> identify specifically the patient ID (is he patient 1 or 2 or 5 and 7),
> whose concentration is more.
> How to write a code to get the list of A (patient ID whose difference is
> more on day 4).
>
> Data<-(myDf$B-myDf$C)
> sum(Data>0)
>
> A B CD (B-C) 1 14 10 4 2 12 7 5 3 11 15 -4 4 8 3 5 5 1 8 -7
>
> I appreciate your help, thank you very much in advance.
>
> Regards
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> [7]R-help at r-project.org mailing list
> [8]https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> [9]http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
____________________________________________________________
GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at
[10]http://www.inbox.com/smileys
Works with AIM?, MSN? Messenger, Yahoo!? Messenger, ICQ?, Google Talk? and
most webmails
--
Regards,
Shankar Lanke Ph.D.
Assistant Professor
Department of Pharmaceutical Sciences
College of Pharmacy
The University of Findlay
(C) [11]678-232-3567
(O) [12]419-434-5448
Fax# [13]419-434-4390
_________________________________________________________________
Free Online Photosharing - Share your photos online with your friends and
family!
Visit [14]http://www.inbox.com/photosharing to find out more!
--
Regards,
Shankar Lanke Ph.D.
Assistant Professor
Department of Pharmaceutical Sciences
College of Pharmacy
The University of Findlay
(C) 678-232-3567
(O) 419-434-5448
Fax# 419-434-4390
_________________________________________________________________
[15]3D Marine Aquarium Screensaver Preview
Free 3D Marine Aquarium Screensaver
Watch dolphins, sharks & orcas on your desktop! Check it out at
[16]www.inbox.com/marineaquarium
References
1. mailto:jrkrideau at inbox.com
2. mailto:shankarlanke at gmail.com
3. mailto:jrkrideau at inbox.com
4. mailto:jrkrideau at inbox.com
5. mailto:shankarlanke at gmail.com
6. mailto:r-help at r-project.org
7. mailto:R-help at r-project.org
8. https://stat.ethz.ch/mailman/listinfo/r-help
9. http://www.R-project.org/posting-guide.html
10. http://www.inbox.com/smileys
11. tel:678-232-3567
12. tel:419-434-5448
13. tel:419-434-4390
14. http://www.inbox.com/photosharing
15. http://www.inbox.com/marineaquarium
16. http://www.inbox.com/marineaquarium