Is there any faster way to order data across columns within each row - R

Asked Mar 08 '20 at 08:14

Active Mar 08 '20 at 18:45

Viewed 31 times

Suppose I have the following data

df <- data.frame(v1 = c("a", "z"), v2 = c("y", "b"), v3 = c("m", "n"))

v1 v2 v3
 a  y  m  
 z  b  n

What is the fastest way to create 3 new columns with ordered data like the following?

v1 v2 v3 alphabetical_1 alphabetical_2 alphabetical_3
 a  y  m              a              m              y
 z  b  n              b              n              z

I have thousands of rows of data like this.

edited Mar 08 '20 at 18:45

Manjuboyz

6,978
3
21
43

asked Mar 08 '20 at 08:14

johnny

1

`df[paste0('alphabetical_', seq_along(df))] <- t(apply(df, 1, sort))` – Ronak Shah Mar 08 '20 at 08:19
1

@RonakShah Thanks a lot Ronak. Your comment was really helpful! – johnny Mar 09 '20 at 06:14

Is there any faster way to order data across columns within each row - R

0 Answers0