Sum the elements of an array key in a multidimensional array

Question

This is my array

[Company] => Array
        (
            [0] => Array
                (
                    [date] => 2016-05-28
                    [revenue] => 55
                )

            [1] => Array
                (
                    [date] => 2016-05-28
                    [revenue] => 101
                )

            [2] => Array
                (
                    [date] => 2016-05-29
                    [revenue] => 55
                )

            [3] => Array
                (
                    [date] => 2016-05-29
                    [revenue] => 101
                )

            [4] => Array
                (
                    [date] => 2016-05-30
                    [revenue] => 60
                )

            [5] => Array
                (
                    [date] => 2016-05-30
                    [revenue] => 60
                )

            [6] => Array
                (
                    [date] => 2016-05-31
                    [revenue] => 29
                )

            [7] => Array
                (
                    [date] => 2016-05-31
                    [revenue] => 60
                )

)

I need it to be summed up like this

[Company] => Array
        (
        [0] => Array
         (
           [date] => 2016-05-28
           [revenue] => 151
         )
         *
         *etc.
)

I've tried various methods by in vain. I've tried the below method but didn't work quite well

    foreach($data as $key => $value) {
        foreach ($value as $row) {


            $res[$key][$row['date']] += $row['revenue'];
        }
    }

just answered this question here. Could be easliy adapted for your needs stackoverflow.com/questions/37675819/… — atoms
– atoms, Commented Jun 7, 2016 at 13:12
@atoms taking cue from ur answer, why there's an error of undefined index if I dynamically set the key of an array like this $aSortedArray[$aArray['source']][] = array( 'target' => $aArray['target'], 'total_volume' => $aArray['total_volume'] ); — user3496603
– user3496603, Commented Jun 7, 2016 at 13:23

atoms · Accepted Answer · 2016-06-07 13:38:57Z

1

This should work, its not ideal as your looping over each array twice, as the array gets larger this will exponentially slow down.

$aStartingArray = array();
$aSortedArray   = array();

$aStartingArray[] = array('date'=>'2016-05-28', 'revenue' => 55);
$aStartingArray[] = array('date'=>'2016-05-28', 'revenue' => 101);
$aStartingArray[] = array('date'=>'2016-05-29', 'revenue' => 55);
$aStartingArray[] = array('date'=>'2016-05-29', 'revenue' => 101);
$aStartingArray[] = array('date'=>'2016-05-30', 'revenue' => 60);
$aStartingArray[] = array('date'=>'2016-05-30', 'revenue' => 60);
$aStartingArray[] = array('date'=>'2016-05-31', 'revenue' => 29);
$aStartingArray[] = array('date'=>'2016-05-31', 'revenue' => 60);

// loop through the initial array
foreach ($aStartingArray as $aArray) {

    // set flag to reference if its been dealt with
    $bSet = false;

    // foreach of the sorted values, check if the date matches an entry
    foreach ($aSortedArray as $iPos => $aTempSortedArray) {

        if( $aTempSortedArray['date'] == $aArray['date'] ){

            // match found, add revenue
            $aSortedArray[$iPos]['revenue'] += $aArray['revenue'];

            // set flag to illustrate a dealt with row
            $bSet = true;
        }

    }

    // if still hasnt been dealt with, go add it to the array
    if(!$bSet){
        $aSortedArray[] = array( 'date' => $aArray['date'], 'revenue' => $aArray['revenue'] );
    }

}

var_dump($aSortedArray);

answered Jun 7, 2016 at 13:38

atoms

3,1032 gold badges25 silver badges46 bronze badges

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

1 Comment

atoms Over a year ago

thanks for the kind words. There are much better and more efficient methods out there. Just be careful if your planning to use it for large data sets

DsRaj · Accepted Answer · 2016-06-07 14:24:39Z

1

I have No doutes with @atoms answer, but it will be done in one foreach

     $newArr = array();
     foreach($arr['Company'] as $key => $value) {
        if(isset($newArr[$value['date']])){
            $newArr[$value['date']]['revenue'] = $newArr[$value['date']]['revenue'] + $value['revenue'];
        } else {
            $newArr[$value['date']] = $value;
        }
    }
    $newArr = array_values($newArr);

edited Jun 7, 2016 at 14:24

answered Jun 7, 2016 at 14:18

DsRaj

2,3181 gold badge19 silver badges27 bronze badges

Comments

khaverim · Accepted Answer · 2016-06-07 13:25:28Z

0

$revenue_sum=0;
$elements_sum=0;
   foreach($data as $key => $value) { // 1st dimension
        foreach ($value as $key2 => $value2) { // 2nd dimension
            if ($key2 == "revenue") {
                 $revenue_sum += $value2;
            }
            $elements_sum++;
        }
    }

 echo "Revenue sum: ".$total_sum;
 echo "Elements sum: ".$elements_sum;

answered Jun 7, 2016 at 13:25

khaverim

3,5945 gold badges38 silver badges47 bronze badges

Collectives™ on Stack Overflow

Sum the elements of an array key in a multidimensional array

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related