javascript - 格式化数据和删除键

Question

我有另一个数据问题。数据处理是我的一个真正的弱点，所以试图更好地理解它。我有一个名为 data 的变量，其中包含以下内容

[
    {"ID":1,"process":"quick","owner":"John","decission":"Admin","status":"failed","flag":"red"},
    {"ID":2,"process":"standard","owner":"Mary","decission":"Admin","status":"failed","flag":"blue"},
    {"ID":3,"process":"slow","owner":"John","decission":"Management","status":"active","flag":"red"}
]

它本质上是一个对象数组。我正在尝试将它变成一个数组，其中对象键是数组的第一行，然后是内容。
但是，我不需要 ID 或标志。所以上面看起来像这样

[
    ["process","owner","decission","status"],
    ["quick","John","Admin","failed"],
    ["standard","Mary","Admin","failed"],
    ["slow","John","Management","active"]
]

所以为了得到标题行，我正在考虑做这样的事情

const keys = Object.keys(this.data[0]);
keys.splice(keys.indexOf('ID'), 1);
keys.splice(keys.indexOf('flag'), 1);
this.formattedArray.push(keys);

然而，对我来说，这似乎是一个非常循序渐进的过程，然后我如何确保其他数据被放置在下面的正确行中？

将我的初始数据格式化为我现在需要的格式的最佳方式是什么？

谢谢

Answer 1

首先获取键，然后获取基于这些键的值。

const data = [{"ID":1,"process":"quick","owner":"John","decission":"Admin","status":"failed","flag":"red"},{"ID":2,"process":"standard","owner":"Mary","decission":"Admin","status":"failed","flag":"blue"},{"ID":3,"process":"slow","owner":"John","decission":"Management","status":"active","flag":"red"}];
const keys = Object.keys(data[0]).filter(e => !(["ID", "flag"].includes(e)));
const values = data.map(e => Object.entries(e).filter(([k]) => keys.includes(k)).map(([, v]) => v));
const res = [keys, ...values];
console.log(res);

.as-console-wrapper { max-height: 100% !important; top: auto; }