Enter the body of text here Hi, I need r code or sql command to find the correct haplotype and finally get the correct diplotype. I have the below table, from which I need to get single haplotype for each rsID.
NCBI SNP Reference Wild Variant Haplotype Name Reference Allele Variant Allele rs7900194 G G CYP2C9*8 G A rs7900194 G G CYP2C9*27 G T rs1799853 C T CYP2C9*2 C T rs1799853 C T CYP2C9*35 C T rs1799853 C T CYP2C9*61 C T rs1057910 A A CYP2C9*3 A C rs1057910 A A CYP2C9*18 A C
Code should be placed in three backticks as shown below
dplyr %>% group_by("NCBI SNP Reference","Wild","Variant") %>% filter(n()>1) # include your problematic code here with any corresponding output # please also include the results of running the following in an R session sessionInfo( ) R version 4.2.2 (2022-10-31 ucrt) Platform: x86_64-w64-mingw32/x64 (64-bit) Running under: Windows 10 x64 (build 19045) Matrix products: default locale:  LC_COLLATE=English_India.utf8 LC_CTYPE=English_India.utf8  LC_MONETARY=English_India.utf8 LC_NUMERIC=C  LC_TIME=English_India.utf8 attached base packages:  stats graphics grDevices utils datasets methods base other attached packages:  dplyr_1.1.3 ggplot2_3.4.1 tidyverse_2.0.0 loaded via a namespace (and not attached):  fansi_1.0.4 withr_2.5.0 utf8_1.2.3 grid_4.2.2  R6_2.5.1 lifecycle_1.0.3 gtable_0.3.1 magrittr_2.0.3  scales_1.2.1 pillar_1.9.0 rlang_1.1.2 cli_3.6.0  rstudioapi_0.15.0 generics_0.1.3 vctrs_0.6.4 tools_4.2.2  glue_1.6.2 munsell_0.5.0 compiler_4.2.2 pkgconfig_2.0.3  colorspace_2.1-0 tidyselect_1.2.0 tibble_3.2.1