javascript - JS converting nested objects into an array of objects -


i have this:

var dataset = {  data: {     department: [         {            "marketing": [             { "employee_1": "1210" },             { "employee_2": "3241" },             { "employee_3": "6510" },             { "employee_4": "9510" }            ]         },         {            "sales": [           { "employee_1": "5210" },           { "employee_2": "1241" },           { "employee_3": "8510" },           { "employee_4": "2510" }           ]         },         {            "rd": [           { "employee_1": "1010" },           { "employee_2": "9241" },           { "employee_3": "9430" },           { "employee_4": "3510" }           ]         },         ...     ] }

}

and need this: 

const data = [           {name: 'marketing', low: 2, medium: 4, high: 3},           {name: 'sales', low: 3, medium: 1, high: 5},           {name: 'rd', low: 6, medium: 1, high: 2},           ...     ];

where: 

low     employee_x < 2000  medium  employee_x >= 2000 && employee_x < 5000 high    employee_x >= 5000

my last attempt this:

    var low_arr_dept = [];     var medium_arr_dept = [];     var high_arr_dept = [];      (var in dataset.data) {                 var department = departments_data[i];                          (var d in department) {                             var score = department[d];                             (var j in score) {                                  if (object.values(department[d][j]) >= 5000) {                                     console.log("object.values(department[d][j]) ", object.values(department[d][j]))                                     low_arr_dept.push({                                          score: object.values(department[d][j])                                     });                                 } else if (object.values(department[d][j]) >= 2000 && object.values(department[d][j]) < 5000) {                                     medium_arr_dept.push({                                          score: object.values(department[d][j])                                     });                                 } else if (object.values(department[d][j])  <2000) {                                     high_arr_dept.push({                                          score: object.values(department[d][j])                                     });                                 }                               }                          }              }                // creating arrays , getting length             low_arr_dept_marketing.length.tostring()             medium_arr_dept_marketing.length.tostring()             high_arr_dept_marketing.length.tostring()  // creating this: const data = [           {name: 'marketing', low: low_arr_dept_marketing.length, medium: medium_arr_dept_marketing.length, high: high_arr_dept_marketing.length},           {name: 'sales', low: low_arr_dept_sales.length, medium: medium_arr_dept_sales.length, high: high_arr_dept_sales.length},           {name: 'rd'low: low_arr_dept_rd.length, medium: medium_arr_dept_rd.length, high: high_arr_dept_rd.length},           ...     ];

you use array groups , hash table departments.

var dataset = { data: { department: [{ marketing: [{ employee_1: "1210" }, { employee_2: "3241" }, { employee_3: "6510" }, { employee_4: "9510" }] }, { sales: [{ employee_1: "5210" }, { employee_2: "1241" }, { employee_3: "8510" }, { employee_4: "2510" }] }, { rd: [{ employee_1: "1010" }, { employee_2: "9241" }, { employee_3: "9430" }, { employee_4: "3510" }] }] } },      groups = [{ key: 'low', value: 2000 }, { key: 'medium', value: 5000 }, { key: 'high', value: infinity }],                  hash = {},      result = [];    dataset.data.department.foreach(function (o) {      var dept = object.keys(o)[0];      o[dept].foreach(function (p) {          var value = p[object.keys(p)[0]],              group = groups.find(g => +value < g.value).key;            if (!hash[dept]) {              hash[dept] = { name: dept };              groups.foreach(g => hash[dept][g.key] = 0);              result.push(hash[dept]);          }          hash[dept][group]++;      });  });        console.log(result);
.as-console-wrapper { max-height: 100% !important; top: 0; }


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more