如何映射两个csv列相对于其在Java中的值？[重复]

Question

我是Java的新手，希望根据CSV列的值映射它们。我的原始csv数据如下所示：

 name,salary,address
 AAA,1000,kkk
 BBB,880,lll
 AAA,90,kkk
 CCC,700,mmm
 BBB,700,lll

预期输出应为Hashmap键值对，两列分别为name和salary，如下所示：

Key: AAA Value 1090
Key: BBB Value 1580
Key: CCC Value 700

这是我的代码：

        String line = "";
 InputStreamReader inStream = new 
       InputStreamReader(uc.getInputStream());
        buff = new BufferedReader(inStream);  
         try {
            while ((line = b.readLine()) != null) {
                String[] fields = parseCsvLine(line);

                // I dont know what to do here



            }


            b.close();
            Log.d("Get data from API", "Processing Stop");
        } catch (IOException e) {
            e.printStackTrace();
        }

 public  String[] parseCsvLine(String line) {
    // Create a pattern to match breaks
    Pattern p =
            Pattern.compile(",(?=([^\"]*\"[^\"]*\")*(?![^\"]*\"))");
    // Split input with the pattern
    String[] fields = p.split(line);
    for (int i = 0; i < fields.length; i++) {
        // Get rid of residual double quotes
        fields[i] = fields[i].replace("\"", "");
    }
    return fields;
}

Answer 1

您想要的是将您的线条数据分割成一部分。然后将其累积到一个Map

Map<String, Integer> result = new HashMap<>();

while ((line = b.readLine()) != null) {
   String[] parts = line.split(","); // Split your line, take `,` as delimeter
   String key = parts[0]; // This is your 'AAA'
   Integer value = Integer.parseInt(parts[1]); // This is your 1000
   if (result.get(key) == null) {
       result.put(key, value); 
   } else {
       result.put(key, result.get(key) + value); // There's already a value here, add it with new value
   }


}

丑陋的部分：

   if (result.get(key) == null) {
       result.put(key, value); 
   } else {
       result.put(key, result.get(key) + value); // There's already a value here, add it with new value
   }

可以替换为新的Java8地图实用程序：

 result.putIfAbsent(key, value); // Put (key, value) if key is absent from the map
 result.compute(key, value, (k, v) -> v + value);