Python Pandas: How to retrieve row index of multiple values

Question

I would like to get the row index of the row that contains certain values(more than one).

I have tried put the values that I would like to retrieve in a list but failed, I can only search the index one by one which is quite tedious.

Possible but tedious

rows.loc[rows['NO']=='NO'].index.values
rows.loc[rows['NO']=='Sub Total :'].index.values
rows.loc[rows['NO']=='Generated By:'].index.values
rows.loc[rows['NO']=='Product :'].index.values

Failed

rows.loc[rows['NO']==list1].index.values

Parthasarathy Subburaj · Accepted Answer · 2019-07-04 07:24:40Z

1

Try this

rows.loc[rows['NO'].isin(list1)].index.values

answered Jul 4, 2019 at 7:24

Parthasarathy Subburaj

4,2842 gold badges12 silver badges25 bronze badges

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

Comments

Space Impact · Accepted Answer · 2019-07-04 07:24:54Z

1

Use str.contains as:

l = ['NO','Sub Total :', 'Generated By:', 'Product :']
index = rows.loc[rows['NO'].str.contains('|'.join(l)), 'NO'].index.values

answered Jul 4, 2019 at 7:24

Space Impact

13.3k26 silver badges51 bronze badges

Collectives™ on Stack Overflow

Python Pandas: How to retrieve row index of multiple values

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related