How to convert json format into arrays in react-CodePudding

I am having csv data which i converted into json data and using in react.js project. Below is the sample of json file have.

export const data = [
  {
    id: 1,
    Word: "AN",
    Target: "Female",
    Weight: 0,
  },
  {
    id: 2,
    Word: "Aaron",
    Target: "Female",
    Weight: 0,
  },
  {
    id: 3,
    Word: "Abbey",
    Target: "Female",
    Weight: 0,
  }

But i want to convert the above data into below format in react.js. How can i do it

const sankeyData = [
  ["Word", "Target", "Weight"],
  ["AN", "Female", 0],
  ["Aaron", "Male", 0],
  ["Abbey","Female", 0],
];

CodePudding user response：

You can make the function with this code.

function convertFormat(data) {
  if (data.length === 0) return [];

  let new_data = [];
  let key_data = [];
  Object.keys(data[0]).map((key) => {
    if (key !== 'id') key_data.push(key);
  });
  new_data.push(key_data);

  data.map((item) => {
    let new_item = [];
    Object.values(item).map((value, index) => {
      if (index !== 0) new_item.push(value);
    });
    new_data.push(new_item);
  });
  return new_data;
}