How can I select specific cell in a dataframe?

Question

How can I select a specific cell in this dataframe?, the index in this data frame is the Fishes column.
My expected output is: e.g
> 35045.12
or anything in the production column. Thanks a lot!

Fishes                 | Month | Year | production
BF - Milkfish          |   3   | 2019 | 35045.12
BF - Tilapia           |   6   | 2019 | 68666.64
BF - Tiger prawn       |   9   | 2019 | 77064.91
BF - Mudcrab           |   12  | 2019 | 58163.4
BF - Endeavor prawn    |   3   | 2020 | 38108.49
BF - White shrimp      |   6   | 2020 | 67663.83
BF - Grouper           |   9   | 2020 | 71316.94

`df['production']['BF - Milkfish']` probably – SuperStew Jun 08 '22 at 15:38 — SuperStew, Jun 08 '22 at 15:38
@SuperStew I am getting an error. KeyError: 'BF - Milkfish' – love Jun 09 '22 at 09:34 — love, Jun 09 '22 at 09:34

Ynjxsjmh · Accepted Answer · 2022-06-08T15:40:06.877

0

print(df.loc['BF - Milkfish', 'production'])
# or
print(df['production'].iloc[0])

35045.12

edited Jun 08 '22 at 15:40

answered Jun 08 '22 at 15:39

Ynjxsjmh

28,441
6
34
52

I need your first code but I get an error. KeyError: 'BF - Milkfish' – love Jun 09 '22 at 09:37
@love What's the result of `print(df.index)`? – Ynjxsjmh Jun 09 '22 at 09:58
Index(['BF - Milkfish ', 'BF - Tilapia', 'BF - Tiger prawn', 'BF - Mudcrab', 'BF - Endeavor prawn ', 'BF - White shrimp ', 'BF - Grouper', name='Fishes') – love Jun 09 '22 at 10:25
I know my mistake BF - Milkfish has a space so that i get that error. Thankyousoomuch!!!! – love Jun 09 '22 at 10:28
booooo `loc` boooooo – SuperStew Jun 09 '22 at 13:21

score 0 · Answer 2 · answered Jun 08 '22 at 15:43

0

There are several ways to get the answer you are looking for, this is simply another way if you wanted to add to your bag of tricks

df['production'].loc[df['Fishes'] == 'BF - Milkfish'].squeeze()

answered Jun 08 '22 at 15:43

ArchAngelPwn

2,891
1
4
17

I am getting an error of. KeyError: 'Fishes' – love Jun 09 '22 at 09:36
Why did our convo get deleted? – SuperStew Jun 09 '22 at 13:20
Oh, I'm not sure...it was probably some higher ranking person thinking we should do this in chat or something – ArchAngelPwn Jun 09 '22 at 13:22

How can I select specific cell in a dataframe?

2 Answers2