Change name of few columns of dataframe using another dataframe. To keep it dynamic, need to match using the name of columns, instead of position

Asked Mar 01 '19 at 20:38

Active Mar 01 '19 at 21:26

Viewed 38 times

I looked up a lot of similar questions on Stackoverflow but I could not locate the one I am asking.

Consider a dataset:

A B C D E F G a b c d e f g

And mapping dataset to be: current desired

B H C I D J E K F L

namechangevector <- c('B', 'C', 'D', 'E', 'F')

I am using this command:

colnames(data[namechangevector]) <- as.character(mappingdata$desired[match(names(data[namechangevectors]), mappingdata$current)])

But, this doesn't work. However, this works:

colnames(data)[2:6] <- as.character(mappingdata$desired[match(names(data[namechangevectors]), mappingdata$current)])

But since, the vector can have more values and dataset can keep changing. I want to match using the vector and not the position. Please help!

edited Mar 01 '19 at 21:26

asked Mar 01 '19 at 20:38

Bruce Wayne

1

What about: `colnames(data)[which(colnames(data) %in% namechangevector)] – Andrew Mar 01 '19 at 21:00
Did not work. The command makes no change to the data – Bruce Wayne Mar 01 '19 at 21:04
Ok, can you provide a reproducible example with your expected results? – Andrew Mar 01 '19 at 21:08
`names(data)[names(data) %in% namechangevector] – infominer Mar 01 '19 at 21:09
I did try colnames(data)[namechangevector], but this doesn't work either. Neither does this: `colnames(data)[which(colnames(data) %in% namechangevector)] – Bruce Wayne Mar 01 '19 at 21:11
I am working on dummy reproducible data – Bruce Wayne Mar 01 '19 at 21:12
Refer to this for an example. Just a few columns instead of all/. https://stackoverflow.com/questions/53714977/change-all-r-columns-names-using-a-reference-file – Bruce Wayne Mar 01 '19 at 21:22
https://stackoverflow.com/questions/53714977/change-all-r-columns-names-using-a-reference-file – Bruce Wayne Mar 20 '19 at 22:20

0 Answers0