title: Column name shown twice in same column pandas
body: <p>I have a pandas <code>dataframe</code> on which I did a <code>groupby</code> and <code>value_counts</code>:</p>
  
  <pre><code>df4.groupby(['City'])['User Type'].value_counts()
  </code></pre>
  
  <p>This gives me following output:</p>
  
  <pre><code>City  User Type 
  C     Subscriber    238889
        Customer       61110
        Dependent          1
  N     Subscriber    269149
        Customer       30159
  W     Subscriber    220786
        Customer       79214
  </code></pre>
  
  <p>Now I did <code>df6=df5.unstack(level=1).reset_index()</code></p>
  
  <p>this returned a df like shown below:</p>
  
  <p><a href="https://i.stack.imgur.com/Lvl7g.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Lvl7g.png" alt="enter image description here"></a></p>
  
  <p>Now i did <code>df6.set_index('City',inplace=True)</code></p>
  
  <p>This produces output:</p>
  
  <p><a href="https://i.stack.imgur.com/03XGC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/03XGC.png" alt="enter image description here"></a></p>
  
  <p>I am unable to understand why city is shown under "User Type" and is there a way to remove "User Type" index name</p>
  
  <p>After doing:</p>
  
  <pre><code>df6=df5.unstack(level=1).reset_index().rename_axis(None, axis=1)
  </code></pre>
  
  <p>and then doing : <code>df6.set_index('City',inplace=True)</code></p>
  
  <p>it still shows city on different level:</p>
  
  <p><a href="https://i.stack.imgur.com/4Oiug.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4Oiug.png" alt="enter image description here"></a></p>