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