title: Retrieving values from a DataFrame
body: <p>My DataFrame (<code>df = df.sort_values('market_name').iloc[:1]</code>):</p>
  <pre><code>                  competition                         event_name  event_id country_code           market_name    market_id  total_matched             Home  Home_id            Away  Away_id Draw  Draw_id
  7  CONMEBOL Copa Libertadores  Atletico MG v Independiente (Ecu)  31459931         None  First Half Goals 1.5  1.199224510  115362.090985  Under 1.5 Goals  1221385  Over 1.5 Goals  1221386             0
  </code></pre>
  <p>For get <code>market_id</code> i need use index <code>[0]</code>:</p>
  <pre><code>df['market_id'].values[0]
  </code></pre>
  <p>To collect the value writing only <code>['market_id']</code> I'm using <code>.reset_index()</code> + <code>.iterrows()</code>:</p>
  <pre><code>df = df.sort_values('market_name').iloc[:1]
  df = df.reset_index()
  for index, row in df.iterrows():
      row['market_id']
  </code></pre>
  <p>As this <em>dataframe</em> will always exist only one line, there is a more professional way to get this same result without this mess using many lines and looping?</p>
  <p>The idea would be to format this <em>dataframe</em> beforehand so I don't need to put this <code>.value[0]</code> in each value I want to fetch and call only by the column name.</p>