title: import text to pandas with multiple delimiters
body: <p>I have some data that looks like this:</p>
  
  <pre><code>c stuff
  c more header
  c begin data         
   1 1:.5
   1 2:6.5
   1 3:5.3
  </code></pre>
  
  <p>I want to import it into a 3 column data frame, with columns e.g.</p>
  
  <pre><code>a , b, c
  1,  1, 0.5
  etc
  </code></pre>
  
  <p>I have been trying to read in the data as 2 columns split on ':', and then to split the first column on ' '. However I'm finding it irksome.
  Is there a better way to sort it out on import directly?</p>
  
  <p>currently:</p>
  
  <pre><code>data1 = pd.read_csv(file_loc, skiprows = 3, delimiter = ':', names = ['AB', 'C'])
  data2 = pd.DataFrame(data1.AB.str.split(' ',1).tolist(), names = ['A','B'])
  </code></pre>
  
  <p>However this is further complicated by the fact my data has a leading space...</p>
  
  <p>I feel like this should be a simple task, but currently I'm thinking of reading it line by line and using some find replace to sanitise the data before importing.</p>