0

I have this Dataframe:

          MNR      Price    LIMIT   LIMIT1
0      03M7401     49.76    0.0    1.0
1    LCA94237B     16.56    5.0    1.0
2    LCA94237B     55.68    1.0    1.0
3    LCA94237B      8.73   25.0    1.0
4  LCA95038B-1      2.33  100.0  100.0
5  LCA95038B-1      2.08  300.0  100.0
6  LCA95038B-1      2.71   50.0  100.0
7  LCA95038B-1      6.17    9.0  100.0 

So on the left site df['MNR'] is a Itemnumber.

As you can see I can sometimes LIMIT= LIMIT1. Can I use a filter to display only the item number where LIMIT = LIMIT1?

so i want to have this result at the end.

          MNR      Price    LIMIT   LIMIT1
0      03M7401     49.76    0.0    1.0
2    LCA94237B     55.68    1.0    1.0
4  LCA95038B-1      2.33  100.0  100.0

Or do you have other Ideas how i can do this?

Thanks

0 Answers0