Beginning with pandas v1.3.0 this task can be solved in a single lie of code. Have a look here: https://florian-kromer.medium.com/parsing-xml-into-pandas-dataframes-661882abd8e5