title: function for filtering excel cells using python pandas
body: <p>I'm trying to filter an excel sheet based on some conditions using function
  so when ever you enter the name of the staff it will filter based on the name</p>
  
  <pre><code>def small_Purchase_Filter(staff_name):
      name_filter = pd.DataFrame((list["Procurement Staff assigned to PR"] == staff_name) &amp; (master_list["Threshold"]== "Small Purchase") &amp; (list["PR Status"]=="Completed") &amp; (master_list["received"] != "open"))
      return name_filter
  </code></pre>
  
  <p>Note : this code </p>
  
  <p><code>name_filter = pd.DataFrame((list["Procurement Staff assigned to PR"] == staff_name) &amp; (master_list["Threshold"]== "Small Purchase") &amp; (list["PR Status"]=="Completed") &amp; (master_list["received"] != "open"))</code></p>
  
  <p>it was ruining just fine until i put it inside a function now all the result of the sheet is NaN</p>
  
  <p>I hope i was clear enough and thanks </p>