count dupplicated data on json file using java

Question

am trying to count all the duplicate data from a json file, but i dont get the right count of the data, im thinking to arrange the data before i add it to a list but its possible to arrange json data? what i think for the ouput :

component : pensil : 5 
               pen : 1

here is my codes. some tips guys thanks.

public Main1(){
    BufferedReader br = null;
    JSONParser parser = new JSONParser();
    String inputline,aa;
    List<String> list = new ArrayList<String>();
    try {
            br = new BufferedReader(new FileReader("/Users/lyod/Documents/sample.json"));
        try {
            String id = null,component = null,title = null,lat = null,
            lng = null, cost = null, status = null;
            while ((inputline = br.readLine()) != null) {
                JSONArray a = (JSONArray) parser.parse(inputline);
                for (Object o : a) {
                    JSONObject sample = (JSONObject) o;
                    id = (String) sample.get("id");
                    component = (String) sample.get("component");
                    list.add(component);
                    aa =(component+" " + Collections.frequency(list, component));
                }
                System.out.println(aa);
            }
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (ParseException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    } catch (FileNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }   
}

What is the content of your input file?

Gijs Overvliet
– Gijs Overvliet

2017-04-18 08:26:41 +00:00
Commented Apr 18, 2017 at 8:26 — Gijs Overvliet
– Gijs Overvliet, Commented Apr 18, 2017 at 8:26

Donald Raab · Accepted Answer · 2019-11-10 01:50:43Z

2

If you're open to using a third-party library, you could use a HashBag from Eclipse Collections, a HashBag from Apache Commons Collections or a HashMultiset from Guava.

You can add your items to a Bag/Multiset like any other collection, and internally they will keep track of the count for you.

Note: I am a committer for Eclipse Collections.

edited Nov 10, 2019 at 1:50

answered Apr 24, 2017 at 2:43

Donald Raab

6,8362 gold badges40 silver badges47 bronze badges

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

Comments

Martin Polak · Accepted Answer · 2017-04-18 09:41:28Z

1

I would go like this:

Create HashMap<String, Integer>, let key be component and value be number of occurences.
Go thru the json file with while as you do. For every component check the presence in hash map - if it is present, increase value by 1, if not present, put new value 1 under the key of component.
Print in cycle all keys (components) and values (count of duplicates).

You are done.

answered Apr 18, 2017 at 9:41

Martin Polak

1246 bronze badges

1 Comment

LyodMichael Over a year ago

than you @martin ill try.

Collectives™ on Stack Overflow

count dupplicated data on json file using java

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related