changing column names of a data frame by changing values - R

Question

Let I have the below data frame.

df.open<-c(1,4,5)
df.close<-c(2,8,3)

df<-data.frame(df.open, df.close)



> df
  df.open df.close
1       1        2
2       4        8
3       5        3

I wanto change column names which includes "open" with "a" and column names which includes "close" with "b":

Namely I want to obtain the below data frame:

  a b
1 1 2
2 4 8
3 5 3

I have a lot of such data frames. The pre values(here it is "df.") are changing but "open" and "close" are fix.

Thanks a lot.

Answer 1

We can create a function for reuse

f1 <- function(dat) {
     names(dat)[grep('open$', names(dat))] <- 'a'
      names(dat)[grep('close$', names(dat))] <- 'b'
     dat
}

and apply on the data

df <- f1(df)

-output

df
  a b
1 1 2
2 4 8
3 5 3

---

if these datasets are in a list

lst1 <- list(df, df)
lst1 <- lapply(lst1, f1)