Flattening Nested Excel Using Python

Question

I have an excel with nested rows that look like below:

...

I want to flatten it and have the output as below:

Does anyone know a good way of doing this in Python/Pandas?

Thanks