r - 使用非数字列手动对数据框进行排序

Question

我有以下数据框

    dd <- data.frame(b = c("High", "Medium", "Highest", "Low", "Not bad","Good", "V. Good"),
   x = c("C3", "C1", "C4", "N2", "C2", "N1","N4"), x = c("5", "2", "3", "6", "7", "5","7") )

所以我想使用变量X的手动顺序来转换数据框。

例如:那是原始的

1    High C3   5
2  Medium C1   2
3 Highest C4   3
4     Low N2   6
5 Not bad C2   7
6    Good N1   5
7 V. Good N4   7

但是我想要的是一个基于X的值开始的新数据帧，但不是按字母顺序，而是以我选择的顺序随机进行，例如:

the first row has x=C1, the second have x=C2, the third have x=N4, ...etc

如何做到这一点？

谢谢你

Answer 1

由于x列是一个因素，
您只需确保其级别符合您想要的顺序即可。

# New sorting order
desired_order <- sample(levels(dd$x))
# Re-order the levels
dd$x <- factor( as.character(dd$x), levels=desired_order )
# Re-order the data.frame
dd <- dd[order(dd$x),]