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 <
johannesradinger@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]]


