I have two files
TF gene interaction AATF BAK1 Unknown AATF BAX Repression AATF MYC Activation
TF gene KAT5 KLRC4-KLRK1 EGF ABCB6 ETS1 CDKN2A
how I can extract the small file from the bigger one that contains interaction types???
I tried join, intersect, match but I can only do for gene or TF not for both simultaneously
by the below code only TFs are common between two files
df3 <- merge( dat1, dat2, by.x = "TF", by.y = "gene" )