install.packages("readxl")
library("readxl")
setwd("C:/Users/Pablo/Desktop/BioinfoProject")

sample_gene <- read_excel("Study Results.xlsx",sheet = 1)
factors <- read_excel("Study Results.xlsx",sheet = 2)
factors[names(factors)[1:4]]

 
merging = merge(x = sample_gene, y = factors, by = 'sampleID')



merging