title: XML to Pandas dataFrame returns None
body: <p>I'm beginning with data science and pandas, I'm trying to populate a pandas dataframe with XML infos here is my code :</p>
  
  <pre><code>import xml.etree.cElementTree as et
  import pandas as pd
  import sys
  
  def getvalueofnode(node):
      """ return node text or None """
      return node.text if node is not None else None
  
  
  def main():
      parsed_xml = et.parse("test2.xml")
      dfcols = ['Country','Club', 'Founded']
      df_xml = pd.DataFrame(columns=dfcols)
  
      for node in parsed_xml.getroot():
          Country = node.attrib.get('country')
          Club = node.find('Name')
          Founded = node.find('Founded')
  
          df_xml = df_xml.append(
              pd.Series([Country, getvalueofnode(Club),getvalueofnode(Founded)], index=dfcols),
              ignore_index=True)
  
      print(df_xml)
  
  main()
  </code></pre>
  
  <p>Here is my output : </p>
  
  <blockquote>
    <p>Country  Club Founded</p>
    
    <p>0    None  None    None</p>
  </blockquote>
  
  <p>Here is my XML file :</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;SoccerFeed timestamp="20181123T153249+0000"&gt;
    &lt;SoccerDocument Type="SQUADS Latest" competition_code="FR_L1" competition_id="24" competition_name="French Ligue 1" season_id="2016" season_name="Season 2016/2017"&gt;
      &lt;Team country="France" country_id="8" country_iso="FR" region_id="17" region_name="Europe" &gt;
        &lt;Founded&gt;1919&lt;/Founded&gt;
        &lt;Name&gt;Angers&lt;/Name&gt;
     &lt;...&gt;
     &lt;Team country="France" country_id="8" country_iso="FR" region_id="17" region_name="Europe" &gt;
        &lt;Founded&gt;1905&lt;/Founded&gt;
        &lt;Name&gt;Bastia&lt;/Name&gt;
  </code></pre>
  
  <p>Why can't I get a Panda Data Frame with the informations I need ? Did I miss something in my code ? Thank you for your help</p>