Answers for "how to change the name of a given colums in dataframe"

change column name df

>>> df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})
>>> df.rename(columns={"A": "a", "B": "c"})
   a  c
0  1  4
1  2  5
2  3  6

pandas description of dataframe renaming column values

def modified_col (col):
    col = col.strip()#removes white space
    col = col.replace('Operating System','os')
    col = col.replace(' ','_')
    col = col.replace(')','')#removes (
    col = col.replace('(','')
    col = col.lower()
    return col

new_columns = []
for new_col in df.columns:
    clean_col = modified_col(new_col)
    new_columns.append(clean_col)

df.columns = new_columns