title: Delete Rows prior to specific String in Pandas
body: <p>I have  excel files in following format:</p>
  
  <pre><code>Sensor 1 meta
  Sensor 2 meta
  "Summary of Observation"
  Sensor 1
  Sensor 2
  </code></pre>
  
  <p>The number of rows before and after "Summary of Observation" is not fixed (i.e one file may have only sensor 1,2 while other may have 1,2,3....)</p>
  
  <p>In dataframe, I only want information after "Summary of Observation")</p>
  
  <p>Right now, I open the excel file, note the row from which I want information and parse it in</p>
  
  <pre><code>df = pd.read_excel("1.xlsx",skiprows = %put some value here%)
  </code></pre>
  
  <p>Is there a way to automate this, i.e. I don't want to open excel. Rather only import relevant rows (or delete them after importing).</p>