An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20121025/66644a27/attachment.pl>
Merge matrices with different column names
3 messages · Charles Determan Jr, Jeff Newmiller, Rui Barradas
If they have the same number of rows, you can use cbind() to create one object to write out.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
Charles Determan Jr <deter088 at umn.edu> wrote:
A general question that I have been pursuing for some time but have set aside. When finishing some analysis, I can have multiple matrices that have specific column names. Ideally, I would like to combine these separate matrices for a final output as a csv file. A generic example: Matrix 1 var1A var1B var1C x x x x x x Matrix 2 var2A var2B var2C x x x x x x I would like a final exportable matrix or dataframe or whichever format is most workable. Matrix 3 var1A var1B var1C x x x x x x var2A var2B var2C x x x x x x However, no matter which function I try reports an error that the column names are not the same. Any insights would be appreciated. Thanks as always, Charles [[alternative HTML version deleted]]
______________________________________________ R-help at r-project.org 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.
Hello, If you just want to write the matrices to a csv file instead of write.csv you can use write.table with options append=TRUE, sep="," and col.names=FALSE. If you want to merge (rbind) them, you can use code similar to pattern1 <- "(^var)[[:digit:]]+(.*$)" pattern2 <- "(^var)_n_(.*$)" colnames(Matrix1) <- sub(pattern1, "\\1_n_\\2", colnames(Matrix1)) colnames(Matrix2) <- sub(pattern1, "\\1_n_\\2", colnames(Matrix2)) Mat <- rbind(Matrix1, Matrix2) colnames(Mat) <- sub(pattern2, "\\1_\\2", colnames(Mat)) Mat Hope this helps, Rui Barradas Em 26-10-2012 04:51, Charles Determan Jr escreveu:
A general question that I have been pursuing for some time but have set aside. When finishing some analysis, I can have multiple matrices that have specific column names. Ideally, I would like to combine these separate matrices for a final output as a csv file. A generic example: Matrix 1 var1A var1B var1C x x x x x x Matrix 2 var2A var2B var2C x x x x x x I would like a final exportable matrix or dataframe or whichever format is most workable. Matrix 3 var1A var1B var1C x x x x x x var2A var2B var2C x x x x x x However, no matter which function I try reports an error that the column names are not the same. Any insights would be appreciated. Thanks as always, Charles [[alternative HTML version deleted]]
______________________________________________ R-help at r-project.org 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.