search for: chromo

Hello, I'm trying to add a column to the following data frame. The new column will contain "black" when the 5th column(if_TE_related) is "TE_related", or "orange" when the 4th column is " " (space). "chromo" "MSU_locus" "end5" "end3" "if_TE_related" "chr04" "LOC_Os04g01006" 1032 2679 "TE_related" "chr04" "LOC_Os04g01008" 7636 3951 "TE_related" "chr04" "LOC_Os04g01010" 9521 10296...

...]", "(5,10]", "(10,30]", NA, "Primary tumor", "[T1]", "[T2]", "[T3a]", "[T3b-T3c]", NA, "Histology", "[ClearCell]", "[Papill-Chromo]", "[Others]", NA, "Grading", "[G1]", "[G2]", "[G3]", "[G4]", NA, "n", NA, NA, "105", "198", NA, NA, "161", "142&q...

...following error by reinstallation of the sqldf package. Can anyone suggest a different way to perform this kind of merge function? Thank you, Ding > DMRlog2pbde47DMS <- sqldf("select * from DMR_log2pbde47 as a left join DMS_log2pbde47 as b + on a.chrom = b.chromosome and a.start <= b.MAPINFO and a.end >= b.MAPINFO" ) Error in get(as.character(FUN), mode = "function", envir = envir) : object 'as.AsIs' of mode 'function' was not found --------------------------------------------------------------------- -SECURITY/CONF...