title: Python Pandas, Reading in file and skipping rows ahead of header
body: <p>I am trying to loop over some files and skip the rows before the header in each file using pandas. All of the files are in the same data format except some have different number of rows to skip before the header. Is there a way to loop over the files and start at the header of each file when some have more rows to skip than others?</p>
  
  <p>For example,
  some files require this:</p>
  
  <pre><code>f = pd.read_csv(fname,skiprows = 7,parse_dates=[0])
  </code></pre>
  
  <p>And some require this:</p>
  
  <pre><code>f = pd.read_csv(fname,skiprows = 15, parse_dates=[0])
  </code></pre>
  
  <p>Here is my chunk of code looping over my files:</p>
  
  <pre><code>for name,ID in stations:
      path = str(ID)+'/*.csv'
      for fname in glob.glob(path):
          print(fname)
          f = pd.read_csv(fname,skiprows=15,parse_dates=[0]) #could also skip 7 depending on file
          ws = f['Wind Spd (km/h)']*0.27778 #convert to m/s from km/h
          dt = f['Date/Time']
  </code></pre>