How do I create an associative array with this data and get its results?

Question

I have 1 field for each users which gives me a series of skills:

$user->user_description

User 1 = Geography, English, Math, Science

User 2 = English, Math, Geography

User 3 = French, Math

NOTE Each one is a phrase with comma separated strings

Then I have another field for the gender which for each user I get:

get_user_meta( $the_user_id, $gender, $single ); 

User 1 = Male

User 2 = Female

User 3 = Male

The output I am looking for is:

• We have 2 Math teachers with gender male
• We have 2 Geography teachers with gender male and female
• We have 1 French teacher with gender female
• We have 2 English teacher with gender male and female
• We have 1 Science teacher with gender male

This is how I loop the users:

$blogusers = get_users( 'orderby=nicename&role=author' );
  foreach ( $blogusers as $user ) {

NOTE

I tried to simplify on here but I went much further up with the code which I have it in another question. Any other info you may need I am ready to provide it, it is really getting me stack. The main bit which blocks me is how to associate the Gender together with each skills once these have been splitted and counted.

What I have managed to do:

1. Split the comma separated list and push them into an array
2. Check for duplicated words in the array in order to be able to achieve the number of each skill e.g. 2 English
3. Be able to have the tot. number of each gender

But yet, not be able to add the gender for each skill once splitted

Answer 1

Just an example, assuming each user has these variables holding the value. $i is used to loop each position for the new array. I'm not sure how you're looping users entirely, usually i do this within a while($row=$result->fetch_assoc) type situation.

$blogusers = get_users( 'orderby=nicename&role=author' );
  for($i=0;$i<count($blogusers);$i++){   // run through your list of individuals
$userAttribList[$i]['gender'] = $gender;   // Assign the position 0 attribute
$userAttribList[$i]['role']   = $role;    /// assigb pos  attribute
$userAttribList[$i]['skill']  = $skill;  // assign pos 0 attribute

}
echo "<xmp>";
print_r($userAttribList);
echo "</xmp>";

will print out like this userAttribList = array( [0] => (['gender']=>male,['role']=>male,['skill']=>skiiing));

Just an example, not actual data but you get the idea

Loop and use like this

foreach($userAttribList as $user){
 echo $user['gender'];
 echo $user['skill'];
 echo $user['role'];
}

Answer 2

If you can establish a combined array that looks roughly like this:

$users[] = array('description'=>'Geography, English, Math, Science', 'gender' => 'male');
$users[] = array('description'=>'English, Math, Geography', 'gender' => 'female');
$users[] = array('description'=>'French, Math', 'gender' => 'male');

The following:

$roles = array();

foreach($users as $id => $values){
    $temp_roles = explode(',', $values['description']);
    foreach($temp_roles as $k => $v){
      $roles[trim($v)][$values['gender']][] = true;
    }
}
foreach($roles as $skill => $gender){
    $males = count($gender['male']);
    $females = count($gender['female']);

    $total = $males + $females;

    echo "We have {$total} {$skill} teachers, {$males} males, {$females} females <br>";

}

Will yield (formatting is up to you):

We have 2 Geography teachers, 1 males, 1 females
We have 2 English teachers, 1 males, 1 females
We have 3 Math teachers, 2 males, 1 females
We have 1 Science teachers, 1 males, 0 females
We have 1 French teachers, 1 males, 0 females