blic 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(); } } ain /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

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
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
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
Transcribed Image 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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY