Associative array, sum values of the same key

by

You can try

$data = array(
  0 => array(
    'event' => 'Conference',
    'budget' => 3700,
  ),
  1 => array(
    'event' => 'Conference',
    'budget' => 500,
  ),
  2 => array(
    'event' => 'Showroom',
    'budget' => 1000,
  ),
  3 => array(
    'event' => 'Mission Chez client',
    'budget' => 2000,
  ),
  4 => array(
    'event' => 'Séminaire',
    'budget' => 700,
  ),
  5 => array(
    'event' => 'Livraison',
    'budget' => 4000,
  ),
  6 => array(
    'event' => 'Conference',
    'budget' => 334,
  ),
);

$sum = array_reduce($data, function ($a, $b) {
    isset($a[$b['event']]) ? $a[$b['event']]['budget'] += $b['budget'] : $a[$b['event']] = $b;  
    return $a;
});


print_r(array_values($sum));

Output 

Array
(
    [0] => Array
        (
            [event] => Conference
            [budget] => 4534
        )

    [1] => Array
        (
            [event] => Showroom
            [budget] => 1000
        )

    [2] => Array
        (
            [event] => Mission Chez client
            [budget] => 2000
        )

    [3] => Array
        (
            [event] => Séminaire
            [budget] => 700
        )

    [4] => Array
        (
            [event] => Livraison
            [budget] => 4000
        )

)

More Related Contents:

  1. Sum up array values [closed]
  2. PHP – File to Associative Array with 1 key and two values attached
  3. How to sum all column values in multi-dimensional array?
  4. In PHP, how do you change the key of an array element?
  5. Is there a way to find out how “deep” a PHP array is?
  6. Replace keys in an array based on another lookup/mapping array
  7. How to sort a date array in PHP
  8. Group array data on one column and sum data from another column
  9. Convert an associative array to a simple array of its values in php
  10. Display array values in PHP
  11. Best method for sum two arrays [closed]
  12. Comment associative array in PHP Documentor
  13. PHP – Merge two arrays (same-length) into one associative?
  14. Flip associative array and store new values in subarrays to prevent losing duplicated values
  15. Group 2d array rows by one column and sum another column [duplicate]
  16. Merge multiple associative arrays and add missing columns with a default value
  17. Iterating over a complex Associative Array in PHP
  18. How to merge two arrays by summing the merged values [duplicate]
  19. Generate an associative array from an array of rows using one column as keys and another column as values
  20. Group rows in an associative array of associative arrays by column value and preserve the original first level keys
  21. Prepend associative array elements to an associative array
  22. Custom key-sort a flat associative based on another array
  23. Merge two numerically-keyed associative arrays and preserve the original keys
  24. Group 2d array data by one column and sum other columns in each group (separately)
  25. PHP/SQL Insert Error when using Named Placeholders
  26. Implementing a simple lookup array
  27. Group array data on one column and sum data from another column to form a flat associative array
  28. Merge 2d array rows with same column value and sum another column [duplicate]
  29. Conditionally add associative element to array
  30. array_diff to compare two associative arrays

Leave a Comment