Merge rows in the same data.frame [R]

Question

I have a data.frame with the specific format:

df <- structure(list(Left.align = c("A", "B", "C", "F"), Right.align = c("B", 
"A", "D", "E"), Center.align = c(2, 2, 3, 6)), .Names = c("Left.align", 
"Right.align", "Center.align"), row.names = c(NA, -4L), class = "data.frame")

df
  Left.align Right.align Center.align
1          A           B            2
2          B           A            2
3          C           D            3
4          F           E            6

I would to remove B A 2, because the result is the same that A B 2. How will I do this in R?

thanks!

Just do `df1[!duplicated(t(apply(df1, 1, sort))),]` – akrun Aug 15 '17 at 19:17 — akrun, Aug 15 '17 at 19:17

score 1 · Answer 1 · answered Aug 15 '17 at 19:32

1

We can sort by row and then use duplicated to get a logical index to subset the rows of dataset

df1[!duplicated(t(apply(df1, 1, sort))),]

answered Aug 15 '17 at 19:32

akrun

874,273
37
540
662

If I have a table with the same characters in different columns, for example: 1 A A 2 How Could I remove this rows? thanks – Leandro Nascimento Lemos Aug 16 '17 at 17:27
@LeandroNascimentoLemos Do you want to remove those columns? – akrun Aug 17 '17 at 03:25

Merge rows in the same data.frame [R]

1 Answers1