import pandas as pd workbook_name = "example.xlsx" df = pd.read_excel(workbook_name) # Rename all worksheets' columns for worksheet_name in df.sheet_names: df.rename(columns=lambda x: x + 'renamed', inplace=True, sheet_name=worksheet_name) # Delete all worksheets second row for worksheet