Geek asks and answers

Strange behavior by arranging a data frame

I have the following data frame that I want to order in the fifth column ("Distance"). When i try

df.order <- df[order(df[, 5]), ]

I always get the following error message.

Error in order(df[, 5]) : unimplemented type 'list' in 'orderVector1'`

I do not know why R considers my data frame as a list. Startup is.data.frame(df)returns TRUE. I have to admit that is.list(df)also returns TRUE. Is it possible to make my data frame be only a data frame, not a list? Thank you for your help.

structure(list(ID = list(1, 2, 3, 4, 5, 6, 7, 8, 9, 10), 
               Latitude = list(50.7368, 50.7368, 50.7368, 50.7369, 50.7369, 50.737, 50.737, 50.7371, 50.7371, 50.7371), 
               Longitude = list(6.0873, 6.0873, 6.0873, 6.0872, 6.0872, 6.0872, 6.0872, 6.0872, 6.0872, 6.0872), 
               Elevation = list(269.26, 268.99, 268.73, 268.69, 268.14, 267.87, 267.61, 267.31, 267.21, 267.02), 
               Distance = list(119.4396, 119.4396, 119.4396, 121.199, 121.199, 117.5658, 117.5658, 114.9003, 114.9003, 114.9003), 
               RxPower = list(-52.6695443922406, -52.269130891243, -52.9735258244422, -52.2116571930007, -51.7784534281727, -52.7703448813654, -51.6558862949081, -52.2892907635308, -51.8322993596551, -52.4971436682333)), 
          .Names = c("ID", "Latitude", "Longitude", "Elevation", "Distance", "RxPower"),
          row.names = c(NA, 10L), class = "data.frame")
+5
source share
3 answers

Your data frame contains lists, not vectors. You can convert this data frame to the “classic” format with as.data.frameand unlist:

df2 <- as.data.frame(lapply(df, unlist))

:

df2[order(df2[, 5]), ]
+3

, :

df <- structure(list(ID = c(1, 2, 3, 4), 
          Latitude = c(50.7368, 50.7368, 50.7368, 50.7369), 
          Longitude = c(6.0873, 6.0873, 6.0873, 6.0872), 
          Elevation = c(269.26, 268.99, 268.73, 268.69), 
          Distance = c(119.4396, 119.4396, 119.4396, 121.199), 
          RxPower = c(-52.6695443922406, -52.269130891243, -52.9735258244422, 
                         -52.2116571930007)), 
          .Names = c("ID", "Latitude", "Longitude", "Elevation", "Distance", "RxPower"), 
          row.names = c(NA, 4L), class = "data.frame")

, list . c(.), list(.). sapply(df, class) , list.

,

> sapply(df, classs)
#       ID  Latitude Longitude Elevation  Distance   RxPower 
# "numeric" "numeric" "numeric" "numeric" "numeric" "numeric"

order :

> df[order(df[,4]), ]  
#   ID Latitude Longitude Elevation Distance   RxPower
# 4  4  50.7369    6.0872    268.69 121.1990 -52.21166
# 3  3  50.7368    6.0873    268.73 119.4396 -52.97353
# 2  2  50.7368    6.0873    268.99 119.4396 -52.26913
# 1  1  50.7368    6.0873    269.26 119.4396 -52.66954
+3

data.frame :

mat <- sapply(df,unlist)

.

mat[order(mat[,5]),]

, , , , , data.frames. data.frame as.data.frame(mat).

Btw, data.frame - , is.list TRUE data.frame.

+1

More articles:


All Articles