Count occurrence of strings in JSON array

Question

I have the JSON response below and I want to count the occurrence of string matches in the "ref_id" objects. But I have no idea where to start when looping through the array and counting the matches. Any help or recommendation where I should start would be appreciated

{
"tag": "checkthisServer",
"success": 1,
"error": 0,
"svd_ids": [
    {
        "ref_id": "f91e2651"
    },
    {
        "ref_id": "f91e2651"
    },
    {
        "ref_id": "ue87sr5d"
    },
    {
        "ref_id": "f91e2651"
    }
    {
        "ref_id": "ue87sr5d"
    }
]
}

Output should be:

f91e2651: 3
ue87sr5d: 2

Look up JSONArray. Loop through and put initial result in Hashmap. If ref_id is already in Hahsmap then increment value. — Scary Wombat
– Scary Wombat, Commented Feb 24, 2014 at 5:00

ρяσѕρєя K · Accepted Answer · 2014-02-24 05:04:23Z

6

You can do it using Collections.frequency on ArrayList. so first get JSONArray from JSONObeject then convert it to ArrayList as:

JSONObject mainobj=new JSONObject("your json string");
// get svd_ids JSONArray
JSONArray json_array=mainobj.getJSONArray("svd_ids");

// get ArrayList from JSONArray

   ArrayList<String> listsvd_ids = new ArrayList<String>();  
   for (int i=0;i<json_array.length();i++){ 
    listsvd_ids.add(json_array.get(i).toString());
   } 

//  occurrence of f91e2651
int occur_f91e2651 = Collections.frequency(listsvd_ids, "f91e2651");
//  occurrence of ue87sr5d
int occur_ue87sr5d = Collections.frequency(listsvd_ids, "ue87sr5d");
//.....

answered Feb 24, 2014 at 5:04

ρяσѕρєя K

133k54 gold badges203 silver badges216 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vikku · Accepted Answer · 2019-02-18 05:10:10Z

0

Try This : Here filterValues is your JSON

filterValues = filterValues.reduce((newObj, obj) => {
let value = 1;
if(newObj[obj[ref_id]]) {
   value = value + 1;
   newObj[obj[ref_id]] = obj[ref_id] + ' (' + value + ')';
} else {
    newObj[obj[ref_id]] = obj[ref_id] + ' (' + value + ')';
}            
return newObj;
}, {});

answered Feb 18, 2019 at 5:10

Vikku

1

Comments

Sam · Accepted Answer · 2015-08-20 20:11:15Z

-1

Try this,

JSONArray responseArray = jsonObject.getJSONArray("svd_ids");
int countFirst = 0, countSecond = 0;

for (int i = 0; i < responseArray.length(); i++) {
    JSONObject obj = responseArray.getJSONObject(i);
    if (obj.optString("ref_id").equals("f91e2651") {
        countFirst = countFirst + 1;
    }
    if (obj.optString("ref_id").equals("ue87sr5d") {
        countSecond = countSecond + 1;
    }
}

edited Aug 20, 2015 at 20:11

Sam

7,41216 gold badges48 silver badges68 bronze badges

answered Feb 24, 2014 at 5:04

Ravind Maurya

98715 silver badges26 bronze badges

Collectives™ on Stack Overflow

Count occurrence of strings in JSON array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related