make.names function

When we work with excel in R, very often we need to tidy excel headers.

Change column names so that it is easy to operate in the R environment.

In R, if the column names contain an empty space or are made of numbers, we need to use backticks, ``, around the column names, which can be tedious.

The make.names function removes the empty space in the column names and replace it with a full stop.

colnames(transport_data) <- make.names(colnames(transport_data))