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.

Reply via email to