rearrange my data frame rows by a set order of index numbers

Question

How can I rearrange my data frame rows by a set order of index numbers?

for example:

$    PatNum Response
1       3       r
2       4       r
3      10       r
4      13       nr

This goes on for a total of 40 rows. I want to make row one starting with row 13, then 26, 1, 2, 61, 62, 63, etc. So it would look like:

$   PatNum Response
13      1       nr
26      2       nr
1       3       r
2       4       r

instead of copy/pasting your data, provide output of `dput(head(yourdataset))`. — M--, Oct 26 '17 at 19:55
Are you just trying to sort the` PatNum` column in descending order? — nak5120, Oct 26 '17 at 19:58
yes i want the "patNum" in ascending order from 1 to 40, but i want the number's corresponding "response" to move with the "PatNum"...does that make sense? — jclabrat, Oct 26 '17 at 20:03
This didn't work the way I wanted to but I can still use it. Thanks! — jclabrat, Oct 26 '17 at 20:17

score 3 · Accepted Answer · answered Oct 26 '17 at 20:15

3

Create example data

one <- c(3, 4, 10, 1, 2, 5)
two <- c("nr", "nr", "r", "r", "nr", "nr")
data <- cbind(one, two)
data <- as.data.frame(data)
names(data) <- c("PatNum", "Response")
data$PatNum <- as.numeric(as.character(data$PatNum))

Sort example data

data <- data[order(data$PatNum) , ]

answered Oct 26 '17 at 20:15

Justin Meyer

150
1
8

Thanks, that would be a long way around it though – jclabrat Oct 26 '17 at 20:18

rearrange my data frame rows by a set order of index numbers

1 Answers1

Create example data

Sort example data