Hi, thanks you for the answer. Sorry English is not my native language. But you got it right. > As C is first and fourth biggest value, you follow third option and select 3 highest A, 3B 2C and 2D?
I must select the 10 (not 15) highest values, but which follow a certain order: 3A - 3B - 2C - 2D or 2A - 5B - 0C - 3D or 3A - 3B - 2C - 2D I'll put the example in Excel for a better understanding (with 20 elements only). I must select 10 elements (the highest values of variable Var.2), which fit one of the 3 options above. Number Position Var.1 Var.2 1 27 C 40 2 30 B 39 Selected: 3 5 A 38 Number Position Var.1 Var.2 4 16 D 37 1 27 C 40 5 23 C 36 2 30 B 39 3A - 3B - 2C - 2D 6 13 A 35 3 5 A 38 7 20 D 34 4 16 D 37 3A - 3B - 1C - 3D 8 12 D 33 5 23 C 36 9 9 A 32 6 13 A 35 2A - 5B - 0C - 3D 10 1 A 31 7 20 D 34 11 21 A 30 10 9 A 32 12 35 C 29 13 14 B 28 13 14 B 28 17 6 B 25 14 8 D 27 15 7 C 26 16 6 B 25 17 40 D 24 18 26 B 23 19 29 A 22 20 31 C 21 Second option (other data set): Number Position Var.1 Var.2 1 36 D 20 2 11 B 19 Selected: 3 39 A 18 Number Position Var.1 Var.2 4 24 D 17 1 36 D 20 5 34 B 16 2 11 B 19 3A - 3B - 2C - 2D 6 2 B 15 3 39 A 18 7 3 A 14 4 24 D 17 3A - 3B - 1C - 3D 8 32 D 13 5 34 B 16 9 28 D 12 6 2 B 15 2A - 5B - 0C - 3D 10 25 A 11 7 3 A 14 11 19 B 10 8 32 D 13 12 15 B 9 9 25 A 11 13 17 A 8 10 18 C 7 14 18 C 7 15 38 B 6 16 10 B 5 17 22 B 4 18 4 D 3 19 33 A 2 20 37 A 1 How to make the selection of these 10 elements that fit one of the 3 options using R? Thanks, Prof. Dr. Silvano Cesar da Costa Universidade Estadual de Londrina Centro de Ciências Exatas Departamento de Estatística Fone: (43) 3371-4346 Em sex., 20 de ago. de 2021 às 03:28, PIKAL Petr <petr.pi...@precheza.cz> escreveu: > Hallo > > I am confused, maybe others know what do you want but could you be more > specific? > > Let say you have such data > set.seed(123) > Var.1 = rep(LETTERS[1:4], 10) > Var.2 = sample(1:40, replace=FALSE) > data = data.frame(Var.1, Var.2) > > What should be the desired outcome? > > You can sort > data <- data[order(data$Var.2, decreasing=TRUE), ] > and split the data > > split(data$Var.2, data$Var.1) > $A > [1] 38 35 32 31 30 22 11 8 2 1 > > $B > [1] 39 28 25 23 16 15 7 6 5 4 > > $C > [1] 40 36 29 26 21 19 18 14 10 9 > > $D > [1] 37 34 33 27 24 20 17 13 12 3 > > T inspect highest values. But here I am lost. As C is first and fourth > biggest value, you follow third option and select 3 highest A, 3B 2C and 2D? > > Or I do not understand at all what you really want to achieve. > > Cheers > Petr > > > -----Original Message----- > > From: R-help <r-help-boun...@r-project.org> On Behalf Of Silvano Cesar > da > > Costa > > Sent: Thursday, August 19, 2021 10:40 PM > > To: r-help@r-project.org > > Subject: [R] Selecting elements > > > > Hi, > > > > I need to select 15 elements, always considering the highest values > > (descending order) but obeying the following configuration: > > > > 3A - 4B - 0C - 3D or > > 2A - 5B - 0C - 3D or > > 3A - 3B - 2C - 2D > > > > If I have, for example, 5 A elements as the highest values, I can only > choose > > (first and third choice) or 2 (second choice) elements. > > > > how to make this selection? > > > > > > library(dplyr) > > > > Var.1 = rep(LETTERS[1:4], 10) > > Var.2 = sample(1:40, replace=FALSE) > > > > data = data.frame(Var.1, Var.2) > > (data = data[order(data$Var.2, decreasing=TRUE), ]) > > > > Elements = data %>% > > arrange(desc(Var.2)) > > > > Thanks, > > > > Prof. Dr. Silvano Cesar da Costa > > Universidade Estadual de Londrina > > Centro de Ciências Exatas > > Departamento de Estatística > > > > Fone: (43) 3371-4346 > > > > [[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. > [[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.
