Getting cell value by row name and column name from dataframe

Question

Let's say I have the following data frame

     name             age     favorite_color  grade
0    Willard Morris   20           blue     88
1       Al Jennings   19           blue     92
2      Omar Mullins   22         yellow     95
3  Spencer McDaniel   21          green     70

And I'm trying to get the grade for Omar which is "95"

it can be easily obtained using

ddf = df.loc[[2], ['grade']]
print(ddf)

However, I want to use his name "Omar" instead of using the raw index "2".

Is it possible?

I tried the following syntax but it didn't work

ddf = df.loc[['Omar Mullins'], ['grade']]

buhtz · Accepted Answer · 2022-06-21 10:47:51Z

6

Try this:

 ddf = df[df['name'] == 'Omar Mullins']['grade']

to output the grade values.

Instead:

ddf = df[df['name'] == 'Omar Mullins']

will output the full row.

edited Jun 21, 2022 at 10:47

buhtz

12.5k22 gold badges95 silver badges196 bronze badges

answered Jun 21, 2022 at 10:40

Alessandro Togni

8712 gold badges16 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ahmed Nabil Over a year ago

Thanks a lot! wish I asked earlier to save that wasted 1 hour :')

Alessandro Togni Over a year ago

Glad to be helpful. Cheers!

Collectives™ on Stack Overflow

Getting cell value by row name and column name from dataframe

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related