standardise_column_headers

standardise_column_headers(df_col_names, before=None, after=None)

Make dataframe headers lowercase and replace spaces by underscores.

The function allows to specify custom replacements.

For example: Group - Primary can be changed to group_primary by calling

df.columns = utils.standardise_column_headers(df.columns, before=’_-_’, after=’_’)

Parameters:

• df_col_names – dataframe column names <class ‘pandas.core.indexes.base.Index’>
• before – string
• after – string

Returns:

dataframe column names <class ‘pandas.core.indexes.base.Index’>