I am working on a Python project where I need to convert deeply nested HTML tables into a single-level, flat table format. My main challenge is to retain the visual structure of the original nested tables in the flat version. This requires dynamically calculating the appropriate colspan and rowspan for each cell in the resulting single-level table, using BeautifulSoup.

The complexity arises from handling multiple levels of nested tables, each potentially affecting the layout of the flat table. My current script attempts to recursively navigate and flatten these nested structures, adjusting colspan and rowspan dynamically based on the nesting level and content of the cells.

The code for my project is hosted on GitHub here: https://github.com/RizniMohamed/single_lvl_table.git

questions:

1. How can I effectively calculate and apply colspan and rowspan to retain the original layout when transforming nested tables into a single-level table?
2. Are there more efficient methods or libraries that can assist in parsing and transforming complex nested HTML tables into a visually equivalent flat table structure?

Any insights or suggestions to improve the efficiency of this process or to ensure the visual structure is retained accurately would be greatly appreciated.