count same values in array and combine into array

Question

i am trying to return a "altered" array.

for example my current array looks like this: The Code:

    $filtered = array();
foreach($inBounds as $index => $columns) {
    foreach($columns as $key => $value) {       
    if(in_array($columns,$filtered)){
    }else{
    $filtered[$z] = $columns;
    $z = $z + 1;    
    }
}
}

The Array

Now i want to count the duplicates ( [limit_lat] ), remove them from the current array and put them back together like the following array:

this is what i need it to look like after the duplicate purge.

Array
 (
    [0] => Array
        (
            [id] => 1006
            [lat] => 51.28940600
            [lng] => 6.98730500
            [name] => fghfgh
            [date] => 2018-08-31 11:47:23
            [sizeIcon] => icon1
            [limit_lat] => 51
            [count] => 3
        )


    [1] => Array
        (
            [id] => 1009
            [lat] => 51.97811300
            [lng] => 7.83325200
            [name] => wer
            [date] => 2018-08-31 13:56:02
            [sizeIcon] => icon1
            [limit_lat] => 52
            [count] => 2
        )

    [2] => Array
        (
            [id] => 1011
            [lat] => 27.95195200
            [lng] => -82.46612500
            [name] => sdfsdf
            [date] => 2018-08-31 13:57:12
            [sizeIcon] => icon1
            [limit_lat] => 28
            [count] => 4
        )
    [3] => Array
        (
            [id] => 1005
            [lat] => 49.48240100
            [lng] => 0.28564500
            [name] => dsfsdf
            [date] => 2018-08-30 15:21:32
            [sizeIcon] => icon1
            [limit_lat] => 49
            [count] => 1
        )   

    )

right now i am able to count them nicely but i am only getting this back: The Code:

$data = array();
foreach($filtered as $cluster) {
    if(isset($data[$cluster['limit_lat']])) {
        $data[$cluster['limit_lat']]++;
    } else {
        $data[$cluster['limit_lat']] = 1;
    }
}

The Array:

Array
(
    [51] => 3
    [52] => 2
    [28] => 4
    [49] => 1
)

I already tried multiple approaches but not with the wanted result. Someone has an idea how i can get this working?

Thanks, Dennis

Andreas · Accepted Answer · 2018-09-10 15:40:41Z

2

If limit_lat is all you need you can use array_count_values and array_column.
Array_column filters out all limit_lat items to a single dimensional array, and array_count_values will count them.

$count = array_count_values(array_column($arr, "limit_lat"));

Now $count will have a similar output as your expected output.

Edit: see now that you want to remove duplicates too.

$count = array_count_values(array_column($arr, "limit_lat"));
// Remove duplicates
$nodupes = array_column($arr, Null, "limit_lat");

// Add count to array items.
foreach ($count as $key => $c){
     $nodupes[$key]['count'] = $c;
}
$nodupes = array_values($nodupes);

This should work, but I can't test it.
If you want a sure code json_encode or var_export your array so that we can use it.

edited Sep 10, 2018 at 15:40

answered Sep 10, 2018 at 15:18

Andreas

24k7 gold badges34 silver badges75 bronze badges

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

12 Comments

Dennis Over a year ago

i actually need all the info back, just the duplicates should get removed and the [count] => x added.

Dennis Over a year ago

this did not work, it still gives me duplicates instead of the count.

Andreas Over a year ago

Then do as I ask you in the last paragraph of my answer.

Dennis Over a year ago

This is how it looks like before the duplicates are counted and removed: lightacandle.icu/filtered.txt

Andreas Over a year ago

Var_export or json_encode, not var_dump or print_r. It really is a big difference. Also it does remove duplicates, you must be doing something wrong. See here 3v4l.org/jTtcR

|

Mike Purcell · Accepted Answer · 2018-09-10 16:33:09Z

1

You could just keep track of the "dupes" by storing them in a separate array, with first found elements in yet another separate array.

$limitLats = [];
$trulyFiltered = [];

foreach($filtered as $cluster) {

    if (true === array_key_exists($cluster['limit_lat'], $trulyFiltered)) {

        $limitLats[$cluster['id']] = $cluster['limit_lat'];

        continue;
    }

    $trulyFiltered[$cluster['limit_lat']] = $cluster;
}

// Should give you the count for # of dupes
echo count($limitLats);

// Should give you unique dataset based on limit_lat
var_dump($trulyFiltered);

edited Sep 10, 2018 at 16:33

answered Sep 10, 2018 at 15:09

Mike Purcell

20k10 gold badges54 silver badges94 bronze badges

1 Comment

Dennis Over a year ago

this is returning the same results as the $filtered array for some reason.

scrowler · Accepted Answer · 2018-09-10 15:07:08Z

0

You could exclude them from the original loop by checking whether the unique value is already in the array:

$filtered = array();
$usage = array();

foreach ($inBounds as $index => $columns) {
    foreach ($columns as $key => $value) {       
        $uniqueKey = $columns['limit_lat'];
        // track use of unique key
        $usage[$uniqueKey]++;

        if (array_key_exists($uniqueKey, $filtered) {
            // already added one, skip
            continue;
        }
        $filtered[$uniqueKey] = $columns;
    }
}

Your output filtered array will be indexed by the limit_lat key and will contain one $inBounds entry per limit_lat value, and your $usage array will contain the number of times a limit_lat value was processed.

answered Sep 10, 2018 at 15:07

scrowler

24.4k10 gold badges67 silver badges99 bronze badges

1 Comment

Dennis Over a year ago

this gives me a ERROR 500 for some reason. there was a ) missing in the if statement. checking now for results. This did not work, i do need the duplicates counted and added to the [count] => x.

Collectives™ on Stack Overflow

count same values in array and combine into array

3 Answers 3

12 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

12 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related