How to get a value from the cell of a Pandas DataFrame?

To get a value from the cell of a DataFrame, we can use the index and col variables.

Steps

• Create a two-dimensional, size-mutable, potentially heterogeneous tabular data, df.

• Print the input DataFrame, df.

• Initialize the index variable.

• Initialize the col variable.

• Get the cell value corresponding to index and col variable.

• Print the cell value.

Example

<span class="kwd">import</span><span class="pln"> pandas </span><span class="kwd">as</span><span class="pln"> pd

df </span><span class="pun">=</span><span class="pln"> pd</span><span class="pun">.</span><span class="typ">DataFrame</span><span class="pun">(</span><span class="pln">
   </span><span class="pun">{</span><span class="pln">
      </span><span class="str">"x"</span><span class="pun">:</span><span class="pln"> </span><span class="pun">[</span><span class="lit">5</span><span class="pun">,</span><span class="pln"> </span><span class="lit">2</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pun">,</span><span class="pln"> </span><span class="lit">9</span><span class="pun">],</span><span class="pln">
      </span><span class="str">"y"</span><span class="pun">:</span><span class="pln"> </span><span class="pun">[</span><span class="lit">4</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pun">,</span><span class="pln"> </span><span class="lit">5</span><span class="pun">,</span><span class="pln"> </span><span class="lit">10</span><span class="pun">],</span><span class="pln">
      </span><span class="str">"z"</span><span class="pun">:</span><span class="pln"> </span><span class="pun">[</span><span class="lit">4</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pun">,</span><span class="pln"> </span><span class="lit">5</span><span class="pun">,</span><span class="pln"> </span><span class="lit">0</span><span class="pun">]</span><span class="pln">
   </span><span class="pun">}</span><span class="pln">
</span><span class="pun">)</span><span class="pln">
</span><span class="kwd">print</span><span class="pun">(</span><span class="str">"Input DataFrame is:<br>"</span><span class="pun">,</span><span class="pln"> df</span><span class="pun">)</span><span class="pln">

index </span><span class="pun">=</span><span class="pln"> </span><span class="lit">2</span><span class="pln">
col </span><span class="pun">=</span><span class="pln"> </span><span class="str">"y"</span><span class="pln">
cell_val </span><span class="pun">=</span><span class="pln"> df</span><span class="pun">.</span><span class="pln">iloc</span><span class="pun">[</span><span class="pln">index</span><span class="pun">][</span><span class="pln">col</span><span class="pun">]</span><span class="pln">
</span><span class="kwd">print</span><span class="pln"> </span><span class="str">"Cell value at "</span><span class="pun">,</span><span class="pln"> index</span><span class="pun">,</span><span class="pln"> </span><span class="str">"for column "</span><span class="pun">,</span><span class="pln"> col</span><span class="pun">,</span><span class="pln"> </span><span class="str">" : "</span><span class="pun">,</span><span class="pln"> cell_val

index </span><span class="pun">=</span><span class="pln"> </span><span class="lit">0</span><span class="pln">
col </span><span class="pun">=</span><span class="pln"> </span><span class="str">"x"</span><span class="pln">
cell_val </span><span class="pun">=</span><span class="pln"> df</span><span class="pun">.</span><span class="pln">iloc</span><span class="pun">[</span><span class="pln">index</span><span class="pun">][</span><span class="pln">col</span><span class="pun">]</span><span class="pln">
</span><span class="kwd">print</span><span class="pln"> </span><span class="str">"Cell value at "</span><span class="pun">,</span><span class="pln"> index</span><span class="pun">,</span><span class="pln"> </span><span class="str">"for column "</span><span class="pun">,</span><span class="pln"> col</span><span class="pun">,</span><span class="pln"> </span><span class="str">" : "</span><span class="pun">,</span><span class="pln"> cell_val

index </span><span class="pun">=</span><span class="pln"> </span><span class="lit">1</span><span class="pln">
col </span><span class="pun">=</span><span class="pln"> </span><span class="str">"z"</span><span class="pln">
cell_val </span><span class="pun">=</span><span class="pln"> df</span><span class="pun">.</span><span class="pln">iloc</span><span class="pun">[</span><span class="pln">index</span><span class="pun">][</span><span class="pln">col</span><span class="pun">]</span><span class="pln">
</span><span class="kwd">print</span><span class="pln"> </span><span class="str">"Cell value at "</span><span class="pun">,</span><span class="pln"> index</span><span class="pun">,</span><span class="pln"> </span><span class="str">"for column "</span><span class="pun">,</span><span class="pln"> col</span><span class="pun">,</span><span class="pln"> </span><span class="str">" : "</span><span class="pun">,</span><span class="pln"> cell_val</span>

Output

Input DataFrame is:
   x  y  z
0  5  4  4
1  2  1  1
2  1  5  5
3  9 10  0

Cell value at 2 for column y: 5
Cell value at 0 for column x: 5
Cell value at 1 for column z: 1