Please use dput() to provide data, rather than expecting people to open random attachments. Besides, there are multiple options for getting data into R, and we need to know exactly what you did. dput() is faster and easier.
What have you tried? Did you look at aggregate() as I suggested? Sarah On Sat, Sep 5, 2015 at 10:44 AM, Ragia Ibrahim <ragi...@hotmail.com> wrote: > thanks for replying, I attached the data frame > for source "i" I want to sum the values and get the max value then add a > new column called rank . That new column cell value for each source i and > for specific id would be (value/max value) * count of rows that have the > same criteria "same i and same id" > > many thanks > Ragia > >> Date: Fri, 4 Sep 2015 10:19:35 -0400 >> Subject: Re: [R] groups Rank >> From: sarah.gos...@gmail.com >> To: ragi...@hotmail.com >> CC: r-help@r-project.org >> >> Hi Ragia, >> >> I can't make out your data or desired result, but it sounds like >> aggregate() might get you started. If you need more help, please >> repost your data using dput() and do NOT post in HTML so that we can >> see what your desired result looks like. >> >> Sarah >> >> On Fri, Sep 4, 2015 at 10:12 AM, Ragia Ibrahim <ragi...@hotmail.com> >> wrote: >> > Dear Group,kinldy, I have the following data frame df >> > id value1 1 4 2 1 4 3 1 6 4 1 6 5 2 1.5 6 2 2.5 7 2 2.5 8 2 2.5 >> > >> > add rank column regarding id coulmn where rank for the highest value >> > would be 1, others rank would be the (value/ value of heighest)/ number of >> > rows that took the same value >> > thus the data frame should be >> > id value Rank1 1 4 0.332 1 4 0.333 1 6 0.54 1 6 0.55 2 1.5 0.6 6 2 2.5 >> > 0.337 2 2.5 0.338 2 2.5 0.33 >> > >> > how to reach this resultthanks in advanceRagia >> > [[alternative HTML version deleted]] >> > ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
