title: Get column name if value exists in a cell
body: <p>I got following excel sheet:</p>
  <p><a href="https://i.stack.imgur.com/lspiq.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lspiq.jpg" alt="Excel sheet" /></a></p>
  <p>Iterating through each of the rows I need to extract column name wherever 'x' value occurs. How could I do that? There's no option to &quot;get column name&quot; basing on the cell.</p>
  <p>Here is my code:</p>
  <pre><code>df = pd.read_excel(&quot;/Users/farmaceut/Sites/journals_database/journals.xlsx&quot;, header=[2, 3])
  df = df.replace(np.nan, '', regex=True)
  for col in df.columns[8:]:
  ...Domain.objects.update_or_create(domain_name=col[0])
  for index, col in df.iterrows():
  ......journal = Journal.objects.update_or_create(title=col[1], abbreviation=col[4], impact_factor=0,ministerial_points=col[7])
  for cell in col[8:]:
  ...if cell == 'x':
  ......????
  </code></pre>