title: Pandas: Read/Write CSV File that has Different Delimiters for Different Rows
body: <p>I am a student learning python, and i am running into some difficulties. I am trying to read a csv file that has different delimiters for different rows: Example:</p>
  
  <pre><code>Format:V1.1
  Model: R
  Step Size: 10mm
  Distance: 10cm
  Gain: 1000
  
  X,Y
  1,3
  2,5
  6,5
  5,7
  </code></pre>
  
  <p>For the <code>X,Y</code> data, I have no problem getting it into the right cells, however I cannot separate the values after the colon for the first few rows. Its either one or the other. I am using pandas to read my <code>CSV</code> file. So far I have:</p>
  
  <pre><code>d=pd.read_csv('read.csv',delimiter=',',skiprows=0)
  </code></pre>
  
  <p>When I replace the delimiter for <code>:</code>, it no longer works, and if i put sep=<code>,|:</code> it does not work either. In the end I need to plot the <code>x,y</code> values and i will need some of the info in the rows above like the gain to manipulate the y data. If you have any tips for me I would be very grateful!</p>
  
  <p>Thanks</p>