I'm trying to create a dataframe that contains "ligand-receptor" interaction relationship. I have this dataframe called "ligand.receptor" which looks like this:it shows what ligand will interact with what receptors. One ligand can potentially binds to multiple receptor. One receptor can potentially be recognized by multiple ligands consider this table as a template of ligand-receptor interaction.
There's another table (table2) that's called LR.Int (it has NA), and it looks like this: the first three column on the left represents cell types (lcell) and the ligand they express. The last three column on the right represents cell types (rcell) and the receptor they express
My actual question is how do I create a dataframe that matches the correct lcell (along with the ligand it expresses) with the correct rcell(along with the receptor it expresses) using the dataframe ligand.receptor as the matching template.
Thank you in advance for helping me out with this issue!