Select cell value from row based on value in another column in Pandas with Python

Asked Oct 30 '17 at 21:17

Active Oct 30 '17 at 21:22

Viewed 4,230 times

How can I get a value from a cell based on a value of another cell of the same row? For example, let's say I have the following dataframe:

    A     C   D
0  foo1    0   0
1  foo2    2   4
2  foo3    9   8
3  foo4    6  12
4  foo5    7  14

How can I grab the value from column C of the row that has foo3 in column A? In this example, it is 9. I am using Pandas with Python.

edited Oct 30 '17 at 21:22

cs95

asked Oct 30 '17 at 21:17

sprogissd

1

https://pandas.pydata.org/pandas-docs/stable/indexing.html – MaxU - stop genocide of UA Oct 30 '17 at 21:19
google search before asking – BENY Oct 30 '17 at 21:20
Do you think tagging this python2.7 will give you a different answer than tagging it in python? – cs95 Oct 30 '17 at 21:22
1

`df.at[df['A'].eq('foo3').idxmax(),'C']` – MaxU - stop genocide of UA Oct 30 '17 at 21:25

0 Answers0