Cannot rename Columns in df

[deanhystad]

The Excel file I'm reading has usually 2 first rows blank sometimes more. I'd like to completely remove blank rows.

Why is there no consistency in the files you are processing? Maybe you should look into fixing that.

[perfringo]

skiprows accepts callable as argument so maybe use lambda to determine empty rows?

skiprows

list-like, int, or callable, optional

Line numbers to skip (0-indexed) or number of lines to skip (int) at the start of the file. If callable, the callable function will be evaluated against the row indices, returning True if the row should be skipped and False otherwise. An example of a valid callable argument would be lambda x: x in [0, 2].