title: extracting a single data from pandas data frame
body: <p>How do you extract a value (string) from a given Dataframe, given a certain value from a different column.</p>
  
  <p>For example, I would like to get the 'Adrs' where 'Value'=2</p>
  
  <pre><code>import pandas as pd
  
  df = pd.DataFrame({'Adrs':["AAA","BBB"],'Value':[1,2]}, index=[0,1])
  
  print(df)
  print("")
  
  df2 = df[df['Value']==2]
  string = df2.Adrs
  print(string)
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>Adrs  Value
  0  AAA      1
  1  BBB      2
  
  1    BBB
  Name: Adrs, dtype: object
  </code></pre>
  
  <p>I would like to extract just the "BBB" instead of that entire table/data frame.  Is there a quick way to do this without doing some parsing of the df2.Adrs</p>
  
  <p>If df2 has multiple rows, I can extract BBB by df2['Adrs'][1]</p>
  
  <p>see below:</p>
  
  <pre><code>import pandas as pd
  
  df = pd.DataFrame({'Adrs':["AAA","BBB"],'Value':[2,2]}, index=[0,1])
  
  print(df)
  print("")
  
  df2 = df[df['Value']==2]
  string = str(df2['Adrs'][1])
  print(string)
  </code></pre>
  
  <p>output:</p>
  
  <pre><code> Adrs  Value
  0  AAA      2
  1  BBB      2
  
  BBB
  </code></pre>