title: Accessing Another Column By Value ,Pandas
body: <p>I have a dataframe as follows:</p>
  
  <pre><code>    Type      Name           Category              
      Bird      Flappy Bird    Air      
      Bird      Pigeon         Air    
      Pokemon   Jerry          Aquatic      
      Pokemon   Mudkip         Aquatic
      Animal    Lion           Terrestrial
      Bird      Pigeon         Air2  
  </code></pre>
  
  <p>For the given name like say <code>"Pigeon"</code>, I need to access the corresponding value in the category Column i.e it should give me the string <code>"Air"</code> .<br>
  I have 2 values of <code>Pigeon</code> but i need to return "Air" for 2nd observation.</p>
  
  <p>Please note that I am <strong>not using indexing</strong> at all so having something like 2nd observation with <code>iloc</code> would'nt do. I need to access it by <strong>value</strong> in the other column.  </p>
  
  <p>Or something like <strong>obtaining</strong> the <strong>index</strong> of <strong>"Pigeon"</strong> and <strong>using that</strong> to get the corresponding column value will do.               </p>