Returns pandas dataframe with all col names renamed to be valid ArcGIS table names.

ArcPyValidateDFColNames.py

import pandas as pd
import arcpy
def validate_df_names(dataframe,output_feature_class_workspace):
    """Returns pandas dataframe with all col names renamed to be valid arcgis table names."""
    new_name_list=[]
    old_names=dataframe.columns.names
    for name in old_names:
        new_name=arcpy.ValidateFieldName(name,output_feature_class_workspace)
        new_name_list.append(new_name)
    rename_dict={i:j for i,j in zip(old_names,new_name_list)}
    dataframe.rename(index = str,columns=rename_dict)
    return dataframe