This function fixes the row and column names of a data frame by removing leading and trailing spaces, replacing spaces with underscores, and modifying duplicate names.
fix_data_names(df)A data frame to be fixed
A fixed data frame with modified row and column names
my_data <- data.frame(" Col1" = c(1, 2, 3), "Col.2" = c(4, 5, 6), check.names = FALSE)
rownames(my_data) <- c(" Row1", " Row.2", "Row.3 ")
fix_column_names(fix_row_names(my_data))
#> Col1 Col_2
#> Row1 1 4
#> Row_2 2 5
#> Row_3 3 6