title: Pandas separate column containing string with a semicolon to multiple columns
body: <p>I am unable to split a pandas series that contains a semicolon. Is it because I am using the column name ('Social_Media') as an index or is it because python wont recognise a semicolon as a split character? Or is something wrong with my script?</p>
  
  <pre><code>#Filters the NaN columns
  df2 = df[df['Social_Media'].notnull()]
  # Splitter for semicolon
  df2['Social_Media'].apply(lambda x: x.split(';')[0])
  
  #This is my output after the split
  Timestamp                             
  2017-06-01 18:10:46          Twitter;Facebook;Instagram;WhatsApp;Google+
  2017-06-01 19:24:04          Twitter;Facebook;Instagram;WhatsApp;Google+
  2017-06-01 19:25:21          Twitter;Facebook;Instagram;WhatsApp;Google+
  </code></pre>
  
  <p>What I need to see as output.</p>
  
  <pre><code>Timestamp                    name_a  name_b   name_c    name_d   name_e
  2017-06-01 18:10:46          Twitter Facebook Instagram WhatsApp Google+
  2017-06-01 19:24:04          Twitter Facebook Instagram WhatsApp Google+
  2017-06-01 19:25:21          Twitter Facebook Instagram WhatsApp Google+
  </code></pre>