How do I access a single cell value from a pandas DataFrame containing a single row?

Accessing Single Cell Values from DataFrames

In pandas, extracting specific values from dataframes can be done in various ways. One common scenario encountered by users is obtaining a single value from a dataframe that contains a single row.

To address this, let's consider the following scenario:

<code class="python">d2 = df[(df['l_ext']==l_ext) & (df['item']==item) & (df['wn']==wn) & (df['wd']==1)]

# Attempting to extract a value from a single-row dataframe
val = d2['col_name']</code>

Instead of obtaining the desired single float value, the code returns a dataframe with one row and one column, effectively a cell.

To obtain the single cell value, you can employ the following approach:

<code class="python">val = d2.iloc[0]['col_name']</code>

This approach involves accessing the first (and only) row of the dataframe using iloc[0], which returns a Series. You can then access the desired column value using the square brackets with the column name.

For instance, if sub_df is a dataframe with a single row:

<code class="python">sub_df = df[(df['condition'] == True)]</code>

You can access the value of column 'A' in this row using:

<code class="python">single_value = sub_df.iloc[0]['A']</code>

The above is the detailed content of How do I access a single cell value from a pandas DataFrame containing a single row?. For more information, please follow other related articles on the PHP Chinese website!