title: How do you split a row into multiple rows based on delimiter and have them tie back to another column as key:value pairs?
body: <p>Stack community!</p>
  <p>I have a CSV file where 1 row contains messy data coming from another data source. Example:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Packet number</th>
  <th style="text-align: left;">Actions</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">216</td>
  <td style="text-align: left;">[{&quot;ActionNeeded&quot;:&quot;Update things&quot;,&quot;ResponsibleName&quot;:&quot;John Smith&quot;},{&quot;ActionNeeded&quot;:&quot;Design stuff&quot;,&quot;ResponsibleName&quot;:&quot;Jane Smith&quot;}]</td>
  </tr>
  <tr>
  <td style="text-align: left;">217</td>
  <td style="text-align: left;">[{&quot;ActionNeeded&quot;:&quot;Update stuff&quot;,&quot;ResponsibleName&quot;:&quot;Fred Freddington&quot;},{&quot;ActionNeeded&quot;:&quot;Design stuff&quot;,&quot;ResponsibleName&quot;:&quot;Lisa Leslie&quot;}]</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Is there a way to split the actions column into rows based on } as the delimiter and separate it by action and name column. But also have the split columns tie back to the Packet number as key:value pairs?</p>
  <p>This is what i'd want my CSV file to look like:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Packet Number</th>
  <th style="text-align: center;">Actions</th>
  <th style="text-align: right;">Responsible Name</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">216</td>
  <td style="text-align: center;">Update Things</td>
  <td style="text-align: right;">John Smith</td>
  </tr>
  <tr>
  <td style="text-align: left;">216</td>
  <td style="text-align: center;">Design stuff</td>
  <td style="text-align: right;">Jane Smith</td>
  </tr>
  <tr>
  <td style="text-align: left;">217</td>
  <td style="text-align: center;">Update stuff</td>
  <td style="text-align: right;">Fred Freddington</td>
  </tr>
  <tr>
  <td style="text-align: left;">217</td>
  <td style="text-align: center;">Design stuff</td>
  <td style="text-align: right;">Lisa Leslie</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I've tried using df split and str.findall to isolate Actions and Responsible names, but i'm finding it hard to tie the split rows back to the packet number column.</p>
  <p>Thanks much!</p>