Program this 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,900Sabrina$51,500Aaron$46,000Chris $34,500Geoffrey $14,200CONSTRAINTS1. Write your own code to parse the data. Don't use a CSV parser2. Use string formatting to properly space out the columns. Make each column one space longer than thelongest 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. HINT: Use the sort function.5. Write comments to explain your code

Since there is no programming language is mentioned I have used python for solution , I will…

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 First Salary $65,000 $56,500 $55,900 $51,500 Xiong Fong Flores Jim Lee Zafra Cruz Cruz Swift Jason Sabrina Aaron Chris $46,000 $34,500 Geoffrey $14,200

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 First Salary $65,000 $56,500 $55,900 $51,500 Xiong Fong Flores Jim Lee Zafra Cruz Cruz Swift Jason Sabrina Aaron Chris $46,000 $34,500 Geoffrey $14,200

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Write a program in the GO programming language that creates a CSV file to store and retrieve data such as name, age, and salary. You should be able to read the data out of the file and display the data sorted by name. Hint: Make use of the Sort package to sort the data. Make sure you check the existence of the file, closing the file when there is an error Use defer, panic, and recover as needed.
A python function opens file data.csv, reads the data from the file and spits the data into three columns, x, y and z. The data is then printed out. Function: f = open("data.csv ", "r") print('x\ty\tz'.format()) for row in f: temp = row.split(',') for cell in temp: print(cell,end='\t') print() data.csv contains: 1.2,2.1,1.1 2.3,3.2,0.6 0.7,1.9,0.1 1.8,2.5,0.3 4.6,2.7,0.9
In Python: The Broadway dataset contains data for Broadway shows' Capacity (percentage of the theatre filled) and Gross Potential (maximum amount that can be earned) for multiple shows in a specific month and year. Given a CSV file name read from user input, write a program that performs the following tasks: Read in the CSV file as a dataframe. Insert a new column labelled "Size" at the end of the dataframe. The "Size" column contains values in column "Gross Potential" divided by 2. Output the dataframe using the print() function. Create a scatter plot of "Gross Potential" vs "Capacity" with the following marker styling parameters: markers: 'x' color: orange size: values in column "Size" Add the x-label ("Capacity", fontsize = 10), y-label ("Gross Potential", fontsize = 10), and title ("Gross Potential vs Capacity", fontsize = 16) to the figure. Add gridlines to the figure using '--' as linestyle. Save the figure as output_fig.png. Click here to view Input and Output Example
Question 1: Use Python (Class Average: Writing Student Records to a CSV File) An instructor teaches a class in which each student takes three exams. The instructor would like to store this information in a file named grades.csv for later use. Write code that enables an instructor to enter each student’s first name and last name as strings and the student’s three exam grades as integers. Use the csv module to write each record into the grades.csv file. Each record should be a single line of text in the following CSV format: firstname, lastname, exam1grade, exam2grade, exam3grade Question 2: (Class Average: Reading Student Records from a CSV File) Use the csv module to read the grades.csv file from the previous exercise (exercise 9.3). Display the data in tabular format, including an additional column showing each student’s average to the right of that student’s three exam grades and an additional row showing the class average on each exam below that exam’s column.
A Comma Separated Value (CSV) text file called movies.txt is located in the directory of your Eclipse Project.( If your Eclipse Project name is Assignment2, the text file is located under Assignment2, NOT src folder) It contains data for one movie on each line.Each Movie contains the following data items:Title(String), Year(int-4 digits), Runtime(double). Write Java program(s) to do the following:1) Read the movies.txt Text file and write the data as a Serialized file called movies.ser to the local directory(same as movies.txt).2) Read the movies.ser serialized file and output the data on to the Console in the format shown below. The spacing for the output is: Title(20), Year (8) and Runtime (10.2)Title and Year are left-justified, Runtime is right-justified.(You can use your own text file to test your program) Sample output: Title Year Runtime aaaaaaaaaaa aaaa aa.aa...... ...... ...........…
Geraldine’s Landscaping Service and Gerard’s LawnMaintenance are merging their businesses and want to merge theircustomer files. Each file contains a customer number, last name,address, and property area in square feet, and each file is incustomer number order. Design a program that merges the two filesinto one file containing all customers. Assume there are noidentical customer numbers. in psuedocode
Program is not run; error found in print(row) # Import the python CSV moduleimport csv# Create a python file object in read mode for the `baby_names.csv` file: csvfilecsvfile = open('baby_names.csv', 'r')# Loop over a DictReader on the filefor row in csv.DictReaderreader(csvfile): # Print each row print(row) # Add the rank and name to the dictionary: baby_names baby_names[row['RANK']] = row['NAME']# Print the dictionaryprint(baby_names.keys())
PLEASE COMMENT CODE In a python program, create a new file and call it “ tracking”. Write to it four lines each contains information about an order like this: 1-00654-021 Dell charger Toronto-WEST 99-49-ZAD011-76540-022 ASUS battery Milton-EAST 34-56-CBH561-09239-026 HP HD Scarborough-NORTH 12-98-AZC451-12349-029 Mac FD North York-LAWRENCE 34-49-ZWL01Add the file two more lines: 1-34567-055 Lenovo SSD Milton-ON 34-09-MT04 1-90432-091 Lenovo battery Oakville-ON 78-KL98 Define a function that searches for a brand (e.g. Dell, ASUS, etc.). Test the function in your program.
This is for Python - COP 1000, I have to use def main. I have attached the program I need help with (2), along with the program one instructions and code that I have below. Thank you!program6_2.pyThis program reads the text file created in the program above and displays its data. Use f-strings to create a table of rows and columns with column headings as follows: PLAYER COLUMN: 10 characters wide and left-aligned. GOALS COLUMN: 6 characters wide and centered. ASSISTS COLUMN: 8 characters wide and centered. TOTAL COLUMN: 6 characters wide and centered. After printing the stats for each player, the program should report the name of the top scorer and his total points (goals + assists).program6_1.pyWrite a program that uses a while loop to store goals and assists for Lightning players in a text file. The program should prompt the user for player names, goals, and assists as shown below. Enter data for at least five players. You can make up the names and data. Each datum should be stored…
Java Program /The Output attached by image OverviewYou should enter this task, ask the user for a word and then search for a file to see if that word is among the words in the file. Task This exercise comes with three text files named wordlist1.txt, wordlist2.txt and wordlist3.txt. These files contain a large amount of words in English. Each file contains more and more words. Each word in these files is on a separate line and the words contain only lowercase letters. Your task is to write a program that reads all these words from the file and checks if a keyword, which the user entered, is among the entered words. The program should also count the total number of words contained in the file used. The program should measure how long it takes to complete the search, ie how long it takes to read all the words and check if the keyword is among the words or not. The program should start by asking the user for the word to be searched for. Then the words in the file should be counted and…
Java Program /The Output attached by image OverviewYou should enter this task, ask the user for a word and then search for a file to see if that word is among the words in the file. Task This exercise comes with three text files named wordlist1.txt, wordlist2.txt and wordlist3.txt. These files contain a large amount of words in English. Each file contains more and more words. Each word in these files is on a separate line and the words contain only lowercase letters. Your task is to write a program that reads all these words from the file and checks if a keyword, which the user entered, is among the entered words. The program should also count the total number of words contained in the file used. The program should measure how long it takes to complete the search, ie how long it takes to read all the words and check if the keyword is among the words or not. The program should start by asking the user for the word to be searched for. Then the words in the file should be counted and…
Implement a simplified grocery Webshop in C programming language. Create a structure that contains a set of products and their number. A product has a name, price and quantity. Create two instances of this structe. The first represents the webshop store and the other represents a cart. Print a menu for the user that contains the following items: Load webshop store from a file\ This operation loads the content of the store from a text file. The filename should be read from the keyboard. The file contains the product name, price and quantity in the following format:Apple 100 42 Orange 130 59 Raspberry 231 17 ... Write the content of the store to a file\ Read a filename from the user and write the content of the store to that file using the file format above. Insert an item to cart\ The cart contains the items that a customer wants to buy. Read a product name and the quantity from the keyboard and put this information to the cart. The price of the product should be fetched from the…