get all combinations from within a variable and another

[Hossam]

Detect a repeating pattern in a dataframe that repeats 3 time or more across two columns

I have a data set that has 3 columns , (ID , D , AE). i want to retrieve records where any two values in column D are co-occurring with any value in Column AE 3 times or more sample=data.frame( ID=c(1,1,1,1,2,2,2,2,2,3,3,3,3,4,4,4,4,5,5,5), D=c('a','b','c','d','e','f','g','y','z','a','b','g','y','d','e','f','g','b','a','y'), AE=c('m','h','j','k','m','h','j','k','m','j','m','h','l','j','k','m','h','m','o','s') ) Created on 2020-09-19 by the reprex package (v0.3.0) so that the output will be something like that: output=data.frame(ID=c(1,1), D=c('a','b'), AE='m')

I would really appreciate if you helped me with this. i tried to keep it simple as possible