title: Keep and label rows after joining dplyr
body: <p>I have two dataframe which I want to join normally i do <code>inner_join</code> which gives only the one which are present in both dataframe and rest and not shown in my output.</p>
  <p>How to do innerjoin and keep all the rows and assign label</p>
  <p>First dataframe</p>
  <pre><code>dput(head(EF_TF_region_expression))
  structure(list(ENSEMBL = structure(c(1L, 2L, 3L, 3L, 4L, 5L), .Label = c(&quot;ENSG00000006468&quot;, 
  &quot;ENSG00000030419&quot;, &quot;ENSG00000057657&quot;, &quot;ENSG00000068305&quot;, &quot;ENSG00000068903&quot;, 
  &quot;ENSG00000082014&quot;, &quot;ENSG00000085276&quot;, &quot;ENSG00000091831&quot;, &quot;ENSG00000100298&quot;, 
  &quot;ENSG00000102349&quot;, &quot;ENSG00000102554&quot;, &quot;ENSG00000102935&quot;, &quot;ENSG00000105991&quot;, 
  &quot;ENSG00000107485&quot;, &quot;ENSG00000109906&quot;, &quot;ENSG00000112182&quot;, &quot;ENSG00000118922&quot;, 
  &quot;ENSG00000119508&quot;, &quot;ENSG00000121067&quot;, &quot;ENSG00000124203&quot;, &quot;ENSG00000124440&quot;, 
  &quot;ENSG00000124613&quot;, &quot;ENSG00000130382&quot;, &quot;ENSG00000136770&quot;, &quot;ENSG00000138738&quot;, 
  &quot;ENSG00000140009&quot;, &quot;ENSG00000140968&quot;, &quot;ENSG00000143499&quot;, &quot;ENSG00000146285&quot;, 
  &quot;ENSG00000146592&quot;, &quot;ENSG00000147862&quot;, &quot;ENSG00000148143&quot;, &quot;ENSG00000150907&quot;, 
  &quot;ENSG00000151090&quot;, &quot;ENSG00000151322&quot;, &quot;ENSG00000151623&quot;, &quot;ENSG00000152217&quot;, 
  &quot;ENSG00000159882&quot;, &quot;ENSG00000160321&quot;, &quot;ENSG00000162367&quot;, &quot;ENSG00000162599&quot;, 
  &quot;ENSG00000162772&quot;, &quot;ENSG00000164105&quot;, &quot;ENSG00000164684&quot;, &quot;ENSG00000167034&quot;, 
  &quot;ENSG00000167081&quot;, &quot;ENSG00000171316&quot;, &quot;ENSG00000173258&quot;, &quot;ENSG00000174306&quot;, 
  &quot;ENSG00000176399&quot;, &quot;ENSG00000176842&quot;, &quot;ENSG00000177508&quot;, &quot;ENSG00000177606&quot;, 
  &quot;ENSG00000177946&quot;, &quot;ENSG00000178028&quot;, &quot;ENSG00000178175&quot;, &quot;ENSG00000178187&quot;, 
  &quot;ENSG00000178573&quot;, &quot;ENSG00000181690&quot;, &quot;ENSG00000182348&quot;, &quot;ENSG00000185155&quot;, 
  &quot;ENSG00000185420&quot;, &quot;ENSG00000185630&quot;, &quot;ENSG00000186350&quot;, &quot;ENSG00000186766&quot;, 
  &quot;ENSG00000187098&quot;, &quot;ENSG00000189190&quot;, &quot;ENSG00000196498&quot;, &quot;ENSG00000197343&quot;, 
  &quot;ENSG00000197576&quot;, &quot;ENSG00000198300&quot;, &quot;ENSG00000213341&quot;, &quot;ENSG00000213793&quot;, 
  &quot;ENSG00000213973&quot;, &quot;ENSG00000269067&quot;), class = &quot;factor&quot;), Symbol = structure(c(13L, 
  20L, 45L, 45L, 30L, 51L), .Label = c(&quot;APOBEC3H&quot;, &quot;ATF3&quot;, &quot;BACH2&quot;, 
  &quot;CENPBD1&quot;, &quot;CHD7&quot;, &quot;CHUK&quot;, &quot;CREB5&quot;, &quot;DMAP1&quot;, &quot;DMRTA1&quot;, &quot;DNAJC1&quot;, 
  &quot;ESR1&quot;, &quot;ESR2&quot;, &quot;ETV1&quot;, &quot;FOXI2&quot;, &quot;FOXO1&quot;, &quot;GATA3&quot;, &quot;HIF3A&quot;, &quot;HOXA1&quot;, 
  &quot;HOXA4&quot;, &quot;IKZF2&quot;, &quot;IRF8&quot;, &quot;IRX3&quot;, &quot;IRX5&quot;, &quot;JUN&quot;, &quot;KLF12&quot;, &quot;KLF5&quot;, 
  &quot;KLF8&quot;, &quot;MAF&quot;, &quot;MECOM&quot;, &quot;MEF2A&quot;, &quot;MITF&quot;, &quot;MIXL1&quot;, &quot;MLLT1&quot;, &quot;NCOR2&quot;, 
  &quot;NFIA&quot;, &quot;NFIB&quot;, &quot;NKX3-1&quot;, &quot;NPAS3&quot;, &quot;NR3C2&quot;, &quot;NR4A3&quot;, &quot;PBX1&quot;, 
  &quot;PBX3&quot;, &quot;PEG3&quot;, &quot;PLAG1&quot;, &quot;PRDM1&quot;, &quot;PRDM5&quot;, &quot;RXRA&quot;, &quot;SAP30&quot;, &quot;SCML4&quot;, 
  &quot;SETBP1&quot;, &quot;SIRT2&quot;, &quot;SMARCD3&quot;, &quot;SMYD2&quot;, &quot;SMYD3&quot;, &quot;SPOP&quot;, &quot;TAL1&quot;, 
  &quot;THRB&quot;, &quot;ZBTB16&quot;, &quot;ZHX3&quot;, &quot;ZNF208&quot;, &quot;ZNF230&quot;, &quot;ZNF366&quot;, &quot;ZNF391&quot;, 
  &quot;ZNF423&quot;, &quot;ZNF454&quot;, &quot;ZNF462&quot;, &quot;ZNF483&quot;, &quot;ZNF600&quot;, &quot;ZNF655&quot;, &quot;ZNF704&quot;, 
  &quot;ZNF728&quot;, &quot;ZNF804B&quot;, &quot;ZNF831&quot;, &quot;ZNF888&quot;, &quot;ZNF99&quot;), class = &quot;factor&quot;), 
      gene = structure(c(1L, 1L, 2L, 2L, 2L, 1L), .Label = c(&quot;gene_down&quot;, 
      &quot;gene_UP&quot;), class = &quot;factor&quot;), Region = structure(c(1L, 1L, 
      2L, 2L, 2L, 1L), .Label = c(&quot;Region_down&quot;, &quot;Region_UP&quot;), class = &quot;factor&quot;), 
      log2FoldChange_gene = c(-6.14406801102623, -2.6627775459419, 
      3.88870894117496, 3.88870894117496, 1.99677979125181, -1.97211419094463
      ), Peak_Region = structure(c(22L, 1L, 19L, 19L, 57L, 70L), .Label = c(&quot;Peak116875&quot;, 
      &quot;Peak122965&quot;, &quot;Peak124509&quot;, &quot;Peak12882&quot;, &quot;Peak129965&quot;, &quot;Peak133291&quot;, 
      &quot;Peak137285&quot;, &quot;Peak144690&quot;, &quot;Peak156227&quot;, &quot;Peak158090&quot;, &quot;Peak159944&quot;, 
      &quot;Peak165589&quot;, &quot;Peak17226&quot;, &quot;Peak17361&quot;, &quot;Peak174329&quot;, &quot;Peak177429&quot;, 
      &quot;Peak182129&quot;, &quot;Peak18278&quot;, &quot;Peak182835&quot;, &quot;Peak183059&quot;, &quot;Peak187290&quot;, 
      &quot;Peak190384&quot;, &quot;Peak191607&quot;, &quot;Peak191615&quot;, &quot;Peak191784&quot;, &quot;Peak196275&quot;, 
      &quot;Peak197134&quot;, &quot;Peak20062&quot;, &quot;Peak201433&quot;, &quot;Peak204083&quot;, &quot;Peak206496&quot;, 
      &quot;Peak206939&quot;, &quot;Peak208441&quot;, &quot;Peak21185&quot;, &quot;Peak215070&quot;, &quot;Peak215745&quot;, 
      &quot;Peak219884&quot;, &quot;Peak220299&quot;, &quot;Peak220725&quot;, &quot;Peak221948&quot;, &quot;Peak222959&quot;, 
      &quot;Peak22385&quot;, &quot;Peak226499&quot;, &quot;Peak28743&quot;, &quot;Peak30996&quot;, &quot;Peak40815&quot;, 
      &quot;Peak4292&quot;, &quot;Peak4601&quot;, &quot;Peak53449&quot;, &quot;Peak5453&quot;, &quot;Peak56079&quot;, 
      &quot;Peak5702&quot;, &quot;Peak58241&quot;, &quot;Peak58295&quot;, &quot;Peak62243&quot;, &quot;Peak64400&quot;, 
      &quot;Peak74210&quot;, &quot;Peak77556&quot;, &quot;Peak77907&quot;, &quot;Peak77943&quot;, &quot;Peak79841&quot;, 
      &quot;Peak80519&quot;, &quot;Peak81090&quot;, &quot;Peak85355&quot;, &quot;Peak91665&quot;, &quot;Peak95258&quot;, 
      &quot;Peak96987&quot;, &quot;Peak97000&quot;, &quot;Peak97004&quot;, &quot;Peak97803&quot;, &quot;Peak98350&quot;, 
      &quot;Peak98598&quot;, &quot;Peak99349&quot;, &quot;Peak99355&quot;, &quot;Peak99674&quot;), class = &quot;factor&quot;), 
      log2FoldChange_Region = c(-6.34669248759273, -3.48228412439449, 
      2.00811698735437, 2.00811698735437, 2.43720241001405, -2.43644562364537
      ), Family = structure(c(2L, 2L, 1L, 2L, 2L, 1L), .Label = c(&quot;EF&quot;, 
      &quot;TF&quot;), class = &quot;factor&quot;)), row.names = c(NA, 6L), class = &quot;data.frame&quot;)
  </code></pre>
  <p>My second dataframe that contains information which i want to map if the genes which are all related to haematopoesis.</p>
  <pre><code>dput(head(haematopoetic_genes))
  structure(list(Rank = 1:6, Symbol = structure(c(134L, 209L, 138L, 
  716L, 162L, 531L), .Label = c(&quot;18S_RRNA&quot;, &quot;ABCA1&quot;, &quot;ABCB1&quot;, &quot;ABCG1&quot;, 
  &quot;ABCG2&quot;, &quot;ABL1&quot;, &quot;ACAN&quot;, &quot;ACE&quot;, &quot;ACHE&quot;, &quot;ACKR2&quot;, &quot;ACP5&quot;, &quot;ACTG1&quot;, 
  &quot;ADA&quot;, &quot;ADAMTS13&quot;, &quot;ADIPOQ&quot;, &quot;ADRB2&quot;, &quot;AFDN&quot;, &quot;AFF1&quot;, &quot;AFP&quot;, 
  &quot;AGO2&quot;, &quot;AICDA&quot;, &quot;AIF1&quot;, &quot;AIRE&quot;, &quot;AKT1&quot;, &quot;ALB&quot;, &quot;ALCAM&quot;, &quot;ALDH1A1&quot;, 
  &quot;ALK&quot;, &quot;AMBP&quot;, &quot;ANGPT1&quot;, &quot;ANGPT2&quot;, &quot;ANGPTL5&quot;, &quot;ANPEP&quot;, &quot;ANXA2&quot;, 
  &quot;ANXA5&quot;, &quot;ANXA8&quot;, &quot;AOC3&quot;, &quot;APOA1&quot;, &quot;APOE&quot;, &quot;APP&quot;, &quot;AR&quot;, &quot;ARG1&quot;, 
  &quot;ARG2&quot;, &quot;ARID3A&quot;, &quot;ASXL1&quot;, &quot;ATG5&quot;, &quot;ATG7&quot;, &quot;ATM&quot;, &quot;ATP12A&quot;, &quot;ATP4A&quot;, 
  &quot;AURKA&quot;, &quot;AXIN1&quot;, &quot;AXIN2&quot;, &quot;AXL&quot;, &quot;B3GAT1&quot;, &quot;BANF1&quot;, &quot;BCL11A&quot;, 
  &quot;BCL11B&quot;, &quot;BCL2A1&quot;, &quot;BCL2L1&quot;, &quot;BCL2L11&quot;, &quot;BCL6&quot;, &quot;BCR&quot;, &quot;BDNF&quot;, 
  &quot;BECN1&quot;, &quot;BGLAP&quot;, &quot;BLNK&quot;, &quot;BMI1&quot;, &quot;BMP2&quot;, &quot;BMP4&quot;, &quot;BMP6&quot;, &quot;BMP7&quot;, 
  &quot;BRCA1&quot;, &quot;BRCA2&quot;, &quot;BRD4&quot;, &quot;BTK&quot;, &quot;C3&quot;, &quot;CALCA&quot;, &quot;CALR&quot;, &quot;CASP1&quot;, 
  &quot;CASP3&quot;, &quot;CASP8&quot;, &quot;CASP9&quot;, &quot;CBFA2T3&quot;, &quot;CBL&quot;, &quot;CCL11&quot;, &quot;CCL17&quot;, 
  &quot;CCL19&quot;, &quot;CCL2&quot;, &quot;CCL20&quot;, &quot;CCL21&quot;, &quot;CCL25&quot;, &quot;CCL27&quot;, &quot;CCL3&quot;, 
  &quot;CCL4&quot;, &quot;CCL4L2&quot;, &quot;CCL5&quot;, &quot;CCL7&quot;, &quot;CCN2&quot;, &quot;CCNA2&quot;, &quot;CCNB1&quot;, &quot;CCND1&quot;, 
  &quot;CCND2&quot;, &quot;CCND3&quot;, &quot;CCR1&quot;, &quot;CCR2&quot;, &quot;CCR3&quot;, &quot;CCR5&quot;, &quot;CCR6&quot;, &quot;CCR7&quot;, 
  &quot;CCR9&quot;, &quot;CCRL2&quot;, &quot;CD163&quot;, &quot;CD164&quot;, &quot;CD19&quot;, &quot;CD1A&quot;, &quot;CD1B&quot;, &quot;CD1C&quot;, 
  &quot;CD1D&quot;, &quot;CD1E&quot;, &quot;CD2&quot;, &quot;CD200&quot;, &quot;CD207&quot;, &quot;CD22&quot;, &quot;CD226&quot;, &quot;CD24&quot;, 
  &quot;CD244&quot;, &quot;CD247&quot;, &quot;CD27&quot;, &quot;CD274&quot;, &quot;CD276&quot;, &quot;CD28&quot;, &quot;CD33&quot;, &quot;CD34&quot;, 
  &quot;CD38&quot;, &quot;CD3D&quot;, &quot;CD3E&quot;, &quot;CD4&quot;, &quot;CD40&quot;, &quot;CD40LG&quot;, &quot;CD44&quot;, &quot;CD47&quot;, 
  &quot;CD48&quot;, &quot;CD5&quot;, &quot;CD52&quot;, &quot;CD55&quot;, &quot;CD58&quot;, &quot;CD59&quot;, &quot;CD6&quot;, &quot;CD63&quot;, 
  &quot;CD68&quot;, &quot;CD69&quot;, &quot;CD7&quot;, &quot;CD70&quot;, &quot;CD74&quot;, &quot;CD79A&quot;, &quot;CD79B&quot;, &quot;CD80&quot;, 
  &quot;CD81&quot;, &quot;CD83&quot;, &quot;CD86&quot;, &quot;CD8A&quot;, &quot;CD9&quot;, &quot;CD93&quot;, &quot;CD96&quot;, &quot;CDC42&quot;, 
  &quot;CDH1&quot;, &quot;CDH17&quot;, &quot;CDH2&quot;, &quot;CDH5&quot;, &quot;CDK1&quot;, &quot;CDK2&quot;, &quot;CDK4&quot;, &quot;CDK6&quot;, 
  &quot;CDKN1A&quot;, &quot;CDKN1B&quot;, &quot;CDKN1C&quot;, &quot;CDKN2A&quot;, &quot;CDKN2B&quot;, &quot;CDKN2C&quot;, &quot;CDKN3&quot;, 
  &quot;CDX4&quot;, &quot;CEACAM8&quot;, &quot;CEBPA&quot;, &quot;CEBPB&quot;, &quot;CEBPE&quot;, &quot;CFLAR&quot;, &quot;CHEK1&quot;, 
  &quot;CHEK2&quot;, &quot;CISH&quot;, &quot;CLEC11A&quot;, &quot;CLEC12A&quot;, &quot;CLEC4C&quot;, &quot;CLEC7A&quot;, &quot;COL1A1&quot;, 
  &quot;COLEC10&quot;, &quot;COMMD3-BMI1&quot;, &quot;CR2&quot;, &quot;CREB1&quot;, &quot;CREBBP&quot;, &quot;CRKL&quot;, &quot;CRP&quot;, 
  &quot;CRYGC&quot;, &quot;CSF1&quot;, &quot;CSF1R&quot;, &quot;CSF2&quot;, &quot;CSF2RA&quot;, &quot;CSF2RB&quot;, &quot;CSF3&quot;, 
  &quot;CSF3R&quot;, &quot;CTCF&quot;, &quot;CTNNB1&quot;, &quot;CTRL&quot;, &quot;CTSG&quot;, &quot;CTSK&quot;, &quot;CX3CL1&quot;, 
  &quot;CX3CR1&quot;, &quot;CXCL1&quot;, &quot;CXCL10&quot;, &quot;CXCL11&quot;, &quot;CXCL12&quot;, &quot;CXCL13&quot;, &quot;CXCL2&quot;, 
  &quot;CXCL5&quot;, &quot;CXCL8&quot;, &quot;CXCL9&quot;, &quot;CXCR1&quot;, &quot;CXCR2&quot;, &quot;CXCR3&quot;, &quot;CXCR4&quot;, 
  &quot;CXCR5&quot;, &quot;CYBB&quot;, &quot;CYCS&quot;, &quot;CYGB&quot;, &quot;CYP3A4&quot;, &quot;DCLRE1C&quot;, &quot;DDX58&quot;, 
  &quot;DHFR&quot;, &quot;DICER1&quot;, &quot;DKC1&quot;, &quot;DKK1&quot;, &quot;DLK1&quot;, &quot;DLL1&quot;, &quot;DLL4&quot;, &quot;DNMT1&quot;, 
  &quot;DNMT3A&quot;, &quot;DNMT3B&quot;, &quot;DNTT&quot;, &quot;DOCK8&quot;, &quot;DOT1L&quot;, &quot;DPP4&quot;, &quot;DROSHA&quot;, 
  &quot;DTX1&quot;, &quot;EBF1&quot;, &quot;EDN1&quot;, &quot;EGF&quot;, &quot;EGFR&quot;, &quot;EGR1&quot;, &quot;EGR2&quot;, &quot;EIF2AK3&quot;, 
  &quot;EIF4EBP1&quot;, &quot;ELANE&quot;, &quot;ELN&quot;, &quot;EMCN&quot;, &quot;ENG&quot;, &quot;ENO2&quot;, &quot;ENSP00000204615&quot;, 
  &quot;ENSP00000217964&quot;, &quot;ENSP00000228280&quot;, &quot;ENSP00000245323&quot;, &quot;ENSP00000268035&quot;, 
  &quot;ENSP00000277541&quot;, &quot;ENSP00000282030&quot;, &quot;ENSP00000303939&quot;, &quot;ENSP00000332369&quot;, 
  &quot;ENSP00000344192&quot;, &quot;ENSP00000349960&quot;, &quot;ENSP00000350052&quot;, &quot;ENSP00000352561&quot;, 
  &quot;ENSP00000356946&quot;, &quot;ENSP00000387760&quot;, &quot;ENSP00000433642&quot;, &quot;ENSP00000444986&quot;, 
  &quot;ENSP00000452780&quot;, &quot;ENSP00000478570&quot;, &quot;ENSP00000479618&quot;, &quot;ENSP00000480609&quot;, 
  &quot;ENTPD1&quot;, &quot;EOMES&quot;, &quot;EP300&quot;, &quot;EPB41&quot;, &quot;EPCAM&quot;, &quot;EPO&quot;, &quot;EPOR&quot;, 
  &quot;ERBB2&quot;, &quot;ERVW-1&quot;, &quot;ESAM&quot;, &quot;ESR1&quot;, &quot;ETS1&quot;, &quot;ETS2&quot;, &quot;ETV2&quot;, &quot;ETV6&quot;, 
  &quot;EVPL&quot;, &quot;EZH2&quot;, &quot;F2&quot;, &quot;F3&quot;, &quot;FABP4&quot;, &quot;FANCA&quot;, &quot;FANCC&quot;, &quot;FANCD2&quot;, 
  &quot;FANCG&quot;, &quot;FAS&quot;, &quot;FASLG&quot;, &quot;FBXW7&quot;, &quot;FCGR1A&quot;, &quot;FCGR2A&quot;, &quot;FCGR2B&quot;, 
  &quot;FER&quot;, &quot;FGF1&quot;, &quot;FGF13&quot;, &quot;FGF2&quot;, &quot;FGF4&quot;, &quot;FGF7&quot;, &quot;FGFR1&quot;, &quot;FLT1&quot;, 
  &quot;FLT3&quot;, &quot;FLT3LG&quot;, &quot;FLT4&quot;, &quot;FN1&quot;, &quot;FOS&quot;, &quot;FOSB&quot;, &quot;FOXA2&quot;, &quot;FOXN1&quot;, 
  &quot;FOXO1&quot;, &quot;FOXO3&quot;, &quot;FOXO4&quot;, &quot;FOXP3&quot;, &quot;FUT4&quot;, &quot;FYN&quot;, &quot;GADD45A&quot;, 
  &quot;GAPDH&quot;, &quot;GAS6&quot;, &quot;GATA1&quot;, &quot;GATA2&quot;, &quot;GATA3&quot;, &quot;GATA4&quot;, &quot;GCG&quot;, &quot;GDNF&quot;, 
  &quot;GFAP&quot;, &quot;GFI1&quot;, &quot;GFI1B&quot;, &quot;GJA1&quot;, &quot;GLI1&quot;, &quot;GLI3&quot;, &quot;GP1BA&quot;, &quot;GP9&quot;, 
  &quot;GPT&quot;, &quot;GRB2&quot;, &quot;GSTM1&quot;, &quot;GUSB&quot;, &quot;GYPA&quot;, &quot;GYPC&quot;, &quot;GZMB&quot;, &quot;H2AC18&quot;, 
  &quot;H2AC19&quot;, &quot;H2AC20&quot;, &quot;H2AX&quot;, &quot;H2BC21&quot;, &quot;H3-2&quot;, &quot;H4-16&quot;, &quot;H4C1&quot;, 
  &quot;H4C11&quot;, &quot;H4C12&quot;, &quot;H4C13&quot;, &quot;H4C14&quot;, &quot;H4C15&quot;, &quot;H4C2&quot;, &quot;H4C3&quot;, 
  &quot;H4C4&quot;, &quot;H4C5&quot;, &quot;H4C6&quot;, &quot;H4C8&quot;, &quot;H4C9&quot;, &quot;HAMP&quot;, &quot;HAVCR2&quot;, &quot;HBB&quot;, 
  &quot;HBE1&quot;, &quot;HBEGF&quot;, &quot;HBZ&quot;, &quot;HDAC1&quot;, &quot;HDAC2&quot;, &quot;HEY1&quot;, &quot;HEY2&quot;, &quot;HGF&quot;, 
  &quot;HHEX&quot;, &quot;HIF1A&quot;, &quot;HLA-A&quot;, &quot;HLA-B&quot;, &quot;HLA-C&quot;, &quot;HLA-DPB1&quot;, &quot;HLA-DQA1&quot;, 
  &quot;HLA-DQB1&quot;, &quot;HLA-DRB1&quot;, &quot;HLA-E&quot;, &quot;HLA-G&quot;, &quot;HMGA2&quot;, &quot;HMGB1&quot;, &quot;HMOX1&quot;, 
  &quot;HNF4A&quot;, &quot;HOXA10&quot;, &quot;HOXA3&quot;, &quot;HOXA5&quot;, &quot;HOXA7&quot;, &quot;HOXA9&quot;, &quot;HOXB3&quot;, 
  &quot;HOXB4&quot;, &quot;HOXB5&quot;, &quot;HOXB6&quot;, &quot;HOXB8&quot;, &quot;HP&quot;, &quot;HPGDS&quot;, &quot;HPRT1&quot;, &quot;HRAS&quot;, 
  &quot;HSA-MIR-125B-5P&quot;, &quot;HSA-MIR-126-3P&quot;, &quot;HSA-MIR-142-3P&quot;, &quot;HSA-MIR-146A-5P&quot;, 
  &quot;HSA-MIR-150-5P&quot;, &quot;HSA-MIR-155-5P&quot;, &quot;HSA-MIR-17-5P&quot;, &quot;HSA-MIR-181A-5P&quot;, 
  &quot;HSA-MIR-21-5P&quot;, &quot;HSA-MIR-221-3P&quot;, &quot;HSA-MIR-223-3P&quot;, &quot;HSA-MIR-29A-3P&quot;, 
  &quot;HSA-MIR-34A-5P&quot;, &quot;HSP90AA1&quot;, &quot;HSPA4&quot;, &quot;IBSP&quot;, &quot;ICAM1&quot;, &quot;ICAM4&quot;, 
  &quot;ID1&quot;, &quot;ID2&quot;, &quot;ID3&quot;, &quot;IDH1&quot;, &quot;IDH2&quot;, &quot;IDO1&quot;, &quot;IDUA&quot;, &quot;IFNA1&quot;, 
  &quot;IFNA2&quot;, &quot;IFNAR1&quot;, &quot;IFNB1&quot;, &quot;IFNG&quot;, &quot;IGF1&quot;, &quot;IGF2&quot;, &quot;IGFBP2&quot;, 
  &quot;IGFBP3&quot;, &quot;IGLL1&quot;, &quot;IGLL5&quot;, &quot;IHH&quot;, &quot;IKBKB&quot;, &quot;IKBKG&quot;, &quot;IKZF1&quot;, 
  &quot;IKZF2&quot;, &quot;IKZF3&quot;, &quot;IL10&quot;, &quot;IL10RA&quot;, &quot;IL11&quot;, &quot;IL13&quot;, &quot;IL15&quot;, &quot;IL17F&quot;, 
  &quot;IL18&quot;, &quot;IL1A&quot;, &quot;IL1B&quot;, &quot;IL1R1&quot;, &quot;IL2&quot;, &quot;IL22&quot;, &quot;IL2RA&quot;, &quot;IL2RB&quot;, 
  &quot;IL2RG&quot;, &quot;IL3&quot;, &quot;IL33&quot;, &quot;IL3RA&quot;, &quot;IL4&quot;, &quot;IL5&quot;, &quot;IL6&quot;, &quot;IL6R&quot;, 
  &quot;IL7&quot;, &quot;IL7R&quot;, &quot;IL9&quot;, &quot;INS&quot;, &quot;IRAK1&quot;, &quot;IRF1&quot;, &quot;IRF2&quot;, &quot;IRF4&quot;, 
  &quot;IRF7&quot;, &quot;IRF8&quot;, &quot;IRS1&quot;, &quot;ITGA2&quot;, &quot;ITGA2B&quot;, &quot;ITGA4&quot;, &quot;ITGA5&quot;, 
  &quot;ITGA6&quot;, &quot;ITGAE&quot;, &quot;ITGAL&quot;, &quot;ITGAM&quot;, &quot;ITGAV&quot;, &quot;ITGAX&quot;, &quot;ITGB1&quot;, 
  &quot;ITGB2&quot;, &quot;ITGB3&quot;, &quot;ITIH4&quot;, &quot;ITK&quot;, &quot;JAG1&quot;, &quot;JAG2&quot;, &quot;JAK1&quot;, &quot;JAK2&quot;, 
  &quot;JAK3&quot;, &quot;JUN&quot;, &quot;KAT6A&quot;, &quot;KCNN3&quot;, &quot;KDM1A&quot;, &quot;KDM6A&quot;, &quot;KDR&quot;, &quot;KIR2DL1&quot;, 
  &quot;KIR2DL3&quot;, &quot;KIR2DL4&quot;, &quot;KIR3DL1&quot;, &quot;KIR3DL2&quot;, &quot;KIR3DL3&quot;, &quot;KIT&quot;, 
  &quot;KLF1&quot;, &quot;KLF2&quot;, &quot;KLF4&quot;, &quot;KLRB1&quot;, &quot;KLRC1&quot;, &quot;KLRC2&quot;, &quot;KLRD1&quot;, &quot;KLRG1&quot;, 
  &quot;KLRK1&quot;, &quot;KMT2A&quot;, &quot;KRAS&quot;, &quot;KRT14&quot;, &quot;KRT18&quot;, &quot;KRT19&quot;, &quot;KRT5&quot;, 
  &quot;KRT8&quot;, &quot;LAG3&quot;, &quot;LAMP1&quot;, &quot;LCK&quot;, &quot;LCN2&quot;, &quot;LCP2&quot;, &quot;LDB1&quot;, &quot;LDB2&quot;, 
  &quot;LEF1&quot;, &quot;LEP&quot;, &quot;LEPR&quot;, &quot;LGALS3&quot;, &quot;LGALS4&quot;, &quot;LGR5&quot;, &quot;LIF&quot;, &quot;LIG4&quot;, 
  &quot;LILRB1&quot;, &quot;LIN28A&quot;, &quot;LIN28B&quot;, &quot;LMNA&quot;, &quot;LMO2&quot;, &quot;LOX&quot;, &quot;LRP5&quot;, 
  &quot;LTA&quot;, &quot;LY75&quot;, &quot;LY9&quot;, &quot;LYL1&quot;, &quot;LYN&quot;, &quot;LYVE1&quot;, &quot;MAF&quot;, &quot;MAGEA3&quot;, 
  &quot;MAP2K1&quot;, &quot;MAP2K7&quot;, &quot;MAPK1&quot;, &quot;MAPK14&quot;, &quot;MAPK3&quot;, &quot;MAPK8&quot;, &quot;MATK&quot;, 
  &quot;MBP&quot;, &quot;MCAM&quot;, &quot;MCL1&quot;, &quot;MDM2&quot;, &quot;MECOM&quot;, &quot;MEF2C&quot;, &quot;MEIS1&quot;, &quot;MET&quot;, 
  &quot;MGMT&quot;, &quot;MICA&quot;, &quot;MIR17HG&quot;, &quot;MIXL1&quot;, &quot;MLLT1&quot;, &quot;MLLT10&quot;, &quot;MLLT3&quot;, 
  &quot;MME&quot;, &quot;MMP2&quot;, &quot;MMP3&quot;, &quot;MMP9&quot;, &quot;MOG&quot;, &quot;MPL&quot;, &quot;MPO&quot;, &quot;MPP3&quot;, &quot;MRC1&quot;, 
  &quot;MSI2&quot;, &quot;MTHFR&quot;, &quot;MTOR&quot;, &quot;MUC1&quot;, &quot;MX1&quot;, &quot;MYB&quot;, &quot;MYCN&quot;, &quot;MYD88&quot;, 
  &quot;MYH11&quot;, &quot;MYO1G&quot;, &quot;MYOD1&quot;, &quot;MYOM2&quot;, &quot;NAALADL1&quot;, &quot;NANOG&quot;, &quot;NCAM1&quot;, 
  &quot;NCF1&quot;, &quot;NCOR1&quot;, &quot;NCOR2&quot;, &quot;NCR1&quot;, &quot;NCR2&quot;, &quot;NCR3&quot;, &quot;NES&quot;, &quot;NF1&quot;, 
  &quot;NFATC1&quot;, &quot;NFE2&quot;, &quot;NFIL3&quot;, &quot;NFKB1&quot;, &quot;NFKBIA&quot;, &quot;NGF&quot;, &quot;NGFR&quot;, 
  &quot;NKX2-5&quot;, &quot;NLRP3&quot;, &quot;NOD2&quot;, &quot;NOG&quot;, &quot;NOS2&quot;, &quot;NOS3&quot;, &quot;NOTCH2&quot;, &quot;NOTCH3&quot;, 
  &quot;NOTCH4&quot;, &quot;NPM1&quot;, &quot;NR3C1&quot;, &quot;NR4A1&quot;, &quot;NRAS&quot;, &quot;NRP1&quot;, &quot;NT5E&quot;, &quot;NTRK1&quot;, 
  &quot;NUMB&quot;, &quot;NUP98&quot;, &quot;OSM&quot;, &quot;PARP1&quot;, &quot;PAX5&quot;, &quot;PAX6&quot;, &quot;PBX1&quot;, &quot;PCGF2&quot;, 
  &quot;PCSK5&quot;, &quot;PCSK7&quot;, &quot;PDCD1&quot;, &quot;PDCD1LG2&quot;, &quot;PDGFRA&quot;, &quot;PDGFRB&quot;, &quot;PDPN&quot;, 
  &quot;PECAM1&quot;, &quot;PF4&quot;, &quot;PGF&quot;, &quot;PGK1&quot;, &quot;PHF6&quot;, &quot;PI3&quot;, &quot;PIGA&quot;, &quot;PIK3R1&quot;, 
  &quot;PLAUR&quot;, &quot;PLCG1&quot;, &quot;PLCG2&quot;, &quot;PLEK&quot;, &quot;PLG&quot;, &quot;PLK1&quot;, &quot;PMAIP1&quot;, &quot;POMC&quot;, 
  &quot;POU5F1&quot;, &quot;PPARA&quot;, &quot;PPARG&quot;, &quot;PPARGC1A&quot;, &quot;PPBP&quot;, &quot;PPIG&quot;, &quot;PPP1R12C&quot;, 
  &quot;PRAME&quot;, &quot;PRDM1&quot;, &quot;PRDM16&quot;, &quot;PREB&quot;, &quot;PRF1&quot;, &quot;PRKCA&quot;, &quot;PRKDC&quot;, 
  &quot;PRL&quot;, &quot;PROCR&quot;, &quot;PROM1&quot;, &quot;PRTN3&quot;, &quot;PSMA7&quot;, &quot;PTCRA&quot;, &quot;PTEN&quot;, &quot;PTGER4&quot;, 
  &quot;PTGS2&quot;, &quot;PTH&quot;, &quot;PTHLH&quot;, &quot;PTK2&quot;, &quot;PTK2B&quot;, &quot;PTN&quot;, &quot;PTPN11&quot;, &quot;PTPN6&quot;, 
  &quot;PTPRC&quot;, &quot;QRSL1&quot;, &quot;RAC2&quot;, &quot;RAD21&quot;, &quot;RAD51&quot;, &quot;RAF1&quot;, &quot;RAG1&quot;, &quot;RAG2&quot;, 
  &quot;RARA&quot;, &quot;RBFOX3&quot;, &quot;RBPJ&quot;, &quot;REG3A&quot;, &quot;REL&quot;, &quot;RELA&quot;, &quot;RELB&quot;, &quot;REN&quot;, 
  &quot;RET&quot;, &quot;RGMA&quot;, &quot;RHOA&quot;, &quot;RICTOR&quot;, &quot;RORC&quot;, &quot;RPS14&quot;, &quot;RPS19&quot;, &quot;RPS6&quot;, 
  &quot;RPS6KB1&quot;, &quot;RPTOR&quot;, &quot;RUNX1&quot;, &quot;RUNX1T1&quot;, &quot;RUNX2&quot;, &quot;RUNX3&quot;, &quot;S1PR1&quot;, 
  &quot;SAA1&quot;, &quot;SALL4&quot;, &quot;SATB1&quot;, &quot;SBDS&quot;, &quot;SDC1&quot;, &quot;SDHC&quot;, &quot;SELE&quot;, &quot;SELL&quot;, 
  &quot;SELP&quot;, &quot;SELPLG&quot;, &quot;SERPINA1&quot;, &quot;SERPINC1&quot;, &quot;SERPINE1&quot;, &quot;SH2B3&quot;, 
  &quot;SHC1&quot;, &quot;SHH&quot;, &quot;SHMT2&quot;, &quot;SIGLEC1&quot;, &quot;SIRPA&quot;, &quot;SIRT1&quot;, &quot;SIRT3&quot;, 
  &quot;SIRT7&quot;, &quot;SLAMF1&quot;, &quot;SLC2A1&quot;, &quot;SMAD2&quot;, &quot;SMAD3&quot;, &quot;SMAD4&quot;, &quot;SMAD5&quot;, 
  &quot;SMAD7&quot;, &quot;SMARCA4&quot;, &quot;SNAI1&quot;, &quot;SNAI2&quot;, &quot;SOCS1&quot;, &quot;SOCS2&quot;, &quot;SOCS3&quot;, 
  &quot;SOD2&quot;, &quot;SOX17&quot;, &quot;SOX2&quot;, &quot;SOX4&quot;, &quot;SOX9&quot;, &quot;SP7&quot;, &quot;SPARC&quot;, &quot;SPI1&quot;, 
  &quot;SPIB&quot;, &quot;SPN&quot;, &quot;SPP1&quot;, &quot;SRC&quot;, &quot;SRSF2&quot;, &quot;STAG2&quot;, &quot;STAT1&quot;, &quot;STAT2&quot;, 
  &quot;STAT3&quot;, &quot;STAT5A&quot;, &quot;STAT5B&quot;, &quot;STAT6&quot;, &quot;STK11&quot;, &quot;STUB1&quot;, &quot;SUZ12&quot;, 
  &quot;SYK&quot;, &quot;TAC1&quot;, &quot;TAL1&quot;, &quot;TBP&quot;, &quot;TBX21&quot;, &quot;TCF12&quot;, &quot;TCF3&quot;, &quot;TCF4&quot;, 
  &quot;TCF7&quot;, &quot;TCHP&quot;, &quot;TEK&quot;, &quot;TERC&quot;, &quot;TERT&quot;, &quot;TET1&quot;, &quot;TET2&quot;, &quot;TFRC&quot;, 
  &quot;TGFB1&quot;, &quot;TGFB2&quot;, &quot;TGFB3&quot;, &quot;TGFBR1&quot;, &quot;TGFBR2&quot;, &quot;TH&quot;, &quot;THBD&quot;, 
  &quot;THBS1&quot;, &quot;THRA&quot;, &quot;THY1&quot;, &quot;TIE1&quot;, &quot;TIMP1&quot;, &quot;TJP1&quot;, &quot;TLR1&quot;, &quot;TLR2&quot;, 
  &quot;TLR3&quot;, &quot;TLR4&quot;, &quot;TLR5&quot;, &quot;TLR7&quot;, &quot;TLR8&quot;, &quot;TLR9&quot;, &quot;TLX1&quot;, &quot;TNF&quot;, 
  &quot;TNFRSF10A&quot;, &quot;TNFRSF10B&quot;, &quot;TNFRSF13C&quot;, &quot;TNFRSF18&quot;, &quot;TNFRSF1A&quot;, 
  &quot;TNFRSF1B&quot;, &quot;TNFRSF25&quot;, &quot;TNFRSF4&quot;, &quot;TNFRSF8&quot;, &quot;TNFRSF9&quot;, &quot;TNFSF10&quot;, 
  &quot;TNFSF11&quot;, &quot;TNFSF13B&quot;, &quot;TNFSF4&quot;, &quot;TNFSF9&quot;, &quot;TOP1&quot;, &quot;TP53&quot;, &quot;TP53BP1&quot;, 
  &quot;TRAF6&quot;, &quot;TRIM5&quot;, &quot;TSLP&quot;, &quot;TTR&quot;, &quot;TXN&quot;, &quot;TYK2&quot;, &quot;TYROBP&quot;, &quot;U2AF1&quot;, 
  &quot;U2AF1L4&quot;, &quot;U2AF1L5&quot;, &quot;UBC&quot;, &quot;UCHL1&quot;, &quot;UNC13D&quot;, &quot;VAV1&quot;, &quot;VCAM1&quot;, 
  &quot;VEGFC&quot;, &quot;VPREB1&quot;, &quot;VTN&quot;, &quot;VWF&quot;, &quot;WAS&quot;, &quot;WNT1&quot;, &quot;WNT10B&quot;, &quot;WNT16&quot;, 
  &quot;WNT3A&quot;, &quot;WNT4&quot;, &quot;WNT5A&quot;, &quot;WT1&quot;, &quot;XBP1&quot;, &quot;XIAP&quot;, &quot;XRCC5&quot;, &quot;XRCC6&quot;, 
  &quot;YY1&quot;, &quot;ZAP70&quot;, &quot;ZBTB16&quot;, &quot;ZBTB7B&quot;, &quot;ZEB1&quot;, &quot;ZFPM1&quot;, &quot;ZRSR2&quot;), class = &quot;factor&quot;), 
      Publication.count = c(18386L, 7830L, 6786L, 6590L, 6022L, 
      5610L), Fraction.of.publications.from.total.gene.publication = c(0.2923, 
      0.2598, 0.029, 0.1107, 0.0383, 0.1407)), row.names = c(NA, 
  6L), class = &quot;data.frame&quot;)
  </code></pre>
  <p>The dimension of my first dataframe</p>
  <pre><code>dim(EF_TF_region_expression)
  [1] 80  8
  </code></pre>
  <p>The dimension of my second dataframe</p>
  <pre><code>dim(haematopoetic_genes)
  [1] 899   4
  &gt; 
  </code></pre>
  <p>If i do an inner_join</p>
  <pre><code>haem_non_haem = inner_join(EF_TF_region_expression,haematopoetic_genes)
  </code></pre>
  <p>I get this dimension</p>
  <p>dim(haem_non_haem)
  [1] 17 11</p>
  <p>So here I loose rest of the rows which didn't map to my second dataframe. I would like to keep all the rows with some label such as <code>&quot;Non-haem&quot;</code></p>
  <p>I tried full_join</p>
  <pre><code>haem_non_haem1 = full_join(EF_TF_region_expression,haematopoetic_genes,by =&quot;Symbol&quot;)
  </code></pre>
  <p>My dimension is this</p>
  <p>dim(haem_non_haem1)
  [1] 964  11</p>
  <p>So here Im getting more rows from second dataframe which i dont want.</p>
  <p>The final output im expecting is I would keep all my 80 rows instead of 17 which are mapped and which are not mapped should be put some label</p>
  <pre><code>ENSEMBL Symbol      gene      Region log2FoldChange_gene Peak_Region log2FoldChange_Region Family
  1 ENSG00000030419  IKZF2 gene_down Region_down           -2.662778  Peak116875             -3.482284     TF
  2 ENSG00000057657  PRDM1   gene_UP   Region_UP            3.888709  Peak182835              2.008117     EF
  3 ENSG00000057657  PRDM1   gene_UP   Region_UP            3.888709  Peak182835              2.008117     TF
  4 ENSG00000085276  MECOM gene_down Region_down           -8.786649  Peak144690             -5.930731     TF
  5 ENSG00000091831   ESR1 gene_down Region_down           -1.884222  Peak187290             -2.431486     TF
  6 ENSG00000107485  GATA3 gene_down Region_down           -8.905856   Peak21185             -4.434688     TF
    Rank Publication.count Fraction.of.publications.from.total.gene.publication
  1  895                36                                               0.0845
  2  496               105                                               0.0266
  3  496               105                                               0.0266
  4  317               178                                               0.1803
  5  193               323                                               0.0049
  6  140               465                                               0.0404
  </code></pre>