title: pandas pivot table col name and values column name to be removed
body: <p>I have an input df</p>
  <pre><code>{'Name': {0: 'AA',1: 'BB',2: 'CC',3: 'DD',4: 'EE',5: 'AA',6: 'EE',7: 'FF'},
   'WK': {0: 1, 1: 2, 2: 3, 3: 4, 4: 2, 5: 3, 6: 4, 7: 5},
   'LG': {0: 'qwe',1: 'wer',2: 'sff',3: 'err',4: 'wer',5: 'rtt',6: 'eww',7'tyy'}}
  </code></pre>
  <p><a href="https://i.stack.imgur.com/SjCqQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SjCqQ.png" alt="enter image description here" /></a></p>
  <p>i did the below</p>
  <pre><code>df1=pd.pivot_table(dfp,values=['LG'],index='Name',columns='WK',aggfunc='count').fillna(0)
  </code></pre>
  <p><a href="https://i.stack.imgur.com/3iIdL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3iIdL.png" alt="enter image description here" /></a></p>
  <p>i want the output as below .. like WK and LG should not appear and WK values as columns</p>
  <p><a href="https://i.stack.imgur.com/F7Pqz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F7Pqz.png" alt="enter image description here" /></a></p>
  <p>Columns should be like Name 1 2 3 4 5</p>