Here is my dataframe

 ID Tell Number 0 1 Yes 2 1 1 Yes 6 2 1 No 9 3 2 Yes 4 4 2 Ye 7 5 2 No 8 6 3 Ye 15 7 3 Yes 2 8 3 No 6 9 3 Yes 2 # Creating the dictionary dic = {'ID': [1,1,1,2,2,2,3,3,3,3], 'Tell': ['Yes', 'Yes', 'No', 'Yes','Ye', 'No','Ye', 'Yes','No', 'Yes'], 'Number': [3,6,9,4,7,8,15,8,6,13]} # Creating the dataframe df = pd.DataFrame(dic) 

I want my program to be able to remove every row from my dataframe if the number is higher then 6 and the Tell column is either Ye or Yes.

I want it to look like that:

 ID Tell Number 0 1 Yes 2 1 1 Yes 6 2 1 No 9 3 2 Yes 4 4 2 No 8 5 3 Yes 2 6 3 No 6 7 3 Yes 2