title: Get column name which contains a specific value at any rows in python pandas
body: <p>I want to get column name from the whole database (assume the database contains more than 100 rows with more than 50 column) based on specific value that contain in a specific column in pandas.</p>
  
  <p>with the help of Bkmm3 (member from india) I've succeeded on numerical term but failed on alphabetic term. the way I've tried is this:</p>
  
  <pre><code>df = pd.DataFrame({'A':['APPLE','BALL','CAT'],
                      'B':['ACTION','BATMAN','CATCHUP'],
                      'C':['ADVERTISE','BEAST','CARTOON']})
  response = input("input")
  for i in df.columns: if(len(df.query(i + '==' + str(response))) &gt; 0):
  print(i)`
  </code></pre>
  
  <p>then output arise as error:</p>
  
  <pre><code>Traceback (most recent call last): NameError: name 'APPLE' is not defined
  </code></pre>
  
  <p>Any Help from You Guys will be very Appreciated, Thank You . . .</p>