need to input a .csv file into a my program, once inserted, I need to add up the sums of all the units sold per UNIQUE product ID in the same two-column layout the file started in. (Instead of multiple entries for the same Product Id, just have one with the total units sold) I can get the Sales Data.csv file to output in the console, but I can't figure out how to organize and sum up the data
Extracted text: public class Main { public static void main(String [] args) { String fileName = ".idea/Sales Data.csv"; File file = new File(fileName); try { Scanner inputStream = new Scanner(file); while (inputStream.hasNext () { String data = inputStream.nextLine(); //gets a whole line data.split(","); System.out.println(data); } inputStream.close(); } catch (FileNotFoundException e) { e.printStackTrace(); } } Main /Library/Java/JavaVirtualMachines/jdk1.8.0 71.jdk/Contents/Home/bin/java ... Product ID,Units 10002,4 10004,6 10008,2 10010,3 10010,3 10007,10 20003,4 20003,7 30019,1 30020,9 10004,9 10006,7 20005,5 30004, 10 20004,2 4: Run pilation completed successfully in 1s 282ms (moments ago) rminal E 0: Messages O 6: TODO