mlr --csv uniq -g dept data.csv

With -g dept, uniq keeps the first record for each distinct value of the dept field, like SELECT DISTINCT on one column. This answers questions such as which departments appear in the data and where each first occurs. Whole-row dedup uses -a instead. The output row count equals the number of unique departments.