Group rows of 2d array by one column and sum another column

Question

I have an array:

Array 
(
[0] => Array
    (
        [setid] => 2
        [income] => 100
    )

[1] => Array
    (
        [setid] => 2
        [income] => 120
    )

[2] => Array
    (
        [setid] => 3
        [income] => 700
    )
)

I need to find entries with the same setid, sum their income up and delete duplicate entrys - in the end it should look like this:

Array
(
[0] => Array
    (
        [setid] => 2
        [income] => 220
    )

[1] => Array
    (
        [setid] => 3
        [income] => 700
    )
)

Does someone know a sophisticated solution for my problem or do I have to take the long road and do every step manually?

bwoebi · Accepted Answer · 2013-10-11 14:01:28Z

5

Just create a new array which you make fast adressable by using the setid as key. And reindex the array at the end.

$result = array();
foreach ($array as $val) {
    if (!isset($result[$val['setid']]))
        $result[$val['setid']] = $val;
    else
        $result[$val['setid']]['income'] += $val['income'];
}
$result = array_values($result); // reindex array

edited Oct 11, 2013 at 14:01

answered Oct 10, 2013 at 14:55

bwoebi

23.8k5 gold badges64 silver badges81 bronze badges

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

2 Comments

bwoebi Over a year ago

(Alternatively you also could just use array_reduce, if you think this would be more elegant; but that here actually does the job too.)

Stefan Over a year ago

@ bwoebi: much obliged! works like a charm - with a small alteration for my logic (negate if-clause): code if (!isset($result[$val['mitarbeiter_id']])) code otherwise it would not sum up the income.

Pitchinnate · Accepted Answer · 2013-10-10 15:04:47Z

0

This should work:

$values = array();
foreach($array as $val) {
    if(isset($values[$val['setid']])) {
        $values[$val['setid']] += $val['income'];
    } else {
        $values[$val['setid']] = $val['income'];
    }
}
//all values are now in $values array, keys are setid and values are income

edited Oct 10, 2013 at 15:04

answered Oct 10, 2013 at 14:56

Pitchinnate

7,5561 gold badge22 silver badges39 bronze badges

5 Comments

bwoebi Over a year ago

actually, you'd first need to create an array where the keys are setid…

Pitchinnate Over a year ago

I modified answer so you don't have to

bwoebi Over a year ago

Hehe, now it just nearly looks like my answer :-)

Pitchinnate Over a year ago

Yeah it would have worked the way before however it just throws a notice.

gre_gor Over a year ago

This doesn't create the desired structure.

Collectives™ on Stack Overflow

Group rows of 2d array by one column and sum another column

2 Answers 2

2 Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related