Question: Python Programming . A hotel salesperson enters sales in a text file. Each line contains the following, separated by semicolons: The name of the client,

Python Programming.

A hotel salesperson enters sales in a text file. Each line contains the following, separated by semicolons: The name of the client, the service sold (such as Dinner, Conference, Lodging, and so on), the amount of the sale, and the date of that event.

Write a program that reads such a file and displays the total amount for each service category. Use the following data for your text file:

Bob;Dinner;10.00;January 1, 2013

Tom;Dinner;14.00;January 2, 2013

Anne;Lodging;125.00;January 3, 2013

Jerry;Lodging;125.00;January 4, 2013

The output should be:

Dinner: 24.00

Lodging: 250.00

Your code with comments

A screenshot of the execution

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!

WRITE ALL THESE PROGRAMS IN PYTHON P6.22 Write a function that computes the average of the neighbors of a table element in the eight directions shown in Figure 12. def neighborAverage(values, row,...

In python, A hotel salesperson enters sales in a text file. Each line contains the following, separated by semicolons: The name of the client, the service sold (such as Dinner, Conference, Lodging,...

It needs to be in python and have try, except in the program A hotel salesperson enters sales in a text file. Each line contains the following separated by semicolons: The name of the client, the...

Write a program that reads a text file, as described in Exercise P7.8, and writes a separate file for each service category. Each service category file should contain the entries for that category....

P7.17 (Java) Write a program that reads a text file as described in Exercise P7.16, and that writes a separate file for each service category, containing the entries for that category. Name the...

Write a Java program: A hotel salesperson enters sales in a text file. Each line contains the following, separated by semicolons: The name of the client, the service sold (such as Dinner, Conference,...

Java - has to be done in command line p7.16 A hotel salesperson enters sales in a text le. Each line contains the following, separated by semicolons: The name of the client, the service sold (such as...

Good evening I have two different questions for my Python class that I need help with that I cannot seem to find out. I have attached a screenshot of the questons. Thank you in advance for helping...

Given here are the 1H NMR spectra and carbonyl IR absorption peaks of five acyl compounds. Propose a structure for each. (a) (b) (c) (d) (e) OgH 1404 H NMR Spectrum Triplet 1.2(6H) Singlet 2.5(4H)...

In less-developed regions in mountainous areas, small hydroelectric generators are used to serve several residences (Mackay, 1990). Assume each house uses an electric range and an electric...

Based on their incentives and interests, different stakeholders tend to classify preferred stock differently in terms of risk. From the viewpoint of the issuing corporation, preferred stock isless...

INCOME STATEMENT Byron Books Inc. recently reported $ 1 5 million of net income. Its EBIT was $ 2 0 . 8 million, and its tax rate was 2 5 % . What was its interest expense? ( Hint: Write out the...

Have you ever had a sense that a speaker was intentionally leaving some information out or that the information was somehow unreliable? How did it make you feel about the speaker? Did it change the...

10. Is your speech within the required time limits for the assignment?

After you have practiced in front of one or more friends, family members, or classmates, consider their feedback. Was anything about the feedback surprising? Did they note the strengths and...