I'm having trouble with merging two datasets in R. The first part is not giving any problems, but in the second part I get an error that a uniquely valid column must be specified. It is actually an existing column, so I don't understand why it is not valid. Does anyone have a clue?
# Data merge and save for further processing > df1<- as.data.frame(mynormGSE117852) > df2<- as.data.frame(mynormSPN) > merged_panNET_SPN<- merge(df1, df2, by.x="row.names", by.y="row.names") > rownames(merged_panNET_SPN) <- merged_panNET_SPN[,1] > merged_panNET_SPN[,1] <- NULL
> tmerged_panNET_SPN<-as.data.frame(t(merged_panNET_SPN)) > annoGEO<- merge(PD_panNET_SPN[,c(1,3)], tmerged_panNET_SPN, by.x="Sample_Name", by.y="row.names", sort = FALSE) Error in fix.by(by.x, x) : 'by' must specify a uniquely valid column