title: Pivot Data with Uneven Groups Python Pandas
body: <p>I have a table and I want to convert it using Python 3x Pandas into the following:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Group</th>
  <th>Assessment</th>
  <th>Review</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>GroupA</td>
  <td>No team spirit</td>
  <td>Negative</td>
  </tr>
  <tr>
  <td>GroupA</td>
  <td>Good players</td>
  <td>Positive</td>
  </tr>
  <tr>
  <td>GroupA</td>
  <td>They scored well</td>
  <td>Positive</td>
  </tr>
  <tr>
  <td>GroupB</td>
  <td>Goal failed</td>
  <td>Negative</td>
  </tr>
  <tr>
  <td>GroupB</td>
  <td>Bad weather</td>
  <td>Negative</td>
  </tr>
  <tr>
  <td>GroupB</td>
  <td>Resilience</td>
  <td>Positive</td>
  </tr>
  <tr>
  <td>GroupB</td>
  <td>Growth potential</td>
  <td>Positive</td>
  </tr>
  <tr>
  <td>GroupB</td>
  <td>Bad  technique</td>
  <td>Negative</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Resulting table should be:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Group</th>
  <th>Positive</th>
  <th>Negative</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>GroupA</td>
  <td>Good players</td>
  <td>No team spirit</td>
  </tr>
  <tr>
  <td>GroupA</td>
  <td>They scored well</td>
  <td>NaN</td>
  </tr>
  <tr>
  <td>GroupB</td>
  <td>Resilience</td>
  <td>Goal Failed</td>
  </tr>
  <tr>
  <td>GroupB</td>
  <td>Growth Potential</td>
  <td>Bad weather</td>
  </tr>
  <tr>
  <td>GroupB</td>
  <td>NaN</td>
  <td>Bad Technique</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Is there any neat, Pythonic way of doing it using Pandas or other method?</p>