Dear list,
I have a table where first 3 columns are identical if the name in the
first column is the same, and
the number in N4 is slightly different for all identical names, like
this:
-------------------------------------------------------------------
29 Mm.1_at 3 + 93649936
30 Mm.1_at 3 + 93649990
31 Mm.1_at 3 + 93649993
32 Mm.1_at 3 + 93650001
33 Mm.1_at 3 + 93650010
34 Mm.10_at 4 + 147438101
35 Mm.10_at 4 + 147438192
36 Mm.10_at 4 + 147438214
37 Mm.100043_at 5 + 31602952
38 Mm.100043_at 5 + 31602982
39 Mm.100043_at 5 + 31603000
-------------------------------------------------------------------
I need to select unique identifiers in column N 1, without paying
attention to what is in column N4, taking the first number in N4
corresponding to first unique ID in N1, like this:
29 Mm.1_at 3 + 93649936
34 Mm.10_at 4 + 147438101
37 Mm.100043_at 5 + 31602952
Could someone tell me how to do it without FOR cycle over all IDs in N1?
Thank you!
Best regards
Galina
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.