R

how to rename columns in r using index

names(titanic_df)[1] <- 'P_Class'

r rename columns

library(plyr)
rename(d, c("beta"="two", "gamma"="three"))
#>   alpha two three
#> 1     1   4     7
#> 2     2   5     8
#> 3     3   6     9

rename column in r

my_data %>% 
  rename(
    sepal_length = Sepal.Length,
    sepal_width = Sepal.Width
    )

rename columns in table r

rename(table_name, new_column = old_column)

#For multiple column change:
rename(table_name, new_column = old_column, new_col2 = old_col2)

rename columns based on a variable in r

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 

rename column in r

# 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'

r - change column name

colnames(df)[colnames(df) == "name"] <- "new_name"

r: rename a column

colnames(df)[which(names(df) == "columnName")] <- "newColumnName"

change columnnames in r

# 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)

r rename column based on variable

rename(df, !!metric:=value)

r rename column based on variable

df %>% rename(!!variable := name_of_col_from_df)