array_count_values of a multi dimensional array?

Question

I have searched this question a lot. But I could not find a proper solution anywhere. Just like you do an array_count_values() for a single dimensional array, what do you do for a multi dimensional array if you want similar type of a solution?

For example-

Array
(
    [0] => Array
        (
            [07/11] => 134
        )

    [1] => Array
        (
            [07/11] => 134
        )

    [2] => Array
        (
            [07/11] => 145
        )

    [3] => Array
        (
            [07/11] => 145
        )

    [4] => Array
        (
            [07/12] => 134
        )

    [5] => Array
        (
            [07/12] => 99
        )
)

The output that I want is-

Date: 07/11, ID: 134, Count: 2
Date: 07/11, ID: 145, Count: 2
Date: 07/12, ID: 135, Count: 1
Date: 07/12, ID: 99, Count: 1

How do I do this?

You could either run a nested foreach loop or create a recursive function to navigate multi-dimensions — Sterling Archer
– Sterling Archer, Commented Jul 14, 2013 at 18:44
I figured out I need to use a nested loop to navigate multi-dimensions but I am not able to figure out how will I count unique IDs for each date. — user2510555
– user2510555, Commented Jul 14, 2013 at 18:56

Expedito · Accepted Answer · 2013-07-14 19:25:18Z

16

Using the variable $arr for your array, you could do this:

$out = array();
foreach ($arr as $key => $value){
    foreach ($value as $key2 => $value2){
        $index = $key2.'-'.$value2;
        if (array_key_exists($index, $out)){
            $out[$index]++;
        } else {
            $out[$index] = 1;
        }
    }
}
var_dump($out);

Output:

Array
(
    [07/11-134] => 2
    [07/11-145] => 2
    [07/12-134] => 1
    [07/12-99] => 1
)

Here's another version that produces it as a multidimensional array:

$out = array();
foreach ($arr as $key => $value){
    foreach ($value as $key2 => $value2){
        if (array_key_exists($key2, $out) && array_key_exists($value2, $out[$key2])){
            $out[$key2][$value2]++;
        } else {
            $out[$key2][$value2] = 1;
        }
    }
}

Output:

Array
(
    [07/11] => Array
        (
            [134] => 2
            [145] => 2
        )

    [07/12] => Array
        (
            [134] => 1
            [99] => 1
        )

)

edited Jul 14, 2013 at 19:25

answered Jul 14, 2013 at 19:01

Expedito

7,8095 gold badges32 silver badges45 bronze badges

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

1 Comment

user2510555 Over a year ago

The second solution was amazing. I never thought this could be done this way. Thanks, so much I learned :)

jerdiggity · Accepted Answer · 2013-07-14 19:14:19Z

2

<?php
  $array = array(array('07/11' => '134'), array('07/11' => '134'), array('07/12' => '145'));
  $count = array();
  foreach ($array as $val) {
    foreach ($val as $key => $subval) {
      $count[$key]++;
    }
  }
  print_r($count);

edited Jul 14, 2013 at 19:14

answered Jul 14, 2013 at 18:56

jerdiggity

3,6751 gold badge31 silver badges41 bronze badges

4 Comments

user2510555 Over a year ago

Hi, thanks for the answer. But your solution will just give me count of unique IDs. I want it date wise.

jerdiggity Over a year ago

Oops... See last revision (sorry about that). :)

123dcck Over a year ago

beautiful solution. +1

user2510555 Over a year ago

Your new solution gives me the count of unique date only. Not the IDs.

liding · Accepted Answer · 2013-07-14 18:58:00Z

0

In your place I would have altered the structure of the data array. In your case:

Array( 
    [07/11] => Array
        (
            [0] => 134,
            [1] => 134,
            [2] => 145,
            [3] => 145,
            ...
        )
)

answered Jul 14, 2013 at 18:58

liding

1161 silver badge6 bronze badges

2 Comments

user2510555 Over a year ago

Interesting. How do I proceed after doing this?

Obmerk Kronen Over a year ago

Also, this is not always a viable solution as many times one will need to work with an already fixed data..

TAHER El Mehdi · Accepted Answer · 2023-03-25 11:35:56Z

0

Smart way, We know that array_count_values(): Counts all the values of an array

Just like you do an array_count_values() for a single dimensional array, what do you do for a multi dimensional array.

We do it by turning it to one single dimensional array, then we call our funciton

$input = array(
    array('07/11' => '134'),
    array('07/11' => '134'), 
    array('07/11' => '145'),
    array('07/11' => '145'),
    array('07/12' => '134'), 
    array('07/12' => '99')
    );
$output = [];
foreach ($input as $inner){
    foreach ($inner as $key => $value){
        $output[] = "Date: $key, ID: $value, Count:";
    }
}

OUTPUT: as you expect

foreach(array_count_values($output) as $key => $value) {
    echo "$key $value<br>";
}

/*Date: 07/11, ID: 134, Count: 2
Date: 07/11, ID: 145, Count: 2
Date: 07/12, ID: 135, Count: 1
Date: 07/12, ID: 99, Count: 1*/

Updated for cases where there are multiple elements in each sub-array

   $input = array(
    array('07/11' => '134', '07/12' => '100'),
    array('07/11' => '134', '07/12' => '100'), 
    array('07/11' => '145', '07/12' => '200'),
    array('07/11' => '145', '07/12' => '200'),
    array('07/12' => '134', '07/13' => '300'), 
    array('07/12' => '99', '07/13' => '400')
    );
$output = [];
foreach ($input as $inner){
    if (count($inner) > 1) {
        // handle multiple elements in sub-array
        foreach ($inner as $key => $value){
            if (isset($output[$key][$value])) {
                $output[$key][$value]++;
            } else {
                $output[$key][$value] = 1;
            }
        }
    } else {
        // handle single element in sub-array
        foreach ($inner as $key => $value){
            $output[] = "Date: $key, ID: $value, Count:";
        }
    }
}

if (count($output) > 1) {
    // handle multiple elements in output array
    foreach ($output as $date => $counts) {
        foreach ($counts as $id => $count) {
            echo "Date: $date, ID: $id, Count: $count<br>";
        }
    }
} else {
    // handle single element in output array
    foreach(array_count_values($output) as $key => $value) {
        echo "$key $value<br>";
    }
}

Result would be:

Date: 07/11, ID: 134, Count: 2
Date: 07/11, ID: 145, Count: 2
Date: 07/12, ID: 100, Count: 2
Date: 07/12, ID: 134, Count: 1
Date: 07/12, ID: 99, Count: 1
Date: 07/13, ID: 300, Count: 1
Date: 07/13, ID: 400, Count: 1

edited Mar 25, 2023 at 11:35

answered May 9, 2021 at 21:13

TAHER El Mehdi

9,6367 gold badges33 silver badges52 bronze badges

3 Comments

Andrew Over a year ago

this will not work if there are multiple elements in each sub array

TAHER El Mehdi Over a year ago

check it now, for cases where if there are multiple elements in each sub-array!

Andrew Over a year ago

looks wrong. I think it will not count unique rows in multidimensional array.

Collectives™ on Stack Overflow

array_count_values of a multi dimensional array?

4 Answers 4

1 Comment

4 Comments

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

4 Comments

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related