Group a 2d array based on multiple column values

Question

I have a two dimensional array of students from different schools and countries. I want them to be grouped by name of school and country.

How can I create the nested key structure?

Example:

$students = [
  [
    "country" => "japan",
    "school"  => "kyoto university",
    "name"    => "Naruto Uzumaki"
  ],
  [
    "country" => "usa",
    "school"  => "harvard university",
    "name"    => "Naruto Uzumaki"
  ], 
  [
    "country" => "japan",
    "school"  => "tokyo university",
    "name"    => "sasuke Uchiha"
  ],
  [
    "country" => "japan",
    "school"  => "tokyo university",
    "name"    => "kakashi hatake"
  ],
];

Desired result:

[
  “japan” => [
      “kyoto university” => [
          [
            “country” => “japan”,
            “school”  => “kyoto university”,
            “name”    => “Naruto Uzumaki”
          ],
      ],

      “tokyo university” => [
          [
            “country” => “japan”,
            “school”  => “tokyo university”,
            “name”    => “sasuke Uchiha”
          ],
          [
            “country” => “japan”,
            “school”  => “tokyo university”,
            “name”    => “kakashi hatake”
          ],
      ],

   ],
   

   “usa” => [
       “harvard university” => [
           [
             “country” => “usa”,
             “school”  => “harvard university”,
             “name”    => “Naruto Uzumaki”
           ],
       ]
     ]

]

score 1 · Accepted Answer · answered Nov 11 '22 at 21:06

Pretty much creating an object or using an existing one. First create country object if not exists, then create school object under it (if not exists) then push to it.

$result = [];
foreach ($students as $student) {
    $country = $student['country'];
    $school = $student['school'];
    $result[$country] = isset($result[$country]) ? $result[$country] : [];
    $result[$country][$school] = isset($result[$country][$school]) ? $result[$country][$school] : [];
    $result[$country][$school][] = $student;
}
print_r($result);

Output:

Array
(
    [japan] => Array
        (
            [kyoto university] => Array
                (
                    [0] => Array
                        (
                            [country] => japan
                            [school] => kyoto university
                            [name] => Naruto Uzumaki
                        )

                )

            [tokyo university] => Array
                (
                    [0] => Array
                        (
                            [country] => japan
                            [school] => tokyo university
                            [name] => sasuke Uchiha
                        )

                    [1] => Array
                        (
                            [country] => japan
                            [school] => tokyo university
                            [name] => kakashi hatake
                        )

                )

        )

    [usa] => Array
        (
            [harvard university] => Array
                (
                    [0] => Array
                        (
                            [country] => usa
                            [school] => harvard university
                            [name] => Naruto Uzumaki
                        )

                )

        )

)

mickmackusa · Answer 2 · 2022-11-14T03:54:54.733

Loop over each row
Create convenient variables from the row's associative elements with extract()
Push the row into the nested associative structure using two of the three generated variables

Code: (Demo)

$result = [];
foreach ($students as $student) {
    extract($student);
    $result[$country][$school][] = $student;
}
var_export($result);

It is not at all necessary to instantiate/declare parent elements before pushing child elements when using square brace pushing syntax. If you are using array_push(), the parent element must be declared in advance.

There are more abstract and less attractive ways to code this task using array_reduce() or array destructuring:

While destructuring an array, can the same element value be accessed more than once?

Group a 2d array based on multiple column values

2 Answers2