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
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
# Create a sample data frame
my_df <- data.frame(x = 1:5, y = 6:10)
# Rename the 'y' column to 'new_name'
names(my_df)[names(my_df) == 'y'] <- 'new_name'
# Alternatively, you can use colnames() function
colnames(my_df)[colnames(my_df) == 'y'] <- 'new_name'
# Print the data frame to verify the column rename
print(my_df)