Comparison between an array and array of arrays to insert missing keys

Question

I'm trying to create a comparison between an array of keys and an array of arrays. The array of array contains the data as the follwing:

const data = [
  [["id", 1], ["name", "somethign"], ["age", 20]],
  [["id", 20], ["name", "somethign"]],
  [["id", 9], ["age", 10]]
]

An the array with keys, that will always have all the keys I need.

const keys = [
  "id",
  "name",
  "age",
  "nothing"
]

But as you can see in data array, not always all the keys come in the array, what I was attempting to do was, make a comparison between both arrays an add that key that is missing into the data array (in order) as undefined, for example (final result):

const data = [
  [["id", 1], ["name", "somethign"], ["age", 20], ["nothing", undefined]],
  [["id", 20], ["name", "somethign"],["age", undefined] ["nothing", undefined]],
  [["id", 9], ["name", undefined], ["age", 10], ["nothing", undefined]]
]

Irfanullah Jan · Accepted Answer · 2022-05-02 12:40:55Z

1

The following method takes these steps:

Loops over the data in the given order i.e. it will maintain the order of the data.
For each row of the data, it loops over the keys in the order of keys. So within each row, it will keep the order of the keys and keys will be consistent on top of each other.

I prefer null over undefined here but you are free to change it to undefined.

const data = [
  [
    ['id', 1],
    ['name', 'somethign'],
    ['age', 20],
  ],
  [
    ['id', 20],
    ['name', 'somethign'],
  ],
  [
    ['id', 9],
    ['age', 10],
  ],
];

const keys = ['id', 'name', 'age', 'nothing'];

const dataWithMissingKeys = data.map(row =>
  keys.map(key => {
    const foundItem = row.find(element => element[0] === key);
    if (foundItem) {
      return foundItem;
    }
    return [key, null];
  })
);

console.log(dataWithMissingKeys);

edited May 2, 2022 at 12:40

answered May 2, 2022 at 12:29

Irfanullah Jan

3,9204 gold badges32 silver badges37 bronze badges

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

Comments

0stone0 · Accepted Answer · 2022-05-02 12:22:03Z

1

Use map() to get a list of existing keys (index 0: d.map(x => x[0]))
Use filter() to get the diff between keys and existing keys
Loop over the missing keys
Add the desired array to the data array for each missing key

const data = [
    [["id", 1], ["name", "somethign"], ["age", 20]],
    [["id", 20], ["name", "somethign"]],
    [["id", 9], ["age", 10]]
];
const keys = [ "id", "name", "age", "nothing" ];

const fixed = data.map(d => {
    const existing = d.map(x => x[0]);
    const missing = keys.filter(k => !existing.includes(k));

    missing.forEach(m => d.push([ m, undefined ]));
    
    return d;
});

console.log(fixed);

answered May 2, 2022 at 12:22

0stone0

45.5k6 gold badges53 silver badges82 bronze badges

3 Comments

Nilton Schumacher F Over a year ago

This works, although it doesn't add in order, it is pushing into the last element from the arry

0stone0 Over a year ago

What do you mean order? Could you explain what needs to be changed?

Nilton Schumacher F Over a year ago

There is an example on the question, I think you would need a slice to add into that specific place. In question there is a better example

user3297291 · Accepted Answer · 2022-05-02 13:00:59Z

1

Here's an approach relying on Object.fromEntries and Object.entries:

Create an empty base object from your keys,
Loop over your data,
For each entry, create an object using Object.fromEntries
Combine that object with the empty base
Use Object.entries to transform back to an array of key-value-pairs

const data = [
  [["id", 1], ["name", "somethign"], ["age", 20]],
  [["id", 20], ["name", "somethign"]],
  [["id", 9], ["age", 10]]
];

const keys = [
  "id",
  "name",
  "age",
  "nothing"
];

const base = Object.fromEntries(keys.map(k => [k, undefined]));

console.log(
  data.map(d => Object.entries({ ...base, ...Object.fromEntries(d) }))
)

answered May 2, 2022 at 13:00

user3297291

23.5k4 gold badges33 silver badges49 bronze badges

Collectives™ on Stack Overflow

Comparison between an array and array of arrays to insert missing keys

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related