Irregular Excel File Parsing

Use this skill when you encounter Excel files where standard pandas.read_excel() fails due to:

• Headers not in row 0 (6-9+ header rows common)
• Merged cells in header area
• Unknown or inconsistent header row positions
• Multiple title/metadata rows before actual data

Step-by-Step Instructions

Step 1: Read Excel Without Headers

First, read the entire sheet with header=None to get raw data:

import pandas as pd