title: Pandas split column by combined delimiters
body: <p>I have a dataframe where the delimiter is set to be in this format &quot;|&quot;</p>
  <p>Previously I tried this but it didnt work out.</p>
  <pre><code>df.str.split('&quot;|&quot;', expand = True) 
  </code></pre>
  <p>Below is an example of my dataset. both strings are captured in a single column in csv format.</p>
  <pre><code>&quot;COLUMN_A&quot;|&quot;COLUMN_B&quot;
  &quot;MARY&quot;|&quot;HADALITTLELAMB&quot;
  </code></pre>
  <p>Ideally I should see this</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>COLUMN_A</th>
  <th>COLUMN_B</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>MARY</td>
  <td>HAD A LITTLE LAMB</td>
  </tr>
  </tbody>
  </table>
  </div>