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
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...
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6ed3c532-77a3-4974-9b5b-271fe5c9887b%2F372ffa4e-bec3-48be-8b1e-6ff425a0e1ef%2Ff6yxnwk_processed.jpeg&w=3840&q=75)
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY