This function takes a data frame as an argument and replaces all spaces in the column names with underscores.
fix_col_spaces(df)
A data frame
A modified data frame with spaces in column names replaced by underscores.
my_data <- data.frame("Column Name 1" = c(1, 2, 3), "Column Name 2" = c(4, 5, 6))
fix_col_spaces(my_data)
#> Column.Name.1 Column.Name.2
#> 1 1 4
#> 2 2 5
#> 3 3 6
# Returns a data frame with column names where spaces are replaced by underscores.