Question 3 [20 marks]:Suppose you are given a text file named "Cars", in which each line of the file contains the model, year andprice of a car, separated by ";". Your program should read the "Cars" file and save the data into anothertext file named "Result", such that the car price of vear 2019 should be increased by 5%. Also, output thenumber of cars with updated prices, as shown in the example below.Cars.txtResult.txtPatrol;2019;21000.000Corrolla;2018;6000.000Yaris;2019;7875.000Mazda6;2017;8000.000Number of cars with updated prices = 2Patrol;2019;20000.000Corrolla;2018;6000.000Yaris;2019;7500.000Mazda6;2017;8000.000

Suppose you are given a text file named "Cars", in which each line of the file contains the model, year and price of a car, separated by ";". Your program should read the "Cars" file and save the data into another text file named "Result", such that the car price of year 2019 should be increased by 5%. Also, output tne number of cars with updated prices, as shown in the example below. Cars.txt Result.txt Patrol;2019;20000.000 Corrolla;2018;6000.000 Yaris;2019;7500.000 Mazda6;2017;8000.000 Patrol;2019;21000.000 Corrolla;2018;6000.000 Yaris;2019;7875.000 Mazda6;2017;8000.000 Number of cars with updated prices = 2

Suppose you are given a text file named "Cars", in which each line of the file contains the model, year and price of a car, separated by ";". Your program should read the "Cars" file and save the data into another text file named "Result", such that the car price of year 2019 should be increased by 5%. Also, output tne number of cars with updated prices, as shown in the example below. Cars.txt Result.txt Patrol;2019;20000.000 Corrolla;2018;6000.000 Yaris;2019;7500.000 Mazda6;2017;8000.000 Patrol;2019;21000.000 Corrolla;2018;6000.000 Yaris;2019;7875.000 Mazda6;2017;8000.000 Number of cars with updated prices = 2

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

Related questions

Q: The attached file, CommonFemaleNames.txt, contains the top 1000 female names in the United States.…

A: The answer given as below:

Q: A MyPetStore sells many pets and their accessories. As new pets are added to the MyPetStore, their…

A: Step 1: Implementation of Pet class: class Pet { private String name; private LocalDate…

Q: Write a program to implement the algorithm that you designed in Exercise 20 of Chapter 1. (Assume…

A: Required C++ code provided below :

Q: This program reads the text file created in the program above and displays its data. Use f-strings…

A: I have implemented the given requirements as per the instructions. I have stored the details of the…

Q: ython!!!!! Create a function, showEmployment. It will have three arguments. 1. Employees:…

A: Python is the code in which that can emphasis the significant that has the object-oriented…

Q: This week’s assignments deal with files and nested loops. Input: The program prompts for the name of…

A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: AHPA #12: Movie Titles & Star Wars * * From a data file ("Lesson 14 - Movie Data"), read in data…

A: In this question we have to code in C program where we have two tasks:Data Analysis of Movie Titles…

Q: Building off the game you wrote a couple of weeks ago, called "21," you are going to add file…

A: Answer: Hare no specify any programing language so we have written code in C++ programming

Q: File names: color_square.py, chessboard.py, test_squares.py Positions on a chess board are…

A: chessboard.py Algorithm:Algorithm for check_valid_row(row): 1. If row is an integer: 1.1.…

Q: Using C++ Language Create a file named data.dat and enter the following numeric data: 10 15 11 12…

A: Here I written C++ code as per your problem. I hope you like it.

Q: Given the file name of a .tsv file read from user input containing student names and the respective…

A: This Python program is designed to efficiently analyze and present key insights from a .tsv file…

Q: Last lab, we modified the inventory program to write a file. This lab, we’ll modify it to read a…

A: We are using ifstream class to read a content of file First create a object of ifstream class Then…

Q: Input File The input file is a dataset containing addresses, neighborhoods and rent prices from 2020…

A: ANSWER:-

Q: Using Python A file named data.txt contains an unknown number of lines, each consisting of a single…

A: The answer is as follows

Q: containing a list of photo file names. The program then reads the photo file names from the text…

A: Code: file = open("ParkPhotos.txt") for i in file: temp = i.strip().replace(…

Q: Create a function called def histogram(csvfilename) that draws a histogram of the scores in the csv…

A: The Python code is given below with output screenshot

Q: The file disney_characters.csv contains a list of some Disney characters with their names, birthdays…

A: Compiled Code new_disney_characters.pyimport csv# Create a list of datadata = [ ["Name",…

Q: The international Olympics Committee has asked you to write a program to process their data and…

A: The answer is given below:-

Q: "### Exercise 2 Working with a file and numbers ###\n", "\n", "The file grades.txt has the grade for…

A: The required python program code by using the file operation is given in the next step.

Q: The Pinewood Derby involves racing Derby cards down multiple lanes and calculating the average time…

A: racers=int(input("Enter number of racers: ")) times=[] for i in range(racers): time=int(input("Enter…

Q: We are interested in finding outlier temperatures and comparing t run average.

A: SOURCE CODE #!/usr/bin/python3import csv CSV_FILE = input("Temperature anomaly file name:") with…

Q: In Python: The Broadway dataset contains data for Broadway shows' Capacity (percentage of the…

A: Algorithm: Broadway Dataset Processing and Visualization1. Start2. Prompt user to input the CSV file…

Concept explainers

Variables and Constant

Constants and variables are widely used in mathematical equations and expressions. They are also commonly found in the domain of programming, where each language has its own way to differentiate between a constant and a variable. Since they have all sorts of applications, knowing their differences is a good place to start.

Question

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!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

>> classicVinyls.cpp For the following program, you will use the text file called “vinyls.txt” attached to this assignment. The file stores information about a collection of classic vinyls. The records in the file are like the ones on the following sample: Led_Zeppelin Led_Zeppelin 1969 1000.00 The_Prettiest_Star David_Bowie 1973 2000.00 Speedway Elvis_Presley 1968 5000.00 Spirit_in_the_Night Bruce_Springsteen 1973 5000.00 … Write a declaration for a structure named vinylRec that is to be used to store the records for the classic collection system. The fields in the record should include a title (string), an artist (string), the yearReleased (int), and an estimatedPrice(double). Create the following…
Python programming language Write a program that asks the user for a number. Write the number to a file called total.txt. Then ask the user for a second number. Write the new number on line 2 with the total for both numbers next to it separated by a comma. Then ask the user for a third number and do the same. Keep asking for numbers until the person puts in a zero to terminate the program. Close the file. Be sure to use at least 2 functions [main() and total_numbers(number, total)]. Put all inputs and outputs into the main function, with all calculations into the total_numbers function. Give me a number: 13 Give me another number: 14 14 + 13 = 27 Give me another number: 3 3 + 27 = 30 Give me another number: 4 4 + 30 = 34 Give me another number (0 for quit): 0 Your total is 34. Write a program that displays the lines from the total.txt file in the following output. Use a try catch phrase to check for errors. Use only one function for this portion [main()]. 13 14, 27 3,…
Creates a sales receipt, displays the receipt entries and totals, and saves the receipt entries to a file .Prompt the user to enter the - Item Name Item Quantity Item Price Display the item name, the quantity, and item price, and the extended price (Item Quantity multiplied by Item Price) after the entry is made Save the item name, quantity, item price, and extended price to a file When you create the file, prompt the user for the name they want to give the file Separate the items saved with commas Each entry should be on a separate line in the text file Ask the user if they have more items to enter Once the user has finished entering items Close the file with the items entered Display the sales total If the sales total is more than $100 Calculate and display a 10% discount Calculate and display the sales tax using 8% as the sales tax rate The sales tax should be calculated on the sales total after the discount Display the total for the sales receipt
In python
Run the program below, which creates “Dates” in the HW library. You will need to change the input statement to account for the format of the raw data. Add the following to this data step: Using the yrdif function to add a variable called “Agetoday”, which is the age today. Use proc print to list all the variables to the output window. Remember to format all dates for output purposes. data HW.dates; input Subj $ DOB ; datalines; 001 11Nov06 002 25May07 003 25Dec06 ; run; proc; run;
I need this code to python
program6_2.pyNow write another program that reads her inventory file, displays all data for each item, and reports on the inventory value. The cost value of each item and the cost value of the total inventory should be reported. Strive to duplicate the Sample Output below.Sample OutputChica Chic Inventory tops, $24.99 each, 10 in stock, value $249.90shorts, $29.95 each, 12 in stock, value $359.40sandals, $19.79 each, 8 in stock, value $158.32End of fileTotal inventory value $767.62
DescriptionWrite a program to compute average grades for a course. The course records are in a single file and are organized according to the following format: each line contains a student's first name, then one space, then the student's last name, then one space, then some number of quiz scores that, if they exist, are separated by one space. Each student will have zero to ten scores, and each score is an integer not greater than 100. Your program will read data from this file and write its output to a second file. The date in the output file will be nearly the same as the data in the input file except that you will print the names as last-name, first-name; each quiz score, and there will be one additional number at the end of each line:the average of the student's ten quiz scores.Both files are parameters. You can access the name of the input file with argv[1]. and the name of the output file with argv[2].The output file must be formatted as described below: 1. First and last names…
The average amount Sold function is not run as expect. Please fix it. The input file: sales.txt header in picture. It is over 5000 char. I can't copy. 13492785 2017 Jane North; 1000 78534520 2012 Tim South; 95020192756 2017 Linda East; 15000 19273458 2012 Paul West; 500078520192 2017 Mary Jane Doe; 5001 32278520 2012 Victor Smith; 799514278520 2012 Mary Johnson; 12056192785 2017 Tom Baker; 1300 88278529 2012 Diana Newman; 150089278527 2012 William Peterson; 1420098278528 2012 Jim Gaddis; 120099192785 2017 Laura King; 1000 43278524 2012 Ann McDonald; 2000 The output expect: in picture. #include "Sales.h"#include <iostream>#include <sstream>#include <iomanip>#include <fstream>#include <string>using namespace std; const int MAX_SIZE = 30; void readData(string fileName, Sales salesArr[], int n);double calcSalesAvg(Sales salesArr[], int n);void displayOverAvg(Sales salesArr[], int n, double avg);void writeReport(Sales salesArr[], int n, string…
here is a text file containing the details of several invoices details. Each invoice uses 3 lines of the file. The first of the three lines is a string giving the date of the invoice, for example “1/5/2021” or “2/6/2021”. The second of the three lines contains double giving the amount, the third line is boolean indicating whether it is paid or not. However, the very first line of the file is an integer number, which says how many invoices are given in the file in the lines which follow it (i.e. how many records will follow). Text file example for two vehicles “invoices.txt” 2 1/5/2021 50.0 true 2/6/2021 20.0 false Write code for a method named processTextFile() which will open the file named ‘invoices.txt’, from which it will read the data of invoices. It will create Invoice objects using this data by calling the constructor that takes the parameters (date, amount, paid) , placing them into an ArrayList invoiceList.
CODE SHOULD BE PYTHON:
You are given 2 text files named drywet.txt and wetwet.txt. wetwet.txt data file refers to the probability of next day being a wet day if the current day is wet. drywet.txt data file refers to the probability of next day being a wet day if the current day is dry. NOTE: the data for the same location in wetwet.txt and drywet.txt will have the same line number. These files are in the format of: (excerpt from wetwet.txt)-97.58 26.02 0.76 0.75 0.77 0.74 0.80 0.86 0.94 0.97 0.89 0.77 0.74 0.77 -97.19 26.03 0.73 0.76 0.75 0.71 0.79 0.85 0.92 0.95 0.90 0.81 0.76 0.75 -98.75 26.35 0.74 0.76 0.76 0.73 0.67 0.84 0.83 0.85 0.80 0.71 0.71 0.76 … In each line, the first and second numbers represent the location’s longitude and latitude. The following 12 numbers represent the probability of the next day being a wet day of the month. For example, on the first line of the excerpt above 0.75 means that in February (4th column), there is a 75% of chance that the next day is a wet day if today is a wet…