How do I perform a union operation on an excel file with multiple tables which are not aligned and having different number of columns using python

How do I perform a union operation on an excel file with multiple tables which are not aligned and having different number of columns using python. Kindly find the screenshot as highlighted.enter image description here