title: Python: str.split string returning 'Columns must be same length as key' despite expand=True and no multiple matches for regex in string
body: <p>I've been working on this for a while now and it doesn't make a lot of sense to me</p>
  
  <p>I have some coordinate data that comes in the form of:</p>
  
  <p>"4.970599399999999, 'lng': -1.6918635"</p>
  
  <p>The first part is the latitude, and the second the longitude.</p>
  
  <p>This is the column:</p>
  
  <pre><code> coordinates
    4.970599399999999, 'lng': -1.6918635
    None
    4.5, 'lng': -1.69
    4.9705, 'lng': -1.6
    None
  </code></pre>
  
  <p>The code i'm using is:</p>
  
  <pre><code>data[['latitude','longitude']] = data['coordinates'].str.split('\,\s\'lng\'\w*\:\s',expand=True)
  </code></pre>
  
  <p>I've used Regexr to confirm that my regex is perfectly fine and splitting on the right delimiter and there isn't a problem there</p>
  
  <p>But the error i'm getting is this:</p>
  
  <p>"ValueError: Columns must be same length as key"</p>
  
  <p>I have experienced this error before and I found it was due to having multiple matches in the string - but these strings are short and simple! It's either 'None' or the coordinates</p>
  
  <p>Can anyone help? </p>
  
  <p>Thanks a lot</p>