title: How to split text in a column into multiple rows
body: <p>I'm working with a large csv file and the next to last column has a string of text that I want to split by a specific delimiter. I was wondering if there is a simple way to do this using pandas or python?</p>
  <pre><code>CustNum  CustomerName     ItemQty  Item   Seatblocks                 ItemExt
  32363    McCartney, Paul      3     F04    2:218:10:4,6                   60
  31316    Lennon, John        25     F01    1:13:36:1,12 1:13:37:1,13     300
  </code></pre>
  <p>I want to split by the space <code>(' ')</code> and then the colon <code>(':')</code> in the <code>Seatblocks</code> column, but each cell would result in a different number of columns. I have a function to rearrange the columns so the <code>Seatblocks</code> column is at the end of the sheet, but I'm not sure what to do from there. I can do it in excel with the built in <code>text-to-columns</code> function and a quick macro, but my dataset has too many records for excel to handle.</p>
  <p>Ultimately, I want to take records such John Lennon's and create multiple lines, with the info from each set of seats on a separate line.</p>