分组统计个数

【问题】

I have a text file with content like, with 792 lines:

der 17788648
und 14355959
die 10939606
Die 10480597

Now I want to compare if "Die" and "die" are equal in lowercase. So if two Strings in lowerCase are equal, copy the word into a new text file in lowerCase and sum the values.

Expected output:

der 17788648
und 14355959
die 21420203

I have that so far:

  try {
        BufferedReader bk = null;
        BufferedWriter bw = null;

        bk = new BufferedReader(new FileReader("outagain.txt"));
        bw = new BufferedWriter(new FileWriter("outagain5.txt"));

        List<String> list = new ArrayList<>();
        String s = "";
        while (s != null) {
            s = bk.readLine();
            list.add(s);
        }


        for (int k = 0; k < 793; k++) {
            String u = bk.readLine();
            if (list.contains(u.toLowerCase())) {

                //sum values?

            } else {
                bw.write(u + "\n");
            }
        }

        System.out.println(list.size());

    } catch (Exception e) {
        System.out.println("Exception caught : " + e);
    }

 

【回答】

       这是简单的分组汇总，JAVA没有通行的结构化计算类库，硬编码很繁琐。可以用SPL实现，只要一句。

	A
1	=file("d:\\data.txt").import(;," ").groups(lower(#1);sum(#2))
2	=file("d:\\result.txt").export(A1; " ")

A1：按第1个字段的小写分组，按第2个字段汇总。

A2：如果想把结果写到文件，可以再加此句。

这段代码可以方便地集成进Java，参考Java 如何调用 SPL 脚本。