Split and Coalesce Duplicated Records

Deduplicates datasets by retaining the most complete and informative records. Identifies duplicated entries based on a specified key column, calculates completeness scores for each row, and compares values within groups. When differences between duplicates exceed a user-defined threshold, records are split into unique IDs; otherwise, they are coalesced into a single, most complete entry. Returns a list containing the original duplicates, the split entries, and the final coalesced dataset. Useful for cleaning survey or administrative data where duplicated IDs may reflect minor data entry inconsistencies.


Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("pickmax")

0.1.0 by Sbonelo Chamane, a year ago


Browse source code at https://github.com/cran/pickmax


Authors: Sbonelo Chamane [aut, cre] , Musawenkosi Mabaso [aut] , Ronel Sewpaul [aut] , Sean Jooste [aut] , Kutloano Skhosana [aut] , Khangelani Zuma [aut]


Documentation:   PDF Manual  


GPL-3 license


Imports dplyr, rlang, magrittr


See at CRAN