xxxxxxxxxx
# Example data frame
data <- data.frame(A = 1:5, B = 6:10, C = 11:15)
# Retrieve current column names
old_names <- colnames(data)
# Define new column names
new_names <- c("NewA", "NewB", "NewC")
# Rename columns
colnames(data) <- new_names
# Verify the updated column names
print(colnames(data))
xxxxxxxxxx
library(plyr)
rename(d, c("beta"="two", "gamma"="three"))
#> alpha two three
#> 1 1 4 7
#> 2 2 5 8
#> 3 3 6 9
xxxxxxxxxx
df <- rename(df, new_name = old_name) #For renaming dataframe column
tbl <- rename(tbl, new_name = old_name) #For renaming tibble column
tbl <- tbl %>% rename(new_name = old_name) #For renaming tibble column using dplyrpipe
#operator
xxxxxxxxxx
my_data %>%
rename(
sepal_length = Sepal.Length,
sepal_width = Sepal.Width
)
xxxxxxxxxx
# df = dataframe
# old.var.name = The name you don't like anymore
# new.var.name = The name you want to get
names(df)[names(df) == 'old.var.name'] <- 'new.var.name'
xxxxxxxxxx
rename(table_name, new_column = old_column)
#For multiple column change:
rename(table_name, new_column = old_column, new_col2 = old_col2)
xxxxxxxxxx
colnames(df)[which(names(df) == "columnName")] <- "newColumnName"
xxxxxxxxxx
#Example 1 - Rename second column to c2
colnames(my_dataframe)[2] ="c2"
#Example 2 - Rename fifth column to c5
names(my_dataframe)[5] ="c5"
#Example 3 - Rename the column name - id to c1
colnames(my_dataframe)[colnames(my_dataframe) == "id"] ="c1"
#Example 4 - Load the library
library("dplyr")
#Using rename()
my_dataframe <- my_dataframe %>%
rename("id" = "c1")
# Example 5 - Rename multiple columns using rename()
my_dataframe <- my_dataframe %>%
rename("id" = "c1",
"pages" = "c2",
"name" = "c3")
# Example 6 - Rename column by index
my_dataframe <- my_dataframe %>%
rename(col1 = 1, col2 = 2)
# Example 7 - Using select()
my_dataframe <- my_dataframe %>%
select(col1 = 1, everything() )
# Example 8 - Using rename_with()
my_dataframe <- my_dataframe %>%
rename_with(.cols = 1, ~"col1")
# Example 9 - Load library data.table
library(data.table)
# Rename multiple columns for old to new
setnames(my_dataframe, old = c('c1','c2','c3'),
new = c('id','pages','name'))
xxxxxxxxxx
# declaring the columns of data frame
df = data.frame(
col1 = c('A', 'B', 'C', NA,'M'),
col2 = c(12.5, 9, 16.5, 20, 14.5),
col3 = c(NA, 3, 2, NA, 0))
# printing original data frame
print("Original data frame : ")
print(df)
# print("Renaming columns names ")
# renaming all the column names of data frame
df <- setNames(df, c("changed_Col1","changed_Col2","changed_Col3"))
print("Renamed data frame : ")
print(df)