计数某些JSON元素 [英] Counting certain JSON elements

问题描述

我有一个JSON对象allDataJson，它有大约500个对象，看起来像这样:

I have a JSON object allDataJson which have around 500 objects and looks like this:

[{"Researchers":"Karri, Ismo","Year":"2013","Title":"A"},
 {"Researchers":"Grigori, Ahmed, Roope, Arto, Daisuke, Arasawa,IkeHama","Year":"2015","Title":"B"},
 {"Researchers":"Grigori, Ahmed, Roope, Arto, Daisuke","Year":"2015","Title":"C"},
{"Researchers":"Grigori, Ahmed, Roope, Arto, Daisuke","Year":"2014","Title":"D"}]

我需要创建另一个具有以下结构的JSON对象:

I need to create another JSON object with the following structure:

var json =[
        {"Published": [[2013, 1]],
         "Total": 1,
         "Researcher": "Karri"},
        {"Published": [[2015, 2], [2014, 1]],
            "Total": 3,
            "Researcher": "Grigori"}
        //for all of the researchers]

(例如，Karri在2013年发表了1篇文章，Grigori在2015年发表了2篇文章，在2014年发表了1篇文章，等等)

(For example, Karri published 1 article in 2013, Grigori published 2 articles in 2015 and 1 article in 2014 etc.)

到目前为止，我只能按以下方式将Total和Researcher名称推送到json对象.关于如何将发布的值推送到Json对象的任何想法吗?

So far I could only push the Total and Researcher names to json object as follows. Any ideas about how to push Published values to the Json object?

这是我的代码:

function FlowChartJson(fullnames, allDataJson){

    var occurences = { };
    var json =[];

    for (var i = 0; i < fullnames.length; i++) {
        if (typeof occurences[fullnames[i]] == "undefined") {
            occurences[fullnames[i]] = 1;
        } else {
            occurences[fullnames[i]]++;
        }
    }

    for(var name in occurences){
        json.push(
            {"Researcher":name,
                "Total":occurences[name]
            });

    }
    return json;
} 

推荐答案

我已经完成了一些编码.看看它，让我知道这是否是您想要的:)

I have done some coding. Have a look at it and let me know if this is what you wanted :)

var allDataJson = [{"Researchers":"Karri, Ismo","Year":"2013","Title":"A"},
 {"Researchers":"Grigori, Ahmed, Roope, Arto, Daisuke, Arasawa,IkeHama","Year":"2015","Title":"B"},
 {"Researchers":"Grigori, Ahmed, Roope, Arto, Daisuke","Year":"2015","Title":"C"},
{"Researchers":"Grigori, Ahmed, Roope, Arto, Daisuke","Year":"2014","Title":"D"}];


var formatted = allDataJson.reduce(function (prev, value) {

    var researcher,
        researcherObj,
        researchers = value.Researchers.split(',');
    for (var i = 0; i < researchers.length; i++) {

        researcher = researchers[i].trim();
        researcherObj = prev[researcher];
        if (researcherObj) {
            if (researcherObj[value.Year]) {
                researcherObj[value.Year]++;
            } else {
                researcherObj[value.Year] = 1;
            }
        } else {
            researcherObj = {};
            researcherObj[value.Year] = 1;
            prev[researcher] = researcherObj;
        }

    }

    return prev;

}, {});

var count,
    detail,
    output = [],
    published;
for (var researcher in formatted) {

    count = 0;
    published = [];
    if (formatted.hasOwnProperty(researcher)) {
        detail = {
            Researcher: researcher
        };
        researchDetails = formatted[researcher];
            
        for (var researchDetail in researchDetails) {
    
            if (researchDetails.hasOwnProperty(researchDetail)) {
                count += researchDetails[researchDetail];
                published.push([parseInt(researchDetail, 10), researchDetails[researchDetail]]);
            }
        
        }
        
        detail.Published = published;
        detail.Total = count;
        output.push(detail);
    
    }
    
}

console.log(JSON.stringify(output));
alert(JSON.stringify(output));

根据您的需要修改此逻辑:)

Modify this logic as per your need :)

这篇关于计数某些JSON元素的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！