Set first element of nested array as object keys

Question

I have an array like this:

var values = Array ( );

values [0] = Array ("", "Guest1", "Guest2", "Guest3")
values [1] = Array ("Name", "Hans", "Carl", "Peter")
values [2] = Array ("City", "Berlin", "Tokio", "Washington")
values [3] = Array ("Phone", "123", "234", "345")

I would like to create an object like this:

var data= {
   Guest1: { "Name" : "Hans", "City" : "Berlin", "Phone" : "123" },
   Guest2: { "Name" : "Carl", "City" : "Tokio", "Phone" : "234" },
   Guest3: { "Name" : "Peter", "City" : "Washington", "Phone" : "345" },
};

I got the first key using:

const data = Object.fromEntries(values[0].map(key => [key, 0]));
    delete data[""];

However, I am struggling to create the rest of the object.

how are you getting this data? There has to be a way to receive it in a more meaningful shape. — pilchard
– pilchard, Commented Nov 11, 2022 at 23:40
I get it from a google sheet, the code for this is const response = await fetch( sheets.googleapis.com/v4/spreadsheets/${ID}/values/${RANGE}?key=${API_KEY}` ); const { values } = await response.json();` — Co0n
– Co0n, Commented Nov 11, 2022 at 23:42

pilchard · Accepted Answer · 2022-11-11 23:55:57Z

2

I would highly recommend finding a way to query your data in a more meaningful shape, but it can be wrangled.

const values = [
  ["", "Guest1", "Guest2", "Guest3"],
  ["Name", "Hans", "Carl", "Peter"],
  ["City", "Berlin", "Tokio", "Washington"],
  ["Phone", "123", "234", "345"],
]

const [header, ...rows] = values;

const data = {};
for (const [key, ...row] of rows) {
  for (const [i, value] of row.entries()) {
    (data[header[i + 1]] ??= {})[key] = value;
  }
}

console.log(data);

Reference:

edited Nov 11, 2022 at 23:55

answered Nov 11, 2022 at 23:48

pilchard

13.1k5 gold badges14 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Set first element of nested array as object keys

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