df <- data.frame(A=(1:10),B=(1:10),C=(1:10)) # my changes to show that order doesn't matter df_names <- data.frame(code=c("C","A","D","E","B"),name=c("Col C","Col A","Col D","Col E","Col B"))
names( df ) <- df_names[ match( names( df ) , df_names[ , 'code' ] ) , 'name' ] for more detail see ?match On Tue, Dec 11, 2012 at 5:55 AM, Johannes Radinger < johannesradin...@gmail.com> wrote: > Hi, > > I've got a dataframe having a code as column name. > Addtionally I have another dataframe with a two columns (and lots of > rows), the first > containing the code and the second some Text (real name). > > Now I'd like to use the information (pairs of code and name) of the > second dataframe to rename all the columnnames in the first dataframe. > How is it possible to achieve that? > > Here a small example of the two dataframes: > > df <- data.frame(A=(1:10),B=(1:10),C=(1:10)) > df_names <- data.frame(code=c("A","B","C","D","E"),name=c("Col A","Col > B","Col C","Col D","Col E")) > > /j > > ______________________________________________ > 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]] ______________________________________________ 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.