extract column value based on another column pandas dataframe
Solution 1:
You could use loc to get series which satisfying your condition and then iloc to get first element:
In [2]: df
Out[2]:
A B
0 p1 1
1 p1 2
2 p3 3
3 p2 4
In [3]: df.loc[df['B'] == 3, 'A']
Out[3]:
2 p3
Name: A, dtype: object
In [4]: df.loc[df['B'] == 3, 'A'].iloc[0]
Out[4]: 'p3'
Solution 2:
You can try query, which is less typing:
df.query('B==3')['A']
Solution 3:
df[df['B']==3]['A'], assuming df is your pandas.DataFrame.