[R] how to find number of unique rows for combination of r columns
Ana Marija
@okov|c@@n@m@r|j@ @end|ng |rom gm@||@com
Fri Nov 8 15:38:56 CET 2019
Hello,
I have a data frame like this:
> head(dt,20)
chr pos gene_id pval_nominal pval_ret wl wr
1: chr1 54490 ENSG00000227232 0.6084950 0.7837780 31.62278 21.2838
2: chr1 58814 ENSG00000227232 0.2952110 0.8975820 31.62278 21.2838
3: chr1 60351 ENSG00000227232 0.4397880 0.8679590 31.62278 21.2838
4: chr1 61920 ENSG00000227232 0.3195280 0.6018090 31.62278 21.2838
5: chr1 63671 ENSG00000227232 0.2377390 0.9880390 31.62278 21.2838
6: chr1 64931 ENSG00000227232 0.2766790 0.9070370 31.62278 21.2838
7: chr1 81587 ENSG00000227232 0.6057930 0.6167630 31.62278 21.2838
8: chr1 115746 ENSG00000227232 0.4078770 0.7799110 31.62278 21.2838
9: chr1 135203 ENSG00000227232 0.4078770 0.9299130 31.62278 21.2838
10: chr1 138593 ENSG00000227232 0.8464560 0.5696060 31.62278 21.2838
it is very big,
> dim(dt)
[1] 73719122 8
To count number of unique rows for all 3 columns: chr, pos and gene_id
I could just join those 3 columns and than count. But how would I find
unique number of rows for these 4 columns without joining them?
Thanks
Ana
More information about the R-help
mailing list