Dear R-list, Is there any way I can extract part or whole column name from two variables and combine them? Not values, but column names. For example, I have data set with 70 variables. The column names are "Alfalfa", "Corn","Soybean",..."Sunflower". After I combine the two variable (say Alfalfa and Corn), I want to rename it as "AlfCor" or "AlfalfaCorn" automatically not manually. In excel, I found the function combining two texts in individual columns using (=A1&B1, if you want to combine texts in the two cells.). Thank you very much in advance! Steve Hong 437 RUSSELL LAB. 1630 LINDEN DR. ENTOMOLOGY DEPT. MADISON, WI, 53706 Tel: 608-263-0964 Fax: 608-262-3322
On May 1, 2009, at 2:55 PM, SEUNG CHEON HONG wrote:> Dear R-list, > > Is there any way I can extract part or whole column name from two > variables and combine them? Not values, but column names. > For example, > I have data set with 70 variables. The column names are "Alfalfa", > "Corn","Soybean",..."Sunflower". After I combine the two variable (say > Alfalfa and Corn), I want to rename it as "AlfCor" or "AlfalfaCorn" > automatically not manually. > > In excel, I found the function combining two texts in individual > columns using (=A1&B1, if you want to combine texts in the two > cells.).?paste ?colnames David Winsemius, MD Heritage Laboratories West Hartford, CT
Dear Seung, Try this:> Names <- letters[1:5] > Names[1] "a" "b" "c" "d" "e"> apply(t(combn(Names,2)), 1, paste, collapse="")[1] "ab" "ac" "ad" "ae" "bc" "bd" "be" "cd" "ce" "de" HTH, Jorge On Fri, May 1, 2009 at 2:55 PM, SEUNG CHEON HONG <sch@entomology.wisc.edu>wrote:> Dear R-list, > > Is there any way I can extract part or whole column name from two > variables and combine them? Not values, but column names. > For example, > I have data set with 70 variables. The column names are "Alfalfa", > "Corn","Soybean",..."Sunflower". After I combine the two variable (say > Alfalfa and Corn), I want to rename it as "AlfCor" or "AlfalfaCorn" > automatically not manually. > > In excel, I found the function combining two texts in individual > columns using (=A1&B1, if you want to combine texts in the two cells.). > > Thank you very much in advance! > > Steve Hong > > > > > > > > 437 RUSSELL LAB. > 1630 LINDEN DR. > ENTOMOLOGY DEPT. > MADISON, WI, 53706 > Tel: 608-263-0964 > Fax: 608-262-3322 > > ______________________________________________ > R-help@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. >[[alternative HTML version deleted]]