Reconstructing an array of arrays and turning it into an array of objects with keys as the first array and values as the rest of the array items

Question

The question itself is probably in need of editing but hear me out pls. I have this:

[
    ["a","b","c"],
    ["apple", "orange", "banana"],
    ["kiwi", "tomato", "avocado"],
    ["beans", "asparagus", "spinach"]
]

I need it so that it will look like the one below:

[
    {"a":"apple", "b":"orange", "c":"banana"},
    {"a":"kiwi", "b":"tomato", "c":"avocado"},
    {"a":"a", "b":"asparagus", "c":"spinach"}
]

I have done something like this:

const rows = [
    ["a","b","c"],
    ["apple", "orange", "banana"],
    ["kiwi", "tomato", "avocado"],
    ["beans", "asparagus", "spinach"]
]

const dataObj = {};
const dataArr = [];

if (rows.length) {
        keys = rows[0];
        values = rows[0];

        rows.forEach((element, i) => {
          values = rows[i];
          keys.forEach((key, j) => {
            dataObj[key] = values[j];
            dataArr.push(dataObj);
          });
        });
      }

To no avail and got something like this:

[
    {"a":"apple", "b":"orange", "c":"banana"},
    {"a":"apple", "b":"orange", "c":"banana"},
    {"a":"apple", "b":"orange", "c":"banana"}
]

This is not the desired output. If you can help me out - and our community! - it would be super. Thanks!

Rajesh Dixit · Accepted Answer · 2022-01-06 04:01:15Z

2

You can use couple of Array functions to achieve this:

Array.shift: To pick the first element and remove it from array
Array.map: To transform items into object

const rows = [
  ["a", "b", "c"],
  ["apple", "orange", "banana"],
  ["kiwi", "tomato", "avocado"],
  ["beans", "asparagus", "spinach"]
]

const keys = rows.shift();
const map = rows.map((item) => {
  const obj = {}
  keys.forEach((key, index) => {
    obj[key] = item[index]
  })
  return obj
})

console.log(map)

answered Jan 6, 2022 at 4:01

Rajesh Dixit

25k5 gold badges52 silver badges86 bronze badges

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

Comments

Hanchen Jiang · Accepted Answer · 2022-01-06 03:54:28Z

1

If you can use lodash: Check it out in this sandbox

import _ from 'lodash';

const input = [
  ["a","b","c"],
  ["apple", "orange", "banana"],
  ["kiwi", "tomato", "avocado"],
  ["beans", "asparagus", "spinach"]
]

const keys = input[0];
const values = input.splice(1);

console.log(keys);
console.log(values);

const output = values.map(row => _.zipObject(keys, row));
console.log(output);
/*
[
  {"a":"apple","b":"orange","c":"banana"}, 
  {"a":"kiwi","b":"tomato","c":"avocado"}, 
  {"a":"beans","b":"asparagus","c":"spinach"}
]
*/

answered Jan 6, 2022 at 3:54

Hanchen Jiang

2,6702 gold badges12 silver badges21 bronze badges

1 Comment

Gel Over a year ago

trying to implement this on a nodejs setup. I might need to require("lodash") - will update!

Shashank Penumatcha · Accepted Answer · 2022-01-06 04:28:23Z

1

Modified your code a little bit for the solution

    const rows = [
    ["a","b","c"],
    ["apple", "orange", "banana"],
    ["kiwi", "tomato", "avocado"],
    ["beans", "asparagus", "spinach"]
]

let dataObj = {};
const dataArr = [];

if (rows.length) {
    keys = rows[0];
    rows.forEach((row, i) => {
      if(i==0)
      return
      dataObj = {}
      keys.forEach((key, j) => {
        dataObj[key] = row[j];
      });
      dataArr.push(dataObj);

    });
  }
console.log(dataArr)

answered Jan 6, 2022 at 4:28

Shashank Penumatcha

811 silver badge7 bronze badges

1 Comment

Gel Over a year ago

I think this was what I was trying to do with my initial code! Thanks man, you definitely nailed what I was trying to do with that code.

Collectives™ on Stack Overflow

Reconstructing an array of arrays and turning it into an array of objects with keys as the first array and values as the rest of the array items

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related