rename column values using another data

Question

I want to rename column data.

for example

I have under dataset.

change_name <- data.frame(org_name = c("a", "b", "c"), new_name = c("A", "B", "C"))
dt <- data.frame(name = c("a", "b", "c"), data = c(1, 2, 3))

dt dataset column name change using change_name dataset
and want to get like the under dataset.

dt <- data.frame(name = c("A", "B", "C"), data = c(1, 2, 3))

You could make change_name into a lookup table dt$name <- setNames(change_name$new_name, change_name$org_name)[dt$name] or if you literally just need to capitalize, use toupper. — alistaire
– alistaire, Commented Nov 18, 2016 at 3:37

akrun · Accepted Answer · 2016-11-18 02:35:59Z

1

We can use match

dt$name <- change_name$new_name[match(dt$name, change_name$org_name)]

answered Nov 18, 2016 at 2:35

akrun

891k38 gold badges590 silver badges700 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

I want to use under the case, too. change_name <- data.frame(org_name = c("a", "b", "c"), new_name = c("honda", "BMW", "toyota"))

@ogawa My solution is based on the question you asked i.e. dt dataset column name change using change_name dataset

ogw · Accepted Answer · 2017-02-07 05:31:45Z

0

I resolve the problem use under the code, too.

dt$name <- 
  plyr::mapvalues(dt$name, change_name$org_name, change_name$new_name

answered Feb 7, 2017 at 5:31

ogw

3831 gold badge3 silver badges13 bronze badges