Re: [R] Column order in stacking/unstacking

From: Matthew Carroll <>
Date: Sat, 12 Mar 2011 11:33:49 +0000

Dear Dennis and Peter,
Thank you for the suggestions - they work very well with my example data.

I *think* I've got it up and running using my real data (with 2000 columns) too, with:

sprintf("%s%04d", "X", c(1:2000))

then the stacking/unstacking operations.

Thanks again for the help

Best wishes,

-----Original Message-----
From: Peter Ehlers [] Sent: 12 March 2011 11:09 AM
To: Dennis Murphy
Cc: Matthew Carroll; Subject: Re: [R] Column order in stacking/unstacking

On 2011-03-12 02:01, Dennis Murphy wrote:
> Hi:
> It would help if you named your variables such that alphanumeric ordering
> doesn't disturb your variable ordering. Having been burned by this a few
> times, I've learned the basics of sprintf() :) Here's your example
> revisited, along with an alternative stacking/unstacking display with
> package reshape.
> library(reshape)
> vnames<- paste('X', sprintf('%02d', c(1, 2, 10)), sep = '')
>> vnames
> [1] "X01" "X02" "X10"


You can do this a bit more simply with sprintf:

  vnames <- sprintf("%s%02d", "X", c(1, 2, 10))

Peter Ehlers mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Sat 12 Mar 2011 - 11:39:33 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Sat 12 Mar 2011 - 11:40:20 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.

list of date sections of archive