Entering edit mode
2.0 years ago
Negatyvna
•
0
hi all, I would like to ask if this is a good way to merge two databases into one?
library(TCGAbiolinks)
query1 <- GDCquery( project = "TCGA-COAD", data.category = "Simple Nucleotide Variation", data.type = "Masked Somatic Mutation", legacy=F)
muts <- GDCprepare(query1)
clin <- GDCquery_clinic("TCGA-COAD","clinical")
library(tidyverse) library(stringr)
muts$bcr_patient_barcode <- str_sub(muts$Tumor_Sample_Barcode, 1, 12)
mut2 <- left_join(muts, clin, by = c("bcr_patient_barcode"))
Thanks :)