Reduce arrays inside array of object

Question

I have this array:

Collection {#319 ▼
  #items: array:6 [▼
    "Seccion 1 Pregunta 1" => array:3 [▼
      "satisfactory" => 2
      "unsatisfactory" => 0
      "total" => 2
    ]
    "Seccion 1 Pregunta 2" => array:3 [▼
      "satisfactory" => 2
      "unsatisfactory" => 0
      "total" => 2
    ]
    "Seccion 1 pregunta 3" => array:3 [▼
      "satisfactory" => 0
      "unsatisfactory" => 1
      "total" => 1
    ]
    "Seccion 2 pregunta 1" => array:3 [▼
      "satisfactory" => 3
      "unsatisfactory" => 0
      "total" => 3
    ]
    "Seccion 2 pregunta 2" => array:3 [▼
      "satisfactory" => 1
      "unsatisfactory" => 1
      "total" => 2
    ]
    "Commentarios seccion 2" => array:3 [▼
      "satisfactory" => 0
      "unsatisfactory" => 0
      "total" => 0
    ]
  ]
}

And I would like to get the sum of all the satisfactory, unsatisfactory and total values. Something like:

Collection {#319 ▼
    #items: array:3 [▼
          "satisfactory" => 8
          "unsatisfactory" => 2
          "total" => 10
    ]
}

Possible duplicate of [multidimensional array array\_sum](https://stackoverflow.com/questions/12838729/multidimensional-array-array-sum) — MCMXCII, May 29 '18 at 15:45

score 3 · Answer 1 · answered May 29 '18 at 16:08

If you know the keys you want, just do:

[
    'satisfactory'   => $collection->sum('satisfactory'),
    'unsatisfactory' => $collection->sum('unsatisfactory'),
    'total'          => $collection->sum('total')
]

If you're not sure what the keys will be, do a loop over the first item's keys to create a similar array as above. If you need this as a collection, just do:

$newCollection = collect( ... array from above ... );

score 2 · Answer 2 · answered May 29 '18 at 16:00

2

You can try something like:

$totals = array();
foreach($array as $key => $val) {
    $totals[$key] += $val;
}

answered May 29 '18 at 16:00

Kyle Wardle

828
6
23

score 1 · Answer 3 · answered May 29 '18 at 16:01

You can use array_walk:

$data = [
"Seccion 1 Pregunta 1" => [
  "satisfactory" => 2,
  "unsatisfactory" => 0,
  "total" => 2
],
"Seccion 1 Pregunta 2" => [
  "satisfactory" => 2,
  "unsatisfactory" => 0,
  "total" => 2
],
"Seccion 1 pregunta 3" => [
  "satisfactory" => 0,
  "unsatisfactory" => 1,
  "total" => 1
],
"Seccion 2 pregunta 1" => [
  "satisfactory" => 3,
  "unsatisfactory" => 0,
  "total" => 3
],
"Seccion 2 pregunta 2" => [
  "satisfactory" => 1,
  "unsatisfactory" => 1,
  "total" => 2
],
"Commentarios seccion 2" => [
  "satisfactory" => 0,
  "unsatisfactory" => 0,
  "total" => 0
]
];

$total = array('satisfactory' => 0, 'unsatisfactory' => 0, 'total' => 0);

array_walk($data, function($v) use (&$total) {
   $total['satisfactory'] += $v['satisfactory'];
    $total['unsatisfactory'] += $v['unsatisfactory'];
    $total['total'] += $v['total'];
});

score 1 · Accepted Answer · answered May 29 '18 at 16:12

You could also use array_reduce and pass an array with the keys and values set to 0 as a start value.

$result = array_reduce($arrays, function($carry, $item){
    $carry["satisfactory"] += $item["satisfactory"];
    $carry["unsatisfactory"] += $item["unsatisfactory"];
    $carry["total"] += $item["total"];
    return $carry;
}, ["satisfactory" => 0, "unsatisfactory" => 0, "total" => 0]);

print_r($result);

That would give you:

Array
(
    [satisfactory] => 8
    [unsatisfactory] => 2
    [total] => 10
)

Reduce arrays inside array of object

4 Answers4