title: Python pivot column with comma and bracket separated
body: <p>I am working with a large dataframe that currently looks like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>Region</th>
  <th>Noun</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>North America</td>
  <td>[('Everything', 'NP'), ('the product','NP'), ('it','NP')]</td>
  </tr>
  <tr>
  <td>2</td>
  <td>North America</td>
  <td>[('beautiful product','NP')]</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The third column contains noun phrase(s) and each phrases have labels (two capital letters).
  All of these are in quotation marks and then coupled in brackets, and then put in square brackets which make it difficult for me to separate and pivot.</p>
  <p>I would like to pivot the last column <strong>only</strong>, so the final output will look like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>Region</th>
  <th>Noun</th>
  <th>Type</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>North America</td>
  <td>everything</td>
  <td>NP</td>
  </tr>
  <tr>
  <td>1</td>
  <td>North America</td>
  <td>the product</td>
  <td>NP</td>
  </tr>
  <tr>
  <td>1</td>
  <td>North America</td>
  <td>it</td>
  <td>NP</td>
  </tr>
  <tr>
  <td>2</td>
  <td>North America</td>
  <td>beautiful product</td>
  <td>NP</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The annoying part is that some rows have more brackets than others.
  Is there any way I could make this happen on Python?</p>