title: pandas split by last delimiter
body: <p>I have the following column in a dataframe with different outputs"</p>
  
  <pre><code>col1
  MLB|NBA|NFL
  MLB|NBA
  NFL|NHL|NBA|MLB
  </code></pre>
  
  <p>I would like to use the split function to split the column by the last pipe always so something like this:</p>
  
  <pre><code>col1           col2
  MLB|NBA        NFL
  MLB            NBA
  NFL|NHL|NBA    MLB
  </code></pre>