title: Accessing the index/row/column from a selected cell in Pandas/Python
body: <p>I'm supposed to be turning an excel spreadsheet with nontrivial functions into a web application. I have decided to work with Pandas, and I'm wondering what the best way to approach this is. </p>
  
  <p>One of the things I need to do is allow people to input a certain number (we'll call this <code>lot_number</code>) and access other values in the same row. </p>
  
  <p>For example, if <code>lot_number = 3</code>, <code>address_value</code> in a different column will be 555 Something Street. All of the <code>lot_numbers</code> and <code>address_value</code> entries are different.</p>
  
  <p>My question is this: how can I access <code>address_value</code> using pandas depending on <code>lot_number</code>?</p>