Divide and conquer Excel data with JavaScript based on a specific key

Question

Divide and conquer Excel data with JavaScript based on a specific key

My current task involves extracting data from Excel using JavaScript. The extracted output is structured as follows:

{
    
    "Responsible": "Grey",
    "Goal": 0.823,
    "Jan": 0.8621397507374327,
    "Feb": 0.8605700219733681,
    "Mrz": 0.8870898346258058,
    "Apr": 0.8529801908413164,
    "Mai": 0.8507431241640211
  }

To enhance the presentation of this data, I aim to split it into smaller subsets like below:

         {   
            "Responsible": "Grey",
            "Goal": 0.823,
            "Month": 0.8621397507374327,  
          }


         {  
           "Responsible": "Grey",
            "Goal": 0.823,
            "Month": 0.8605700219733681,
         }
         
         {   
            "Responsible": "Grey",
            "Goal": 0.823,
            "Month": 0.8870898346258058, 
          }


         {  
           "Responsible": "Grey",
            "Goal": 0.823,
            "Month": 0.8529801908413164,
         }

         {  
           "Responsible": "Grey",
            "Goal": 0.823,
             "Month": 0.8507431241640211
         }

Below is a snippet of my code implementation for achieving this:

Ausgabe = [];     

_.forEach(data, element => {  
  obj = {
     
    Responsible: element.Responsible,
    Goal: element["Goal \r\n2022"]  ,
    Jan : element["Jan-22"],
    Feb: element["Feb-22"],
    Mrz : element["Mar-22"],
    Apr : element["Apr-22"],
    Mai : element["May-22"],
    
  }
  Ausgabe.push(obj)
    

})

The 'data' field holds the necessary information and can be manipulated if needed. It is expected to return the processed data upon completion.

javascript json excel lodash

Answer 1

Answer №1

Utilize destructuring for extracting Responsible, Goal, and the remaining properties of the object. Make use of Object.entries() to obtain an array of [key, value] pairs from rest, then iterate through it using Array.map() to form new objects:

const fn = ({ Responsible, Goal, ...rest }) =>
  Object.entries(rest)
    .map(([k, v]) => ({
      Responsible,
      Goal,
      [k]: v
    }))

const obj = { "Responsible": "Grey", "Goal": 0.823,  "Jan": 0.8621397507374327, "Feb": 0.8605700219733681, "Mrz": 0.8870898346258058, "Apr": 0.8529801908413164, "Mai": 0.8507431241640211 }

const result = fn(obj)

console.log(result)

If you are interested only in the month's values, opt for using Object.values() instead of entries:

const fn = ({ Responsible, Goal, ...rest }) =>
  Object.values(rest)
    .map(Month => ({
      Responsible,
      Goal,
      Month
    }))

const obj = { "Responsible": "Grey", "Goal": 0.823,  "Jan": 0.8621397507374327, "Feb": 0.8605700219733681, "Mrz": 0.8870898346258058, "Apr": 0.8529801908413164, "Mai": 0.8507431241640211 }

const result = fn(obj)

console.log(result)

Answer 2

Utilize destructuring for extracting Responsible, Goal, and the remaining properties of the object. Make use of Object.entries() to obtain an array of [key, value] pairs from rest, then iterate through it using Array.map() to form new objects:

const fn = ({ Responsible, Goal, ...rest }) =>
  Object.entries(rest)
    .map(([k, v]) => ({
      Responsible,
      Goal,
      [k]: v
    }))

const obj = { "Responsible": "Grey", "Goal": 0.823,  "Jan": 0.8621397507374327, "Feb": 0.8605700219733681, "Mrz": 0.8870898346258058, "Apr": 0.8529801908413164, "Mai": 0.8507431241640211 }

const result = fn(obj)

console.log(result)

If you are interested only in the month's values, opt for using Object.values() instead of entries:

const fn = ({ Responsible, Goal, ...rest }) =>
  Object.values(rest)
    .map(Month => ({
      Responsible,
      Goal,
      Month
    }))

const obj = { "Responsible": "Grey", "Goal": 0.823,  "Jan": 0.8621397507374327, "Feb": 0.8605700219733681, "Mrz": 0.8870898346258058, "Apr": 0.8529801908413164, "Mai": 0.8507431241640211 }

const result = fn(obj)

console.log(result)

Divide and conquer Excel data with JavaScript based on a specific key

Answer №1

Similar questions

Creating custom markers with an API in Vue-2-Leaflet

Learn how to eliminate all text characters from a string using jQuery, leaving only the numerical values behind

Enhancing a three.js project with point-and-click functionality while utilizing OrbitControls

Issues with texturing in ThreeJS

Storing a Nested JSON Object in an ArrayList for MultiLevel ExpandableListView on Android

I'm currently experiencing an issue where I am not receiving the Validation Flash Message in the UI. Instead, I am seeing a flash error displaying as [object Object],[object

Assigning a variable within a parent function from a child function in JavaScript

React Redux component fails to reflect changes in props after store update

Using jQuery to show text upon hover using a `for` loop

Retrieving event.data from the input handler on a textarea element

What is the best way to extract data from a JSON-encoded string in PHP?

Header reference differs from the document referrer

What is preventing the expected outcome of setting this as a background image in NextJS 13 with Tailwind CSS?

Using Vue to append elements that are not part of the loop

Is it possible to combine ng-switch and ng-if directives in Angular?

Is it possible for the versions in the package.json file to be altered

Exploration into the Working Environments of JavaScript and Python

The NodeJS module 'request' is producing symbols instead of expected HTML content

Tips for ensuring that the dropdown is always visible in v-autocomplete/v-select

Parsing string to JSON object and extracting specific information