Nushell is also quite powerful for this. For example:
> open people.csv | where status == 'customer' | unique-by email | select surname forename email | sort-by email | save customers.json