title: How to split text in various columns
body: <p>I have this CSV file <em>(in spreadsheet view)</em> <br></p>
  <p>Jobs starts after the first *</p>
  <blockquote>
  <p>Job Group * Job1 * Job 2 * Job3</p>
  </blockquote>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Job Group</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Administrative law judges, adjudicators, and hearing officers    * Appeals Examiner* Appeals Referee* Appellate Conferee* Hearing Examiner* Hearing Officer* Justice of The Peace* Traffic Court Referee</td>
  </tr>
  <tr>
  <td>Agricultural engineers    * Agricultural Engineer* Agricultural Production Engineer* Agricultural Research Engineer* Farm Equipment Engineer* Research Agricultural Engineer</td>
  </tr>
  <tr>
  <td>Advertising sales agents    * Advertising Account Executive* Advertising Agent* Advertising Solicitor* Display Advertising Sales Representative* Inside Sales Advertising Executive* Outside Sales Advertising Executive* Radio Time Salesperson* Signs and Displays Salesperson* Yellow Pages Space Salesperson</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to separate them into columns, but the <strong>number of job varies per group</strong>. <br></p>
  <blockquote>
  <blockquote>
  <p>Administrative: 7 jobs <br> Agricultural: 5 jobs <br> Advertising: 9 jobs</p>
  </blockquote>
  </blockquote>
  <p>Here are what I have tried:</p>
  <pre><code>df['Job Group'].str.split('*') 
     # This works but there is a leading whitespace
  
  
  df['Job Group'].str.split('* ') 
     # Error: nothing to repeat at position 0
  </code></pre>
  <p>This is the problem, this is what I want where the text would be separated into columns, but:</p>
  <pre><code>df[['col', 'row', 'be']] = df['Job Group'].str.split('*')
     # Error: Columns must be same length as key
  </code></pre>
  <p>How can I separate the text where I would use star and space as a delimiter <code>'* '</code>, and create a column for those separated text?</p>