Delete double IDs from array

Question

I am using PHP 7.1.33.

I am the following array:

[6114, 6128, 26.89] // --> [ID_1, ID_2, similarity_value]

I would like to filter if ID_1 and ID_2 are similar and pick the array with the higher similarity value (if its the same value keep the first array), such as:

[6114, 6128, 26.89] // keep this value
[6128, 6114, 25.60]

I am struggeling with the comparing part of the IDs. I tried the following:

<?php

$valueArr = [
    [6114, 6128, 26.89],
    [6128, 6114, 25.60],
    [1000, 2000, 35.33],
    [2000, 1000, 55.55],
    [6000, 6001, 35.98],
    [6005, 6004, 200],
    [6004, 6005, 200]
];

/**
 * @param array $valueArr
 * @return array
 */
function removeDoublesAndKeepHigh($valueArr)
{
    $resArr = array();

    foreach ($valueArr as $v) {
        foreach ($valueArr as $y) {
            if ($v[0] === $y[1]) {
                if ($y[1] === $v[1]) {
                    array_push($resArr, $v);
                }
            }
        }
    }
    return $resArr;
}

$resArr = removeDoublesAndKeepHigh($valueArr);

print_r($resArr);

/*
Wanted Result:
$resArr = [[6114, 6128, 26.89], [2000, 1000, 55.55], [6000, 6001, 35.98]];
*/

Any suggestions what I am doing wrong? Should I add another for-loop?

Appreciate your replies!

"if its the same value keep the first array" - then 6005, 6004, 200 should be in result too. — u_mulder
– u_mulder, Commented Dec 12, 2019 at 17:30
I don't understand what you're asking for. How does the "similarity" value" correlate to the two ID values? — Stephen R
– Stephen R, Commented Dec 12, 2019 at 19:13

u_mulder · Accepted Answer · 2019-12-12 17:39:38Z

1

My version with taking "if its the same value keep the first array" into consideration (fiddle here) is:

$valueArr = [
    [6114, 6128, 26.89], 
    [6128, 6114, 25.60], 
    [1000, 2000, 35.33], 
    [2000, 1000, 55.55], 
    [6000, 6001, 35.98], 
    [6005, 6004, 200], 
    [6004, 6005, 200]
];

$newData = [];
foreach ($valueArr as $value) {
    $key = $value[0] < $value[1] 
        ? $value[0] . '-' . $value[1] 
        : $value[1] . '-' . $value[0]; 
    if (empty($newData[$key]) || $newData[$key][2] < $value[2]) {
        $newData[$key] = $value;
    }
}
print_r(array_values($newData));

answered Dec 12, 2019 at 17:39

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Delete double IDs from array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related