title: Search entire excel sheet with Pandas for word(s)
body: <p>I am trying to essentially replicate the Find function (control-f) in Python with Pandas. I want to search and entire sheet (all rows and columns) to see if any of the cells on the sheet contain a word and then print out the row in which the word was found. I'd like to do this across multiple sheets as well.</p>
  
  <p>I've imported the sheet:</p>
  
  <pre><code>pdTestDataframe = pd.read_excel(TestFile, sheet_name="Sheet Name", 
  keep_default_na= False, na_values=[""])
  </code></pre>
  
  <p>And tried to create a list of columns that I could index into the values of all of the cells but it's still excluding many of the cells in the sheet. The attempted code is below.</p>
  
  <pre><code>columnsList = []
  for i, data in enumerate(pdTestDataframe.columns):
      columnList.append(pdTestDataframe.columns[i])
  for j, data1 in enumerate(pdTestDataframe.index):
      print(pdTestDataframe[columnList[i]][j])
  </code></pre>
  
  <p>I want to make sure that no matter the formatting of the excel sheet, all cells with data inside can be searched for the word(s). Would love any help I can get!</p>