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
    ]
}

Did you try something ?

Mickaël Leger
– Mickaël Leger

2018-05-29 15:45:31 +00:00
Commented May 29, 2018 at 15:45 — Mickaël Leger
– Mickaël Leger, Commented May 29, 2018 at 15:45
Possible duplicate of multidimensional array array_sum

MCMXCII
– MCMXCII

2018-05-29 15:45:45 +00:00
Commented May 29, 2018 at 15:45 — MCMXCII
– MCMXCII, Commented May 29, 2018 at 15:45

parker_codes · Accepted Answer · 2018-05-29 16:08:38Z

3

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 ... );

answered May 29, 2018 at 16:08

parker_codes

3,4151 gold badge21 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kyle Wardle · Accepted Answer · 2018-05-29 16:00:38Z

2

You can try something like:

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

answered May 29, 2018 at 16:00

Kyle Wardle

8306 silver badges23 bronze badges

Comments

The fourth bird · Accepted Answer · 2018-05-29 16:12:59Z

1

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
)

answered May 29, 2018 at 16:12

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

Comments

Max Heyer · Accepted Answer · 2018-05-29 16:01:36Z

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'];
});

Collectives™ on Stack Overflow

Reduce arrays inside array of object

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related