title: How to read pivot table from excel document in python pandas?
body: <p>I have one excel document which contains sport column, in which sports name and sports persons names are available. If I clicked on sports name sports persons names are disappears i.e. sports persons names are children's of the sports name. </p>
  
  <p>Please look at the data below:
  <a href="https://i.stack.imgur.com/OA5KU.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OA5KU.jpg" alt="enter image description here"></a>  </p>
  
  <p>If I clicked on cricket then ramesh, suresh,mahesh names are disappears i.e. cricket is the parent of ramesh, suresh and mahesh like same football is the parent of pankaj, riyansh, suraj. </p>
  
  <p>I want to read this excel document and convert in the python pandas Dataframe. I tried to read it with <a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.pivot_table.html" rel="nofollow noreferrer">pandas pivot_table</a> but I'm not getting any success. </p>
  
  <p>I tried to read this excel sheet and converted into a dataframe.</p>
  
  <pre><code>df = pd.read_excel("sports.xlsx",skiprows=7,header=0)
  d = pd.pivot_table(df,index=["sports"])
  print d
  </code></pre>
  
  <p>But I'm getting all the sports values in single column I want to split it by sports name and it's corresponding sports persons name.</p>
  
  <p><strong>Expected Output:</strong></p>
  
  <pre><code>sports_name player_name   age address
  cricket     ramesh        20  aaa
  cricket     suresh        21  bbb
  cricket     mahesh        22  ccc
  football    pankaj        24  eee
  football    riyansh       25  fff
  football    suraj         26  ggg
  basketball  rajesh        28  iii
  basketball  abhijeet      29  jjj
  </code></pre>