title: incrementally search excel with pandas to match string
body: <p>I'm iterating through excel files and logging rows that contain a string, like so:</p>
  <pre><code>def find_string_row(toFind, dframe):
      index = 0
      while toFind not in dframe.iloc[index].values:
          print(dframe.iloc[index].values)
          index = index+1
      return index  
  </code></pre>
  <p>I have some new files that are quite messy, and contain strings with whitespace inside and outside the text. So while the above works for exact matches, it fails for loose matches. How can I rewrite this to find strings in this manner:</p>
  <pre><code>toFind.replace(&quot; &quot;, &quot;&quot;).lower()  
  </code></pre>
  <p>so if I input a string like &quot;Address 1 23  &quot; and the excel contains &quot;  add ress 12    3&quot; they will match?</p>