I want to sort all columns of a data frame in R by a column containing alphanumeric data. Here is an example data frame:
R> dd <- data.frame(b = c("Hi", "Med", "Hi", "Low"),
x = c("A", "D", "A", "C"), y = c(8, 3, 9, 9),
z = c("A1", "A3", "A10", "A2"))
1 Hi A 8 A1
2 Med D 3 A3
3 Hi A 9 A10
4 Low C 9 A2
I would like to sort the entire data frame on column z. The desired output looks like this - with the info across columns staying consistent:
1 Hi A 8 A1
2 Low C 9 A2
3 Med D 3 A3
4 Hi A 9 A10
Here are the methods I've tried so far that have not worked:
Method 1: "A10" is incorrectly sorted
R> dd<- dd[with(dd, order(z)), ]
R> View(dd)
1 Hi A 8 A1
4 Hi A 9 A10
2 Low C 9 A2
3 Med D 3 A3
Method 2: No sort performed
R> library(gtools)
R> dd$z = factor(dd$z, levels = gtools::mixedsort(dd$z))
R> View(dd)
1 Hi A 8 A1
2 Med D 3 A3
3 Hi A 9 A10
4 Low C 9 A2
Method 3: No sort performed
R> library(stringr);
R> dd$z = factor(dd$z, levels = str_sort(dd$z, numeric=TRUE))
R> View(dd)
1 Hi A 8 A1
2 Med D 3 A3
3 Hi A 9 A10
4 Low C 9 A2