title: python pandas reshape data from long to wide
body: <p>I have a dataframe in the following format that I am trying to reshape into wide format in pandas.</p>
  <p>But I am getting the error Index contains duplicate entries, cannot reshape.</p>
  <p><code>df</code>:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>status</th>
  <th>value</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>item_ordered</td>
  <td>complete</td>
  </tr>
  <tr>
  <td>1</td>
  <td>item_received</td>
  <td>complete</td>
  </tr>
  <tr>
  <td>1</td>
  <td>item_setup</td>
  <td>complete</td>
  </tr>
  <tr>
  <td>2</td>
  <td>item_ordered</td>
  <td>complete</td>
  </tr>
  <tr>
  <td>2</td>
  <td>item_setup</td>
  <td>complete</td>
  </tr>
  <tr>
  <td>2</td>
  <td>item_setup</td>
  <td></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The format that I am trying to reshape to:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>item_ordered</th>
  <th>item_received</th>
  <th>item_setup</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>complete</td>
  <td>complete</td>
  <td>complete</td>
  </tr>
  <tr>
  <td>2</td>
  <td>complete</td>
  <td>complete</td>
  <td></td>
  </tr>
  </tbody>
  </table>
  </div>