title: Select a value from a specific column and row
body: <p>I'm storing the result of a SQL Query in a DataFrame and I just don't understand how can I get a specific value. I have the following code:</p>
  <pre><code>    for date in years:
      partyList = pd.read_sql_query(
          &quot;SELECT top 2 country_name,election_date,party_name_english, vote_share, left_right FROM view_election WHERE country_name_short like '&quot; + country + &quot;' and election_date like '&quot; + date + &quot;' ORDER BY vote_share DESC&quot;,
          conn)
      parties = str(partyList).replace(&quot; &quot;, &quot;&quot;).split()
      parties.remove(parties[0])
      format(parties)
      # print(partyList)
      total = total.append(partyList)
  print(total.iloc[0, 0:1])
  </code></pre>
  <p>The output is:</p>
  <pre><code>country_name    Slovakia
  Name: 0, dtype: object
  </code></pre>
  <p><strong>How can I get the String &quot;Slovakia&quot; to a variable? I want to understand how I do it so I can use it for other values as well</strong></p>
  <p>Also, How can I store an entire row into a &quot;normal&quot; array? I'm asking this just because I find it easier to work with regular arrays</p>