How to Rename Multiple Columns in R

Renaming columns means changing the existing column names to more meaningful or consistent ones. We often do this to make our data easier to understand, follow naming rules or match analysis requirements. In R, you can rename multiple columns using base R functions or packages like dplyr.

• Column names can be modified using colnames() or names().
• The dplyr::rename() function provides a clean and readable approach.
• Multiple columns can be renamed at once efficiently.

Using names()

We use names() to assign a new vector of names to all columns at once.

• names(): Retrieves or sets the names of columns in a data frame.
• c(): Combines values into a vector.
• data.frame(): Creates a table like structure.
• cat(): Prints text without quotes or structure formatting.

Output:

Using colnames()

We use colnames() to change all column names similarly to names().

• colnames(): Gets or sets the column names of a data frame.
• c(): Combines values into a vector.
• data.frame(): Creates a table like structure.
• cat(): Prints text without quotes or structure formatting.

Output:

Using dplyr

We use rename() from the dplyr package to rename specific columns using the format new = old.

• library(): Loads external packages like dplyr.
• rename(): Used to rename specific columns in a data frame.
• %>%: Passes the data frame to the next operation.
• cat(): Prints text without quotes or structure formatting.

Output:

Using Column Index in dplyr

We use column positions with !! and rename() to rename specific columns by index.

• library(): Loads external packages like dplyr.
• rename(): Used to rename columns using index.
• !!: Unquotes column index for tidy evaluation.
• %>%: Chains data operations in sequence.
• cat(): Prints text without quotes or structure formatting.

Output:

Using setnames()

We use setnames() from the data.table package to rename multiple columns in place.

• library(): Loads external packages like data.table.
• setnames(): Replaces old column names with new ones.
• data.table: Creates high performance data table objects.
• cat: Prints text without quotes or structure formatting.

Output:

The column names are changed from oldName1, oldName2, oldName3 to newName1, newName2, newName3, while the data remains unchanged. The output confirms the renaming in a data.table format.