How to access another column's value from a given id number in pandas DataFrame?

Question

I have following format of DataFrame:

# import pandas library
import pandas as pd
  
# Creating a dictionary
d = {'id': ['a', 'b', 'c'],
     'label': ['bal', 'sal', 'tal'], 
     } 
  
# Creating a Dataframe
df = pd.DataFrame(d) 
  
# show the dataframe
print(df)

Output:

  id label
0  a   bal
1  b   sal
2  c   tal

I have id = 'b'. Now I want to access the corresponding label value like label = 'sal'.

How can I do this?

Does this answer your question? [Selecting columns with condition on Pandas DataFrame](https://stackoverflow.com/questions/37663931/selecting-columns-with-condition-on-pandas-dataframe) — itprorh66, Dec 27 '21 at 15:39

Mayank Porwal · Accepted Answer · 2021-12-27T15:44:13.033

4

Like this:

In [21]: df.set_index('id').loc['b', 'label']
Out[21]: 'sal'

Or, use df.query:

In [28]: df.query('id == "b"')['label']
Out[28]: 
1    sal
Name: label, dtype: object

edited Dec 27 '21 at 15:44

answered Dec 27 '21 at 15:39

Mayank Porwal

33,470
8
37
58

score 1 · Answer 2 · answered Dec 27 '21 at 15:41

1

Is this what you need?

df.loc[df.id == 'b', 'label']

answered Dec 27 '21 at 15:41

Paul

1,801
1
12
18

How to access another column's value from a given id number in pandas DataFrame?

2 Answers2