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],
];
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;
}