title: Split a dataframe column with regex
body: <p>I'm trying to split a column that has a specific delimiter like: '|'.</p>
  
  <p>My data looks like this, I have ONLY ONE COLUMN named  "ID" that contains those strings that I want to split based on delimiter " | "</p>
  
  <pre><code>ID accountsummary            | Name: Report Suite Totals 
  
  ID activity                  | Name: Activity 
  </code></pre>
  
  <p>I've tried with 2 different approaches:</p>
  
  <ol>
  <li><pre><code>dataframe_elements_int[['ID', 'Name']] = \
      dataframe_elements_int['ID'].str.rsplit('|', expand=True, n=1)
  </code></pre></li>
  </ol>
  
  <p>Which gives me the following error: <code>ValueError: Columns must be same length as key</code></p>
  
  <ol start="2">
  <li><pre><code>dataframe_final[['Id','Name']] = \
      dataframe_elements_int['ID'].str.extract('(\w*)\|(\w*)', expand=True)
  </code></pre></li>
  </ol>
  
  <p>Which gives me the following error: <code>ValueError: pattern contains no capture groups</code></p>