[R] tables with row sorted numerically although factors

[David Winsemius]

On Oct 8, 2013, at 10:29 AM, Renger van Nieuwkoop wrote:

> Hi
> I am using the package tables and want to have the rows in the numerical order and not in the alphabetical order:
> 
> library(tables)
> Nodes     <- c(1,10,20,2)
> Values    <- c(1,2,3,4)
> Data      <- data.frame(cbind(Nodes,Values))
> data$Nodes<- as.factor(as.character(data$Nodes)) # necessary to get factors for tabular
> 
> tabular(Nodes  ~ Values*mean, data=data)
> 
>       Values
> Nodes mean
> 1     1
> 10    2
> 2     4
> 20    3
> 
> And what I want is this:

Ypu are failing to pay attention to capitalization of "Data" and not using the levels argument to factor() as you should be:

Data$Nodes<- factor(Data$Nodes, levels=unique(Nodes[order(Nodes)]))
 # using the numeric order rather than the lexigraphic order
tabular(Nodes  ~ Values*mean, data=Data)


> 
>       Values
> Nodes mean
> 1     1
> 2     4
> 10    2
> 20    3
> 
> Any idea how to do this? (the solution is not to write 01, 02, 10, 20, because I use Nodes in lot of places elsewhere, where I can't use 01, etc.)
> 
> Cheers
> 
> Renger
> 

David Winsemius
Alameda, CA, USA