title: Pick highest values in rows which have the same label in a column
body: <p>I have a table like shown below</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">SKU</th>
  <th style="text-align: center;">Stock</th>
  <th style="text-align: right;">Past</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">ABC</td>
  <td style="text-align: center;">0</td>
  <td style="text-align: right;">45</td>
  </tr>
  <tr>
  <td style="text-align: left;">ABC</td>
  <td style="text-align: center;">20</td>
  <td style="text-align: right;">30</td>
  </tr>
  <tr>
  <td style="text-align: left;">DEF</td>
  <td style="text-align: center;">22</td>
  <td style="text-align: right;">0</td>
  </tr>
  <tr>
  <td style="text-align: left;">DEF</td>
  <td style="text-align: center;">5</td>
  <td style="text-align: right;">67</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Basically, I just want to change the value of 'Stock' and 'Past' to just one value and pick the highest, so the result should be:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">SKU</th>
  <th style="text-align: center;">Stock</th>
  <th style="text-align: right;">Past</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">ABC</td>
  <td style="text-align: center;">20</td>
  <td style="text-align: right;">45</td>
  </tr>
  <tr>
  <td style="text-align: left;">DEF</td>
  <td style="text-align: center;">22</td>
  <td style="text-align: right;">67</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Is this possible to be done in Pandas? Please advise, anyone. Thank you very much!</p>