Convert 3d array to 2d array by merging data in each row

Question

I need to flatten my subarrays of data to form a simpler / more shallow 2-dimensional array. Each row should become a flat, indexed array of unique values.

Input array:

$response = [
    695 => [
        0 => [
            '00:00',
            '01:00',
            '01:30',
            '03:30',
            '04:00',
        ]
    ],
    700 => [ 
        1 => [
            '00:00',
            '00:30',
            '01:00',
            '01:30',
            '02:00',
        ],
        2 => [
            '00:00',
            '00:30',
            '09:00',
            '06:30',
            '07:00',                    
        ]
    ]
];

My current code:

$result = array();
foreach ($response as $key => $list) {
  $result[$key] = array_merge($result, $list);
}
var_export($result);

but this doesn't give the proper result.

Expected output:

array (
  695 => 
  array (
    0 => '00:00',
    1 => '01:00',
    2 => '01:30',
    3 => '03:30',
    4 => '04:00',
  ),
  700 => 
  array (
    0 => '00:00',
    1 => '00:30',
    2 => '01:00',
    3 => '01:30',
    4 => '02:00',
    5 => '09:00',
    6 => '06:30',
    7 => '07:00',
  ),
)

I want to merge the results based on the key - which key? What have you tried? — Sougata Bose
– Sougata Bose, Commented Jan 6, 2017 at 9:21
I give this -1 later if this post didn't explain properly about the desired output. — Beginner
– Beginner, Commented Jan 6, 2017 at 9:23
This is an impossible output since based on key mentioned value will be overwritten. — Suchit kumar
– Suchit kumar, Commented Jan 6, 2017 at 9:26
you will never get your desired output because same indexes values will replaced . (new-one replace old one) — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Jan 6, 2017 at 9:29

LF-DevJourney · Accepted Answer · 2017-01-06 09:52:24Z

2

merge the array like this:

$result = array_map(function($v){
  $o = [];
  foreach($v as $val)
  {
    $o = array_merge($o, $val);
  }
  return array_values(array_unique($o));
}, $array);

edited Jan 6, 2017 at 9:52

answered Jan 6, 2017 at 9:29

LF-DevJourney

28.7k30 gold badges170 silver badges321 bronze badges

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

3 Comments

Death-is-the-real-truth Over a year ago

check his output (it have same indexes)

LF-DevJourney Over a year ago

how can the array have the same index

Suchit kumar Over a year ago

yes but i did not downvote. it still has index issue.use array_values before return.

mickmackusa · Accepted Answer · 2022-09-18 11:03:14Z

0

The modern equivalent of @LF00's answer is as follows.

Iterate each row without affecting the first level keys. Merge (flatten) subsets of data, remove duplicates, then re-index the unique elements.

Code: (Demo)

var_export(
    array_map(
        fn($rows) =>
            array_values(
                array_unique(
                    array_merge(...$rows)
                )
            ),
        $array
    )
);

answered Sep 18, 2022 at 11:03

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

Collectives™ on Stack Overflow

Convert 3d array to 2d array by merging data in each row

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related