Re-arrange several sub-arrays to accumulate ratings, Php - rextester

Run Code | API | Code Wall | Misc | Feedback | Login | Theme | Privacy | Patreon

Re-arrange several sub-arrays to accumulate ratings

Language: Layout:

<?php //php 7.0.8
$in=array(
  array (
      array (
    'skillName' => 'JDK',
    'comments' => '',
    'jobRating' => '2',
    'userRating' => '3',
    'skillGap' => '-1',
    'hrRating' => '2',
   ), array (
    'skillName' => 'Java Servlets',
    'comments' =>'',
    'jobRating' =>'4',
    'userRating' =>'3',
    'skillGap' => '1',
    'hrRating' => '3',
   ),
  ), 
  array (
      array (
    'skillName' => 'JDK',
    'comments' => '',
    'jobRating' => '2',
    'userRating' => '3',
    'skillGap' => '-1',
    'hrRating' => '7',
   ), array (
    'skillName' => 'Java Servlets',
    'comments' =>'',
    'jobRating' =>'4',
    'userRating' =>'3',
    'skillGap' => '1',
    'hrRating' => '2',
   )
  ), 
  array (
      array (
    'skillName' => 'JDK',
    'comments' => 'not bad',
    'jobRating' => '3',
    'userRating' => '3',
    'skillGap' => '-1',
    'hrRating' => '4',
  ),  array (
    'skillName' => 'Java Servlets',
    'comments' =>'',
    'jobRating' =>'8',
    'userRating' =>'3',
    'skillGap' => '1',
    'hrRating' => '1',
  ),
));

foreach ($in as $i => $na) foreach($na as $j => $aa) {
  $skill=$aa['skillName'];unset($aa['skillName']);
  foreach ($aa as $k => $v) $ret[$skill][$k][]=$v;
}

print_r($ret);

?>

[ + ] Show input
Absolute running time: 0.1 sec, cpu time: 0.06 sec, memory peak: 8 Mb, absolute service time: 0,11 sec

latest | history

Array
(
    [JDK] => Array
        (
            [comments] => Array
                (
                    [0] => 
                    [1] => 
                    [2] => not bad
                )

            [jobRating] => Array
                (
                    [0] => 2
                    [1] => 2
                    [2] => 3
                )

            [userRating] => Array
                (
                    [0] => 3
                    [1] => 3
                    [2] => 3
                )

            [skillGap] => Array
                (
                    [0] => -1
                    [1] => -1
                    [2] => -1
                )

            [hrRating] => Array
                (
                    [0] => 2
                    [1] => 7
                    [2] => 4
                )

        )

    [Java Servlets] => Array
        (
            [comments] => Array
                (
                    [0] => 
                    [1] => 
                    [2] => 
                )

            [jobRating] => Array
                (
                    [0] => 4
                    [1] => 4
                    [2] => 8
                )

            [userRating] => Array
                (
                    [0] => 3
                    [1] => 3
                    [2] => 3
                )

            [skillGap] => Array
                (
                    [0] => 1
                    [1] => 1
                    [2] => 1
                )

            [hrRating] => Array
                (
                    [0] => 3
                    [1] => 2
                    [2] => 1
                )

        )

)

λ

                                      .NET NoSQL database for rapid development