title: What's the Python/pandas equivalent to this SQL for finding both the max value and column-name?
body: <p>What is the python/pandas equivalent of a <code>MAX(variable)</code> statement like:</p>
  
  <pre><code>SELECT ID, Name FROM Table5 WHERE 
  Friend_count = (SELECT MAX(friend_count) FROM Table5);
  </code></pre>
  
  <p>(I am trying to learn how to do some things in Python that I would normally do in SQL. I would think I could do this in pandas, but not finding a way.)</p>