How to retrieve data if you know the column value and row value using a pandas data frame?

Question

If I have a pandas data frame like this:

   A  B  C  D  E  
1  3  4  2  5  1
2  5  4  2  4  4
3  5  1  8  1  3
4  1  1  9  9  4
5  3  6  4  1  1

and want to find a value with a row value of 3 and column value of D how do I go about doing it?

In this case, I had a row value of 3 and column value of D how would I get a return of 1 in this instance?

Or if I had a row value of 2 and column value of B how would I get a return of 4?

Literally `df.loc[3, 'D']`, or `df.loc[2, 'B']` – Vishnu Kunchur Oct 05 '18 at 02:47 — Vishnu Kunchur, Oct 05 '18 at 02:47

score 1 · Answer 1 · answered Oct 05 '18 at 02:50

1

You can use DataFrame.loc: df.loc[row, 'col_name'], eg, df.loc[2, 'B'] for 4

answered Oct 05 '18 at 02:50

kaiserasif

1 Answers1