Most of te blockchain development services providers team using this soulution

Use df.groupby() to group by Name and Emp#. .max() . You can try this.