Get index and column name for a particular value in Pandas Dataframe

Question

I have the following Pandas DataFrame:

                             A                                        B
0                     Exporter                       Invoice No. & Date
1                 ABC PVT LTD.        ABC/1234/2022-23 DATED 20/08/2022
2                 1234/B, XYZ,
3           ABCD, DELHI, INDIA               Proforma Invoice No. Date.
4                                    AB/CDE/FGH/2022-23/1234 20.08.2022
5                    Consignee          Buyer (If other than consignee)
6                      ABC Co.
8            P.O BOX NO. 54321
9              Berlin, Germany

Now I want to search for a value in this DataFrame, and store the index and column name in 2 different variables.

For example:
If I search "Consignee", I should get

index = 5
column = 'A'

mozway · Accepted Answer · 2022-08-20 12:10:17Z

5

Assuming you really want the index/column of the match, you can use a mask and stack:

df.where(df.eq('Consignee')).stack()

output:

5  A    Consignee
dtype: object

As list:

df.where(df.eq('Consignee')).stack().index.tolist()

output: [(5, 'A')]

answered Aug 20, 2022 at 12:10

mozway

267k13 gold badges56 silver badges106 bronze badges

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

1 Comment

Divyansh Gemini Over a year ago

Thanks, I will get index and column name using result[0][0] and result[0][1].

Collectives™ on Stack Overflow

Get index and column name for a particular value in Pandas Dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related