Python: Convert XML to csv list for DB import

Business in need of Python script to convert sample XML to 3 different csv outputs We already have developed a solution for DataForm1 to Field1, Field2, Field3, Field4, Field5 (1/3). We will need Python script developed to convert nested XML and XML attributes from DataForm2 (2/3) and DataForm3 (3/3) output to the following spec (see Excel file) Please provide python script and output example to match Excel file sample and requirements. Tips:::We already tried lxml, xpath, Unsure how to handle nested list issues to mold to output requirements. Output can be in-line Python that creates a csvlist=[] list (Used later on for pyodbc INSERT INTO step) Or if you prefer, write out csv file.