This function removes "X." or "X" from the beginning of column names and replaces any "." with "_". It also removes leading/trailing symbols and spaces, and ensures that there is only one underscore between two words. If there are duplicate column names, it appends a number to each duplicate column name to make it unique.
Usage
fix_column_names(data)
Value
The modified data frame with fixed column names.
Arguments
data
A data frame with improperly formatted column names.