get all combinations from within a variable and another

[Hossam]

I want to transform the (3 columns)data set to the (12 columns) dataset.

I just wrote the counts that i need for the first combination of the first ID , however i need to produce these counts for the rest of combinations corresponding to their IDs.

Any help is much appreciated.

[martin.R]

One of these options should work:

Expand data frame to include all possible combinations of values — expand

[Hossam]

I tried , but it doesn't work. I need to make combination from within the first column and the second column (i.e each pair from the drug column with the the AE column).

[nirgrahamuk]

Hello,
I'm sure you shared this image with the best intentions, but perhaps you didnt realise what it implies.
If someone wished to use example data to test code against, they would type it out from your screenshot...

This is very unlikely to happen, and so it reduces the likelihood you will receive the help you desire.
Therefore please see this guide on how to reprex data. Key to this is use of either datapasta, or dput() to share your data as code

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

[Hossam]

Thanks , well noted. I have posted another Topic using reprex , as i realized that this question would produce a huge dataset that R will return an error upon trying to process it. The original dataset itself has more than 200000 record , so making all possible combinations would produce a dataset with more than 76 million record !! R session stopped working when i tried it !

[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