r - how to combine all my columns in one sorted column -


i have data

    v1       v2       v3    v4 1   0.700   1.400   0.850   1.600 2   2.083   1.650   1.633   1.900 3   2.517   2.100   2.117   2.117 4   2.667   2.267   2.267   2.300 5   3.883   3.017   3.567   9.717 6   na     3.383    5.350   21.600 7   na        na    9.700   na 8   na        na    15.867  na 

if need use in r, use reproducible example below

df<- structure(list(v1 = c(0.7, 2.083, 2.517, 2.667, 3.883, na, na,  na), v2 = c(1.4, 1.65, 2.1, 2.267, 3.017, 3.383, na, na), v3 = c(0.85,  1.633, 2.117, 2.267, 3.567, 5.35, 9.7, 15.867), v4 = c(1.6, 1.9,  2.117, 2.3, 9.717, 21.6, na, na)), .names = c("v1", "v2", "v3",  "v4"), class = "data.frame", row.names = c(na, -8l)) 

i want combine of them in 1 column , sort them

my expected output below

0.7 0.85 1.4 1.6 1.633 1.65 1.9 2.083 2.117 2.1 2.267 2.3 2.517 2.667 3.017 3.383 3.567 3.883 5.35 9.7 9.717 15.867 21.6 

melting data 1 way

melt(data) , there way sort , them in 1 array?

we can use unlist , sort

dfn <- data.frame(col1= sort(unname(unlist(df)))) 

Comments