problem with arrange()

[pachevalier]

Sometimes arrange() returns a weird output. In this gist file, I've tried to order a dataset according to the x variable. I don't understand why 1.53261062618519 is assumed to be greater than missing values or other values such as 2.18733299301658.

The result of

arrange(tdf, desc(x))

isn't the same of the result as

tdf[order(tdf$x, decreasing = TRUE),]

[hadley]

Slightly simpler example:

library("dplyr")
N <- 20
df <- data.frame(id = 1:N, x = rnorm(N))
df$x[runif(N) < .1]  <- NA

tdf  <- tbl_df(df)
arrange(tdf, desc(x))

[pachevalier]

When I run :

library("dplyr")
N <- 20
set.seed(1234)
df <- data.frame(id =1:N, x = rnorm(N))
df$x[runif(N) < .1]  <- NA
tdf  <- tbl_df(df)
arrange(tdf, desc(x))

I've got a fatal error (R session aborted).

[romainfrancois]

@blaquans I can't reproduce the error, do you still get it with the current dev version ?

[pachevalier]

I've got the following error when I try to install the dev version :

Error: processing vignette 'databases.Rmd' failed with diagnostics:
RSQLite package required to connect to sqlite db
Execution halted
Erreur : Command failed (1)

[hadley]

@blaquans try install_github("hadley/devtools", build_vignettes = F)

[pachevalier]

@hadley, @romainfrancois

Ok it works !

Thanks