title: Turn specific indexes into their own rows
body: <blockquote>
  <h1><strong>Trying to convert the indices of one column, into their own columns.</strong></h1>
  </blockquote>
  <pre><code>From:
  
  [country, series, year, value]
  
  [USA, A, 1994, 700000]
  [USA, B, 1994, 701231]
  [UK, A, 1994, 600000]
  [UK, B, 1994, 601231]
  [China, A, 1994, 6512312]
  [China, B, 1994, 6432112]
  </code></pre>
  <pre><code>To:
  
  [country, A, B, year]
  
  [USA, 700000, 701231, 1994]
  [UK, 600000, 601231, 1994]
  [China, 6512312, 6432112, 1994]
  </code></pre>
  <blockquote>
  <p>Have tried <strong>stacking/unstacking, pivoting, melting, groupby, etc..</strong></p>
  <blockquote>
  <p>I am fairly certain that one of these methods <em>is</em> the key to reorganizing this, I just cant seem to get it right.</p>
  <blockquote>
  <p><strong>End goal</strong> is to make a 3d scatterplot wherein one axis is year, another is A and another is B; while country will be indicated by color</p>
  </blockquote>
  </blockquote>
  </blockquote>
  <h2>Update: Using Pivot, I am able to get the data to <em>Look</em> the right way, but the same issue arises when I try to plot it.</h2>
  <blockquote>
  <p>Because 'Year' and 'Country' are indexed, they cannot be identified as elements eligible for axes.</p>
  <blockquote>
  <p>Expected 'A' or 'B' but got 'year'/'country'</p>
  </blockquote>
  </blockquote>