Group 2d array rows by one column and sum another column [duplicate]

by

Let’s pretend that $array contains our data. We will go through the array and continually add the time_spent to another array keyed by url_id.

$ts_by_url = array();
foreach($array as $data) {
    if(!array_key_exists($data['url_id'], $ts_by_url))
        $ts_by_url[ $data['url_id'] ] = 0;
    $ts_by_url[ $data['url_id'] ] += $data['time_spent'];
}

$ts_by_url should now contain:

2191238 => 41
2191606 => 240 // == 215 + 25

More Related Contents:

  1. Group array data on one column and sum data from another column
  2. Group 2d array data by one column and sum other columns in each group (separately)
  3. Group array data on one column and sum data from another column to form a flat associative array
  4. Merge 2d array rows with same column value and sum another column [duplicate]
  5. How to sum all column values in multi-dimensional array?
  6. How to group a multidimensional array by a particular subarray value?
  7. sum specific values in a multidimensional array (php)
  8. Group multidimensional array data based on two column values and sum values of one column in each group
  9. Merge two indexed arrays of indexed arrays based on first column value
  10. Group 2d array data using column value to create a 3d array
  11. Group 2d array’s row data by one column and sum another column within each group to produce a reduced 2d array
  12. Group rows in a 2d array and count number of rows in each respective group
  13. PHP Multidimensional associative array to HTML table
  14. How to Sort a Multi-dimensional Array by Value
  15. How to access and manipulate multi-dimensional array by key names / path?
  16. Associative array, sum values of the same key
  17. Echo a multidimensional array in PHP
  18. Sorting multidim array: prioritize if column contains substring, then order by a second column
  19. How can you make a multidimensional array unique? [duplicate]
  20. Flatten multidimensional array concatenating keys [duplicate]
  21. php array find duplicates, sum them up & delete duplicates
  22. PHP foreach loop through multidimensional array [duplicate]
  23. Merge two 2d arrays by shared column value
  24. Loop a multidimensional array and only print two specific column values per row
  25. Group rows in an associative array of associative arrays by column value and preserve the original first level keys
  26. how to sort a multidemensional array by an inner key
  27. How to create multi-dimensional array from a list?
  28. Recreate original PHP array from print_r output [duplicate]
  29. Rename key in each row of a 2d array
  30. How to count the consecutive duplicate values in an array?

Leave a Comment