Create one row for every duplicate N rows

Asked Apr 03 '20 at 20:26

Active Apr 03 '20 at 20:29

Viewed 21 times

I have a data set of latitude and longitudes and I want to group every three duplicate rows into one row to better show it on a map.

If my dataframe has these rows:

id    geom
 1    "-82.42   42.95"
 2    "-82.42   42.95"
 3    "-82.42   42.95"
 4    "-82.42   44.90"
 5    "-82.42   44.90"
 6    "-82.42   44.90"
 7    "-82.42   42.92"
 8    "-82.42   42.95"
 9    "-82.42   42.95"
 10    "-82.42   42.95"

After creating one row for every three duplicate rows, I'd generate a row (in a new data frame or mark this special row). If there weren't at least three duplicates, I'd disregard it.

id    geom
 3    "-82.42   42.95"
 6    "-82.42   44.90"
 10    "-82.42   42.95"

Thanks!

edited Apr 03 '20 at 20:29

asked Apr 03 '20 at 20:26

jellybean314

df.drop_duplicates(keep=True, inplace=True) ? see https://stackoverflow.com/questions/23667369/drop-all-duplicate-rows-in-python-pandas – Bernardo stearns reisen Apr 03 '20 at 20:27
You simply drop duplicate rows for the row-slice of at least length 3. – Prune Apr 03 '20 at 20:32

Create one row for every duplicate N rows

0 Answers0