Sometimes data comes in as a structured format that you have to break down and turn into records so youcan process them. CSV, or comma-separated values, is a common standard for doing this.Construct a program that reads in the following data file:Lee, Jason, 55900Flores, Jim, 56500Cruz, Aaron, 46000Cruz, Chris, 34500Swift, Geoffrey, 14200Xiong, Fong, 65000Zafra,Sabrina,51500Process the records and display the results formatted as a table, evenly spaced, as shown in the exampleoutput.EXAMPLE OUTPUTLastXiongFloresLeeZafraCruzCruzSwiftFirst SalaryFong$65,000Jim$56,500Jason$55,900$51,500$46,000$34,500Geoffrey $14,200SabrinaAaronChrisCONSTRAINTS1. Write your own code to parse the data. Don't use a CSV parser. (3 points)2. Use string formatting to properly space out the columns. Make each column one space longer than thelongest value in the column. (4 points)3. Format the salary as currency with dollar signs and commas. (2 points)4. Sort the results by salary from highest to lowest HINT: Use the sort function. (4 points)5. Write comments to explain your code. (2 point)

Sometimes data comes in as a structured format that you have to break down and turn into records so you can process them. CSV, or comma-separated values, is a common standard for doing this. Construct a program that reads in the following data file: Lee, Jason, 55908 Flores, Jin, 56500 Cruz, Aaron, 46000 Cruz, Chris, 34500 Swift, Geoffrey, 14200 Xiong, Fong, 65000 Zafra, Sabrina, 51500 Process the records and display the results formatted as a table, evenly spaced, as shown in the example output. EXAMPLE OUTPUT Last First Salary Xiong Fong $65,000 Flores Jim $56,500 $55,900 Lee Zafra Cruz Cruz Swift Jason Sabrina Aaron Chris $51,500 $46,000 $34,500 Geoffrey $14,200 CONSTRAINTS 1. Write your own code to parse the data. Don't use a CSV parser. (3 points) 2. Use string formatting to properly space out the columns. Make each column one space longer than the longest value in the column. (4 points) 3. Format the salary as currency with dollar signs and commas. (2 points) 4. Sort the results by salary from highest to lowest. HINT: Use the sort function. (4 points) 5. Write comments to explain your code. (2 point)

Sometimes data comes in as a structured format that you have to break down and turn into records so you can process them. CSV, or comma-separated values, is a common standard for doing this. Construct a program that reads in the following data file: Lee, Jason, 55908 Flores, Jin, 56500 Cruz, Aaron, 46000 Cruz, Chris, 34500 Swift, Geoffrey, 14200 Xiong, Fong, 65000 Zafra, Sabrina, 51500 Process the records and display the results formatted as a table, evenly spaced, as shown in the example output. EXAMPLE OUTPUT Last First Salary Xiong Fong $65,000 Flores Jim $56,500 $55,900 Lee Zafra Cruz Cruz Swift Jason Sabrina Aaron Chris $51,500 $46,000 $34,500 Geoffrey $14,200 CONSTRAINTS 1. Write your own code to parse the data. Don't use a CSV parser. (3 points) 2. Use string formatting to properly space out the columns. Make each column one space longer than the longest value in the column. (4 points) 3. Format the salary as currency with dollar signs and commas. (2 points) 4. Sort the results by salary from highest to lowest. HINT: Use the sort function. (4 points) 5. Write comments to explain your code. (2 point)

C++ for Engineers and Scientists

4th Edition

ISBN:9781133187844

Author:Bronson, Gary J.

Publisher:Bronson, Gary J.

Chapter8: I/o Streams And Data Files

Section: Chapter Questions

Problem 8PP: (Data processing) A bank’s customer records are to be stored in a file and read into a set of arrays...

See similar textbooks

Similar questions

Program this Sometimes data comes in as a structured format that you have to break down and turn into records so you can process them. CSV, or comma-separated values, is a common standard for doing this. Construct a program that reads in the following data file: Lee, Jason, 55908 Flores, Jim, 56500 Cruz, Aaron, 46000 Cruz, Chris, 34500 Swift, Geoffrey, 14200 Xiong, Fong, 65000 Zafra, Sabrina,51500 Process the records and display the results formatted as a table, evenly spaced, as shown in the example output. EXAMPLE OUTPUT Last First Salary $65,000 $56,500 $55,900 Xiong Fong Flores Jim Lee Jason Zafra Sabrina Cruz Aaron Cruz Chris Swift $51,500 $46,000 $34,500 Geoffrey $14,200 CONSTRAINTS 1. Write your own code to parse the data. Don't use a CSV parser 2. Use string formatting to properly space out the columns. Make each column one space longer than the longest value in the column. 3. Format the salary as currency with dollar signs and commas. 4. Sort the results by salary from highest…
A new video store in your neighborhood is about to open. However, it does not have a program to keep track of its videos and customers. The store managers want someone to write a program for their system so that the video store can operate. The program will require you to design 2 ADTs as described below: [1] VIDEO ADT Data Operations Video_ID (preferably int, auto-generated) Movie Title Genre Production Number of Copies Movie Image Filename [1] Insert a new video [2] Rent a video; that is, check out a video [3] Return a video, or check in, a video [4] Show the details of a particular video [5] Display all videos in the store [6] Check whether a particular video is in the store [2] CUSTOMER PARENT ADT Data Operations Customer_ID (preferably int, auto-generated) Name Address [1] Add Customer [2] Show the customer details [3] Print list of all customers [3] CUSTOMER-RENT CHILD ADT Customer_ID ( Video_ID (of all rented videos of a…
Sometimes data comes in as a structured format that you have to break down and turn into records so you can process them. CSV, or comma-separated values, is a common standard for doing this. Construct a program that reads in the following data file: Lee, Jason, 55900 Flores, Jim, 56500 Cruz, Aaron, 46000 Cruz, Chris, 34500 Swift, Geoffrey, 14200 Xiong, Fong, 65000 Zafra,Sabrina,51500 Process the records and display the results formatted as a table, evenly spaced, as shown in the example output. EXAMPLE OUTPUT Last Xiong Flores Lee Zafra Cruz Cruz Swift First Salary Fong $65,000 Jim $56,500 Jason $55,900 Sabrina $51,500 Aaron $46,000 Chris $34,500 Geoffrey $14,200 CONSTRAINTS 1. Write your own code to parse the data. Don't use a CSV parser 2. Use string formatting to properly space out the columns. Make each column one space longer than the longest value in the column. 3. Format the salary as currency with dollar signs and commas. 4. Sort the results by salary from highest to lowest.…
Virus DNA files As a future doctor, Jojo works in a laboratory that analyzes viral DNA. Due to the pandemic During the virus outbreak, Jojo received many requests to analyze whether there was any viral DNA in the patient. This number of requests made Jojo's job even more difficult. Therefore, Jojo ask Lili who is a programmer for help to make a program that can read the file containing the patient's DNA data and viral DNA and then match them. If on the patient's DNA found the exact same string pattern, then write to the index screen the found DNA. Data contained in the file testdata.in Input Format The first line of input is the number of test cases TThe second row and so on as many as T rows are the S1 string of patient DNA and the S2 string of viral DNA separated by spaces Output Format The array index found the same string pattern. Constraints 1 ≤ T ≤ 1003 ≤ |S2| ≤ |S1| ≤ 100|S| is the length of the string.S will only consist of lowercase letters [a-z] Sample Input (testdata.in)…
A new video store in your neighborhood is about to open. However, it does not have a program to keep track of its videos and customers. The store managers want someone to write a program for their system so that the video store can operate. The program will require you to design 2 ADTs as described below: [1] VIDEO ADT Data Operations Video_ID (preferably int, auto-generated) Movie Title Genre Production Number of Copies Movie Image Filename [1] Insert a new video [2] Rent a video; that is, check out a video [3] Return a video, or check in, a video [4] Show the details of a particular video [5] Display all videos in the store [6] Check whether a particular video is in the store [2] CUSTOMER PARENT ADT Data Operations Customer_ID (preferably int, auto-generated) Name Address [1] Add Customer [2] Show the customer details [3] Print list of all customers [3] CUSTOMER-RENT CHILD ADT Customer_ID ( Video_ID (of all rented videos of a…
JAVA PPROGRAM Write a program that prompts the user to enter a file name, then opens the file in text mode and reads names. The file contains one name on each line. The program then compares each name with the name that is at the end of the file in a symmetrical position. For example if the file contains 10 names, the name #1 is compared with name #10, name #2 is compared with name #9, and so on. If you find matches you should print the name and the line numbers where the match was found. While entering the file name, the program should allow the user to type quit to exit the program. If the file with a given name does not exist, then display a message and allow the user to re-enter the file name. The file may contain up to 100 names. You can use an array or ArrayList object of your choosing, however you can only have one array or ArrayList. Input validation: a) If the file does not exist, then you should display a message "File 'somefile.txt' is not found." and allow the…
c program that coverts a txt file input1.txt and converts it into a 2d array input1.txt looks like this Spain Republic of Ireland United Kingdom Ukraine Russia United States of America China Taiwan Australia Hong Kong Italy
C programming language Topic : Input/Output Program : Product list (product.c) Definition : The program reads a series of items form a file and displays the data in columns. The program obtains the file name from the command line. Each line of the file will have the following form: item, mm-dd-yyyy, price For example, suppose that the file contains the following lines: 123, 12.00, 12/25/2006 124, 18.30, 1/10/2020 Expected output: Item Unit Purchase Price Date 123 $ 12.00 12/25/2006 124 $ 18.30 1/10/2020
C# please Write a program that will create file with at least 10 lines. Each line of your file should have information delimited by some delimiter (I.e., commas, spaces, slashes, symbols, etc.). After your file has been created with the proper amount of data, you should read your file line by line and display without the delimiters in the same program after closing your writer. Additionally, the information stored into your file should be data that is gathered from a separate class. Your program should save your file in a specific directory. To promote flexibility, your program should check to see if the chosen directory exists prior creating it, and if it does not exist, your program should create it for you. Additionally, you should allow the user to enter the names of the directory and file instead of hard-coding it into your program.
JAVA INTRO The answer last time was incorrect It did not use text files!!!!. Create a program that generates a report that displays a list of students, classes they are enrolled in and the professor who teaches the class. There are 3 files that provide the input data: 1. FinalRoster.txt List of students and professors ( The first value of each row indicates if it is a student or professor; S means a student , P means a professor) Student and Professor have different data Student row: "S",Student Name, StudentID Professor row: "P", Professor Name, Professor ID, Highest Education 2. FinalClassList.txt List of classes and professor who teach them Each row contains the following information: ClassID, ClassName, ID of Professor who teach that class The professor ID in this file matches the Professor ID in FinalRoster.txt. 3. FinalStudentClassList.txt List of classes the students are enrolled in. (StudentID, ClassID) Student ID matches Student ID in FinalRoster.txt and ClassID…
C++A new video store in your neighborhood is about to open. However, it does not have a program to keep track of its videos and customers. The store managers want someone to write a program for their system so that the video store can operate. The program will require you to design 2 ADTs as described below: [1] VIDEO ADT Data Operations Video_ID (preferably int, auto-generated) Movie Title Genre Production Number of Copies Movie Image Filename [1] Insert a new video [2] Rent a video; that is, check out a video [3] Return a video, or check in, a video [4] Show the details of a particular video [5] Display all videos in the store [6] Check whether a particular video is in the store [2] CUSTOMER PARENT ADT Data Operations Customer_ID (preferably int, auto-generated) Name Address [1] Add Customer [2] Show the customer details [3] Print list of all customers [3] CUSTOMER-RENT CHILD ADT Customer_ID ( Video_ID (of all rented videos of a…
C-Programming Write a program that tells you how many words in a text file are unique (meaning the word only appears once in the text file). List of words in text file:…