0

I have created the below dataframe:

      C1     C2  Count
0   Jack  Item1     20
1  Jones  Item1     15

I am trying to search for the second row with person name Jones using the below command and trying to fetch the count 15. 

person_inq="Jones"
item_inq="Item1"    
count_in_df = df.loc[(df['C1'] == person_inq) & (df['C2'] == item_inq),'Count'][0]

While executing the above command, i am getting key 

KeyError: 0
vvvvv
  • 25,404
  • 19
  • 49
  • 81
Padfoot123
  • 1,057
  • 3
  • 24
  • 43
  • `df.loc[(df['C1'] == person_inq) & (df['C2'] == item_inq),'Count'].item()` is what you want. – cs95 Dec 30 '17 at 08:54
  • Thank you.. yes item() worked. whats the difference between using [0] and item()? – Padfoot123 Dec 30 '17 at 08:58
  • The result of `loc` is a series slice. The series has index 1 and value 15. Now, If you try to extract `[0]`, it tries to look for the index "0" which doesn't exist in the index. [0] does not refer to the first value, unless you use `iloc` for positional indexing. So, `df.loc[(df['C1'] == person_inq) & (df['C2'] == item_inq),'Count'].iloc[0]` would have also worked. – cs95 Dec 30 '17 at 09:00
  • Great.. Thank you – Padfoot123 Dec 30 '17 at 09:01

0 Answers0