How to sum all column values in multi-dimensional array

Question

How can I add all the columnar values by associative key  Note that key sets are dynamic     Input array   Array        0    gt  Array                        gozhi    gt  2              uzorong    gt  1              ngangla    gt  4              langthel    gt  5                 1    gt  Array                        gozhi    gt  5              uzorong    gt  0              ngangla    gt  3              langthel    gt  2                 2    gt  Array                        gozhi    gt  3              uzorong    gt  0              ngangla    gt  1              langthel    gt  3               Desired result   Array        gozhi    gt  10      uzorong    gt  1      ngangla    gt  8      langthel    gt  10

User · Answer

You can try this    c   array map function            return array sum func get args             a   b     and finally   print r  c

User · Answer

For example  you can pluck all fields from a result like this below   I am picking out the  balance  from an array and save to a variable   kii      user- gt pluck  balance      then on the next line u can sum like this    sum     kii- gt sum       Hope it helps

User · Answer

You can use array walk recursive   to get a general-case solution for your problem  the one when each inner array can possibly have unique keys     final   array     array walk recursive  input  function  item   key  use   amp  final        final  key    isset  final  key       item    final  key     item        Example with array walk recursive   for the general case  Also  since PHP 5 5 you can use the array column   function to achieve the result you want for the exact key   gozhi   for example    array sum array column  input   gozhi        Example with array column   for the specified key  If you want to get the total sum of all inner arrays with the same keys  the desired result that you ve posted   you can do something like this  bearing in mind that the first inner array must have the same structure as the others      final   array shift  input    foreach   final as  key   gt   amp  value       value    array sum array column  input   key           unset  value     Example with array column   in case all inner arrays have the same keys  If you want a general-case solution using array column   then at first you may consider to get all unique keys   and then get the sum for each key     final   array     foreach  input as  value       final   array merge  final   value    foreach  final as  key   gt   amp  value       value   array sum array column  input   key     unset  value     Example with array column   for the general case

User · Answer

Here you have how I usually do this kind of operations      We declare an empty array in wich we will store the results  sumArray   array        We loop through all the key-value pairs in  myArray foreach   myArray as  k  gt  subArray           Each value is an array  we loop through it    foreach   subArray as  id  gt  value               If  sumArray has not  id as key we initialize it to zero          if  isset  sumArray  id                 sumArray  id    0                      If the array already has a key named  id  we increment its value         sumArray  id    value             print r  sumArray

User · Answer

Another version  with some benefits below    sum   ArrayHelper  copyKeys  arr 0     foreach   arr as  item        ArrayHelper  addArrays  sum   item       class ArrayHelper        public function addArrays Array  amp  to  Array  from            foreach   from as  key  gt  value                 to  key      value                       public function copyKeys Array  from   init 0            return array fill keys array keys  from    init              I wanted to combine the best of Gumbo s  Graviton s  and Chris J s answer with the following goals so I could use this in my app   a  Initialize the  sum  array keys outside of the loop  Gumbo   Should help with performance on very large arrays  not tested yet     Eliminates notices   b  Main logic is easy to understand without hitting the manuals   Graviton  Chris J    c  Solve the more general problem of adding the values of any two arrays with the same keys and make it less dependent on the sub-array structure   Unlike Gumbo s solution  you could reuse this in cases where the values are not in sub arrays   Imagine in the example below that  arr1 and  arr2 are not hard-coded  but are being returned as the result of calling a function inside a loop    arr1   array       gozhi    gt  2       uzorong    gt  1       ngangla    gt  4       langthel    gt  5      arr2   array      gozhi    gt  5      uzorong    gt  0      ngangla    gt  3      langthel    gt  2      sum   ArrayHelper  copyKeys  arr1    ArrayHelper  addArrays  sum   arr1   ArrayHelper  addArrays  sum   arr2

User · Answer

Code here           temp arr               foreach   a as  k   gt   v                if  is null  v                      sum   isset  temp arr  v 0        int  v 5     sum     int  v 5                    temp arr  v 0      sum                                  return  temp arr   Result   SEQ OK  1328 SEQ ERROR  561

User · Answer

sumArray   array     foreach   myArray as  k  gt  subArray      foreach   subArray as  id  gt  value         sumArray  id    value         print r  sumArray

User · Answer

sumArray   array     foreach   myArray as  k  gt  subArray      foreach   subArray as  id  gt  value        if  isset  sumArray  id           sumArray  id    value       else         sumArray  id    value               print r  sumArray

User · Answer

For those who landed here and are searching for a solution that merges N arrays AND also sums the values of identical keys found in the N arrays  I ve written this function that works recursively as well   See  https   gist github com Nickology f700e319cbafab5eaedc   Example    a   array   A    gt   bob    sum    gt  10   C    gt  array  x   y   z    gt  50      b   array   A    gt   max    sum    gt  12   C    gt  array  x   y   z    gt  45      c   array   A    gt   tom    sum    gt   8   C    gt  array  x   y   z    gt  50   w    gt  1      print r array merge recursive numeric  a  b  c      Will result in   Array        A    gt  tom      sum    gt  30      C    gt  Array                        0    gt  x              1    gt  y              z    gt  145              w    gt  1                Here s the code    lt  php         array merge recursive numeric function   Merges N arrays into one array AND sums the values of identical keys     WARNING  If keys have values of different types  the latter values replace the previous ones         Source  https   gist github com Nickology f700e319cbafab5eaedc     params N arrays  all parameters must be arrays      author Nick Jouannem  lt nick nickology com gt      access public     return void     function array merge recursive numeric             Gather all arrays      arrays   func get args            If there s only one array  it s already merged     if  count  arrays   1            return  arrays 0                 Remove any items in  arrays that are NOT arrays     foreach  arrays as  key   gt   array            if   is array  array                 unset  arrays  key                            We start by setting the first array as our final array         We will merge all other arrays with this one       final   array shift  arrays        foreach  arrays as  b             foreach  final as  key   gt   value                    If  key does not exist in  b  then it is unique and can be safely merged             if   isset  b  key                        final  key     value                 else                       If  key is present in  b  then we need to merge and sum numeric values in both                 if   is numeric  value   amp  amp  is numeric  b  key                              If both values for these keys are numeric  we sum them                      final  key     value    b  key                     else if  is array  value   amp  amp  is array  b  key                             If both values are arrays  we recursively call ourself                      final  key    array merge recursive numeric  value   b  key                      else                          If both keys exist but differ in type  then we cannot merge them                         In this scenario  we will  b s value for  key is used                      final  key     b  key                                                           Finally  we need to merge any keys that exist only in  b         foreach  b as  key   gt   value                if   isset  final  key                       final  key     value                                      return  final        gt

User · Answer

It can also be done using array map     rArray   array      0   gt  array           gozhi    gt  2           uzorong    gt  1           ngangla    gt  4           langthel    gt  5            1   gt  array           gozhi    gt  5           uzorong    gt  0           ngangla    gt  3           langthel    gt  2            2   gt  array           gozhi    gt  3           uzorong    gt  0           ngangla    gt  1           langthel    gt  3             sumResult   call user func array  array map   array merge   sum     rArray     function sum         return array sum func get args

User · Answer

this works great on my laravel project  print r  Array      your original array    SUM           count  Array 0     gt  if the number of keys are equall in all arrays then do a count of index 0 etc  for   i 0   i  lt  count  Array 0     i            SUM      Array 0   i     Array 1   i      do a for loop on the count     print r   SUM      get a sumed up array

User · Answer

Go through each item of the array and sum values to previous values if they exist  if not just assign the value   lt  php  array                     a   gt 1           b   gt 1           c   gt 1                        a   gt 2           b   gt 2                        a   gt 3           d   gt 3             result   array reduce  array  function  carry   item        foreach  item as  k   gt   v           carry  k     v     carry  k     0        return  carry           print r  result    Output  Array        a    gt  6      b    gt  3      c    gt  1      d    gt  3    Or just loop through each sub array  and group the values for each column   Eventually summing them  foreach  array as  subarray      foreach  subarray as  key   gt   value           grouped  key       value    sums   array map  array sum    grouped

User · Answer

We need to check first if array key does exist   CODE    sum   array    foreach   array as  key   gt   sub array        foreach   sub array as  sub key   gt   value               If array key doesn t exists then create and initize first before we add a value            Without this we will have an Undefined index error          if    array key exists  sub key   sum    sum  sub key    0             Add Value          sum  sub key    value          print r  sum     OUTPUT With Array Key Validation   Array        gozhi    gt  10      uzorong    gt  1      ngangla    gt  8      langthel    gt  10     OUTPUT Without Array Key Validation   Notice  Undefined index  gozhi in F  web index php on line 37  Notice  Undefined index  uzorong in F  web index php on line 37  Notice  Undefined index  ngangla in F  web index php on line 37  Notice  Undefined index  langthel in F  web index php on line 37  Array        gozhi    gt  10      uzorong    gt  1      ngangla    gt  8      langthel    gt  10     This is a bad practice although it prints the output  Always check first if key does exist

User · Answer

sumArray   array    foreach   myArray as  k   gt   subArray        foreach   subArray as  id   gt   value            if   isset  sumArray  id                   sumArray  id    0                     sumArray  id    value

User · Answer

Here is a solution similar to the two others    acc   array shift  arr   foreach   arr as  val        foreach   val as  key   gt   val             acc  key      val            But this doesn   t need to check if the array keys already exist and doesn   t throw notices neither

User · Answer

It can also be done using array walk   function array sum values array  input   key        sum   0     array walk  input  function  item   index   params             if   empty  item  params 1                  params 0      item  params 1             array  amp  sum   key           return  sum     var dump array sum values  arr   gozhi       Not so readable like previous solutions but it works

User · Answer

Use this snippet     key    gozhi    sum   array sum array column  array  key

User · Answer

Here s a version where the array keys may not be the same for both arrays  but you want them all to be there in the final array   function array add by key   array1   array2         foreach    array2 as  k   gt   a             if   array key exists   k   array1                    array1  k      a            else                array1  k     a                      return  array1

User · Answer

newarr array    foreach  arrs as  value      foreach  value as  key  gt  secondValue              if  isset  newarr  key                          newarr  key  0                    newarr  key    secondValue

[php] How to sum all column values in multi-dimensional array?

Examples related to php

Examples related to arrays

Examples related to multidimensional-array

Examples related to sum