[R] Dataframe Subsetting comparison

Neha Aggarwal aggarwalneha2000 at gmail.com
Mon Mar 12 02:03:59 CET 2018

Hello All,
I am facing a unique issue and am unable to find any help in R help pages
or online. I will appreciate your help for the following problem:
I have 2 data-frames, samples below and there is an expected output

R Dataframe1:
            C1              C2   C3         C4...... CN
R1       0                  1       0           1
R2        1                  0      1            1
R3        1                  0       0             0

U Dataframe2 :
             C1         C2        C3         C4...... CN
U1         1           1            0            1
U2         1           1             1            1

Expected Output:
U1 satisfies R1, R3
U2 satisfies R1, R2, R3

So this is a comparison of dataframes problem, with a subset dimension.
There are 2 dataframe R and U. column names are same. There are certain
columns belonging to each row in dataframe 1, denoted as 1s, while there
are certain cols to each U denoted as 1s in each URow in dataframe2.

I have to find relationships between Rs and Us. So i start with each U row
in U dataframe (lets say U1 row) and try to find all the rows in R
dataframe, which are subset of U1 row.

I cant find a way to compare rows to see if one is subset of
another....what can I try, any pointers/ packages will be great help.
Please help.


	[[alternative HTML version deleted]]

More information about the R-help mailing list