Re: [R] inserting columns in the middle of a dataframe

From: Joe W. Byers <Joe-Byers_at_utulsa.edu>
Date: Fri 29 Sep 2006 - 03:11:45 GMT

Berton Gunter wrote:
> Please folks -- use indexing.
>
> myframe<-myframe[,c(1,5,2,3,4)]
>
> Which begs the question: why bother rearranging the columns anyway, since
> one can get them used, printed, etc. in any order you wish anytime you want
> just by specifying the indices in the order you want them. I suspect the
> question was motivated by too much Sas- or Excel -ism.
Many of the time series classes expect a date in the first column of the matrix or data.frame when creating the date-time object. Retrieving data in a SQL query from a dB returns a character representation of the date that requires conversion to a date. Performing this conversion is easy but inserting this converted date column is not straight forward.

>
> -- Bert Gunter
> Genentech Non-Clinical Statistics
> South San Francisco, CA
>
> "The business of the statistician is to catalyze the scientific learning
> process." - George E. P. Box
>
>
>

>> -----Original Message-----
>> From: r-help-bounces@stat.math.ethz.ch 
>> [mailto:r-help-bounces@stat.math.ethz.ch] On Behalf Of Timothy Bates
>> Sent: Wednesday, September 13, 2006 3:05 PM
>> To: Jon Minton; r-help@stat.math.ethz.ch
>> Subject: Re: [R] inserting columns in the middle of a dataframe
>>
>>
>>> Is there a built-in and simple way to insert new columns in 
>> a dataframe?
>>
>> You do this by collecting the columns in the new order you desire, and
>> making a new frame.
>>
>> oldframe           <- data.frame(matrix(0:14,ncol=3))
>> newcol              <- data.frame(20:24)
>> names(newcol) <- "newcol"
>> newframe         <- data.frame(c(oldframe[1],newcol, oldframe[2:3]))
>>
>> ______________________________________________
>> R-help@stat.math.ethz.ch mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide 
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>

>
> ______________________________________________
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Fri Sep 29 13:12:55 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Fri 29 Sep 2006 - 06:30:07 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.