How to sort the list by gender (gender)?

Question

Algorithms

The administration has set the task to make two mailing lists: boys/girls
In AD there is an up-to-date list with surnames and mailboxes.
Those. in fact, there is a list like:
Ivanova Ivan Ivanovich [email protected]
Nina Ivanovna Ivanovna [email protected]
Petr Semenovich Petrov [email protected]
Victoria Ivanovna Semenova [email protected]
Maybe someone came across a script that sorted users by gender. Boys on top, girls on bottom.
Actually, tell me, how best to solve the problem?
Ps absolutely no matter means: bash/ms excel/java/php

Answer 1

Make a database of m / f names (for example, here vse-imena.com ) and sort.

Answer 2

I don’t know if this will help you, but here a man is tearing all the women out of AD for congratulations on March 8th.

Answer 3

There is a base of names ~ 11k. And functionality for sorting into boys and girls. You can drop the database (you can without email) - I'll sort it for you.