Changing Column Names in a List of Data Frames in R

by

With lapply you can do it as follows.

Create sample data:

df1 <- data.frame(A = 1, B = 2, C = 3)
df2 <- data.frame(X = 1, Y = 2, Z = 3)
dfList <- list(df1,df2)
colnames <- c("USAF","WBAN","YR--MODAHRMN")

Then, lapply over the list using setNames and supply the vector of new column names as second argument to setNames:

lapply(dfList, setNames, colnames)
#[[1]]
#  USAF WBAN YR--MODAHRMN
#1    1    2            3
#
#[[2]]
#  USAF WBAN YR--MODAHRMN
#1    1    2            3

Edit

If you want to assign the data.frames back to the global environment, you can modify the code like this:

dfList <- list(df1 = df1, df2 = df2)
list2env(lapply(dfList, setNames, colnames), .GlobalEnv)

More Related Contents:

  1. Deleting specific rows with a pattern[start and end indicators] from a dataframe [closed]
  2. Select the row with the maximum value in each group
  3. Create a sequential number (counter) for rows within each group of a dataframe [duplicate]
  4. Extracting specific columns from a data frame
  5. Find indices of duplicated rows [duplicate]
  6. How to drop columns by name in a data frame
  7. Reshape multiple values at once
  8. Remove columns from dataframe where ALL values are NA
  9. How to move cells with a value row-wise to the left in a dataframe [duplicate]
  10. How to add a row to a data frame in R?
  11. Subtract a column in a dataframe from many columns in R
  12. Converting a data frame to xts
  13. Interpolate NA values in a data frame with na.approx
  14. How to subset data in R without losing NA rows?
  15. How to delete columns that contain ONLY NAs?
  16. Using grep to help subset a data frame
  17. Merge rows in a dataframe where the rows are disjoint and contain NAs
  18. How to sort a data frame by date
  19. Replace logical values (TRUE / FALSE) with numeric (1 / 0)
  20. Randomly insert NAs into dataframe proportionaly
  21. R: Split unbalanced list in data.frame column
  22. Transposing a dataframe maintaining the first column as heading
  23. Should I use a data.frame or a matrix?
  24. Split dataframe using two columns of data and apply common transformation on list of resulting dataframes
  25. Replace values in data frame based on other data frame in R
  26. Add an image to a table-like output in R
  27. Numbers as column names of data frames
  28. Divide each value by the sum of values by group
  29. Convert all data frame character columns to factors
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment