title: How do I get information in one column into 2 new columns?
body: <p>I have a dataframe of teachers and chaperones on a school trip.</p>
  <p>Index | Name | Class | Number_Of_Students | Bus_Number</p>
  <hr />
  <p>The names in the 'Name' column are listed like: Surname, Mx. Forename MiddleInitial</p>
  <p>I am trying to split the 'Name' column into two separate columns: Surname | Forename</p>
  <p>This is what I have tried:</p>
  <pre><code>ChaperoneName = df['Name']
  df = df.assign( Surname = ChaperoneName[0], Forename = ChaperoneName[2])
  </code></pre>
  <p>The idea was if I isolated the one column, I could slice the strings in each row to get the Surname and the Forename into their new respective columns. But this has not worked for me. All I get in return are 2 properly named columns, but with the 0 and 2 indexed names repeating in each row.</p>