Question: Write a Python program to make and cancel reservations on a single route on a single day. Here are core specifications for the software. 1.

Write a Python program to make and cancel reservations on a single route on a single day.

Here are core specifications for the software.

1. Input. The input will be read from a text file named transactions.csv. Each line will have a single integer. The first number is the beginning number of seats available for the route and must be non-negative.

2. Starting Availability. The availableStart is the first integer from the input.

3. Reservations. The number of reservations is computed as the sum of all positive integers from the input, except the first number of the input is not included.

4. Cancellations. The number of cancellations is computed as the sum of the negative integers from the input, except the first number of the input is not included.

5. Ending Availability. The availableEnd is computed as availableStart minus reservations minus cancellations. Note that subtracting the positive sum of reservations subtracts them from availability and subtracting the negative sum of cancellations adds them back into availability.

6. Output. The output will be one printed line in CSV format: availableStart,reservations,cancellations,availableEnd Note that cancellations should be a negative number.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

(use python) B ACKGROUND : A Restaurant Supply Store called Buy-Fresh sells different restaurants items (such as vegetables, fruit, beverages and restaurant equipment). Customers (restaurants owners)...

The Harter-Heighway Dragon Curve is a particularly interesting curve drawn in the x-y plane using an iterative generation approach. In this assignment, you will write a Python program that will draw...

ENGR 131 - Winter 2020-2021 Programming Project 2 The Harter-Heighway Dragon Curve The Harter-Heighway Dragon Curve is a particularly interesting curve drawn in the c-y plane using an iterative...

aHigher Nationals Internal verification of assessment decisions BTEC (RQF) INTERNAL VERIFICATION ASSESSMENT DECISIONS Programme title Higher National Diploma in Computing Assessor Internal Verifier...

Program in python: Salary calculator. In this problem, you are asked to write a Python program to calculate the daily salary for employees of a small software company. An employee of the company may...

are allowed to choose ONE other student from this class and work with them as a partner. Either student must NOT have already worked with someone else in the class on this assignment. Pairs are...

import matplotlib.pyplot as plt import matplotlib.cm as cm def make_2D_plot(S,fn='my_plot.png',color_map_name='viridis',axes=[]): # S[] is a list of 2D point class instances # with position...

Please help me with this Python assignment. Problem Description: Your programs run on a "chip", a CPU. This chip is manufactured on a silicon wafer, a very very thin circular slice of purified...

Expected Behavior Write a Python program in, street.py, that prompts the user for a one-line specification of a city street and then prints a simple ASCII rendering of it. The user should be prompted...

FACT SHEET FOR YOUR CONFERENCE ASSOCIATION NAME: Statistics Notes Name of Conference: List the name you are going to give your conference, this will be used in all of your marketing (HTM 2025 Annual...

The preferred stock of the Clarence Radiology Company has a par value of $100 and a $9 dividend rate. You require an 11 percent rate of return on this stock. What is the maximum price you would pay...

The Eatery is a restaurant in DeKalb, Illinois. It specializes in deluxe sandwiches in a moderate price range. Michael Raye, the manager of The Eatery, has determined that during the last 2 years the...

According to the pecking order hypothesis, managers will have a preference to fund investment using _ _ _ _ _ _ _ _ _ _ . Answer retained earnings, followed by debt and finally new equity debt,...

Just Answer parts b, e and f You are given the following relational schema. Passengers (pid:integer, pname:string, age:integer, city:string) Flights (fid:integer, from:string, to:string,...