title: Data Cleaning How to split Pandas column
body: <p>It has been sometime since I tried working in python.</p>
  <p>I have below data frame with many columns too many to name.</p>
  <pre><code>  last/first    location    job    department
    smith john    Vancouver   A1     servers
    rogers steve  Toronto     A2     eng
    Rogers Dave   Toronto     A4     HR
  </code></pre>
  <p>How to I remove caps in the last/first column and also split the last/first column by &quot; &quot;?</p>
  <p>Goal:</p>
  <pre><code>  last      first    location    job    department
    smith     john     Vancouver   A1     servers
    rogers    steve    Toronto     A2     eng
    rogers    dave     Toronto     A4     HR
    
  </code></pre>