0

i have 3 column and 2600 rows of accoustics dataset. the 3 column is "Ping_Number", "Latitude" and "longitude".

enter image description here

for each ping number, i would like to retrain the first row of ping number "1" (and so on) and delete the rest of ping number "1" and the result like this.

enter image description here

I have tried using dplyr library using filter command, but it not satisfy with my needs.

Ronak Shah
  • 377,200
  • 20
  • 156
  • 213
rizki
  • 3
  • 2
  • What have you tried? Have a look [Remove duplicated rows](https://stackoverflow.com/questions/13967063/remove-duplicated-rows). – deepseefan Nov 18 '19 at 06:09

1 Answers1

0

You don't need dplyr for that, just do:

df <- unique(df[,1:3])
dc37
  • 15,840
  • 4
  • 15
  • 32