Pandas cheat sheet

Data Frame - cleaning column names

df.columns = df.columns.str.replace(r'\s+', '_') #This replaces ' ' with '_' in col names  

df.columns is of type index dence can be converted to string and cleaned up in a chained fashion

df.columns = df.columns.str.replace('.', '_').str.replace('(','').replace(')','')

---

Data Frame - Efficiently iterating over all rows

for row in df.itertuples():
    print(f"{row.Col_1} : {row.Col_2}")

---