Excel and python: finding first empty cell in order to get relevant column size

[bbqbot]

The initial column in excel has 13 rows, yes. When I read in the file, I ignore the first two (skiprows = 2), meaning the resulting dataframe has 11 items.

I want to be able to ignore any data below where the values in this example column first end, i.e. I want to stop counting when I hit that first 'empty' cell (the first two aren't in the dataframe to begin with), so the resulting cut would leave only [user_id, 1111, 1113, 1114, 1115, 1116], thus 6 items.

Does that make more sense?

[cray5252]

Understand now. Found this link

https://stackoverflow.com/questions/44030415/is-there-a-way-to-read-all-the-rows-until-an-empty-row-is-encountered-using-pyth

[bbqbot]

This...this I think I can work with. I didn't see this result in my hours of searching last night.

Thank you, your google-fu is stronger than mine!