[R] dplyr question
Ragia Ibrahim
ragia11 at hotmail.com
Sun Sep 6 19:41:18 CEST 2015
Dear group,
I have the following data frame df
Measure_id i j id value1 1 5 1 1 2.02 1 5 2 1 2.03 1 5 1 2 1.54 1 5 2 2 1.55 1 5 1 3 0.06 1 5 2 3 0.07 1 5 1 4 0.08 1 5 2 4 1.09 1 5 1 5 1.010 1 5 2 5 2.0.. ... . . .. ...I want to add a probability column, the prob column depends on id grouped by for each ithe rank will be current (value / max value ) for the same id for specific i, it would be
Measure_id i j id value prob1 1 5 1 1 2.0 2/2 2 1 5 2 1 2.0 2/2 3 1 5 1 2 1.5 1.5/1.5 4 1 5 2 2 1.5 1.5/1.5 5 1 5 1 3 0.0 06 1 5 2 3 0.0 07 1 5 1 4 0.0 0/1 8 1 5 2 4 1.0 1/1 9 1 5 1 5 1.0 1/210 1 5 2 5 2.0 2/3.. ... . . .. ...
then I want to add a rank coulmn that rank regarding probability, if the probability equal they took the same rank for thesame id belongs to the same i, otherwize lower probability took higher rank for examole if we have three values for i=7 and for the three values the id is 1 and the probability is ( .2,.4,.5) the rank should be 3,2,1
replying highly appreciatedRagia
[[alternative HTML version deleted]]
More information about the R-help
mailing list