title: read_xml does not return the whole data in Python
body: <p>I have this linked XML that has obviously two multiple records sets with top-line items: &quot;Tours&quot; and &quot;Candidats&quot;.</p>
  <p>You can find the XML at <a href="https://www.resultats-elections.interieur.gouv.fr/telechargements/PR2022/resultatsT1/011/077/077001.xml" rel="nofollow noreferrer">https://www.resultats-elections.interieur.gouv.fr/telechargements/PR2022/resultatsT1/011/077/077001.xml</a></p>
  <p>I want to turn it into a Pandas dataframe that I can read more efficiently and conveniently. I  passed the URL into <code>read_xml</code> like so:</p>
  <pre><code>pandas.read_xml(&quot;https://www.resultats-elections.interieur.gouv.fr/telechargements/PR2022/resultatsT1/011/077/077001.xml&quot;)
  </code></pre>
  <p>Which returns this very incomplete dataframe. The whole data in the XML is not returned in this dataframe. Question: what can I do best to get the whole data into a Pandas dataframe I can work with ?</p>
  <pre><code>         Type   Annee  CodReg  CodReg3Car         LibReg  CodDpt  \
  0  Présidentielle  2022.0     NaN         NaN           None     NaN   
  1            None     NaN    11.0        11.0  Île-de-France    77.0   
  
     CodMinDpt  CodDpt3Car          LibDpt  Commune  
  0        NaN         NaN            None      NaN  
  1       77.0        77.0  Seine-et-Marne      NaN
  </code></pre>
  <p>FYI: I can read this linked XML with Excel and it returns the full dataframe that should contain 13 rows and 33 columns. Excel might simply flattens everything with lots of repetitions, but that would be fine if I could manage to do this with Python.</p>