DataFrame.Distinct - how to check distinct for specific columns

[johndevera]

Hi, I am trying to get a function like DataFrame.Distinct that is able to drop a duplicate row, but only based on a duplicate for a particular column? Right now, it drops the duplicate only if the entire row is the same.

[colin-ho]

We don't have an ergonomic API for this yet, but you can use df.groupby("col1", "col2").any_value(). Which drops duplicates and retains 'any' row from the duplicates