Question: ***Using Python A report could be produced by a program like this: Timesheet data is easy to represent in a file, where it can be

***Using Python

A report could be produced by a program like this:

Timesheet data is easy to represent in a file, where it can be used to generate a report and help the worker get paid! Given an example set of data where each row represents a day of the week and each entry on the row represents a block of time worked, like this:

0h 1.5h 3.25h 3.0h 6.0h 1.0h 5.5h 2.25h 0.75h 2.25h 3.0h 3.0h 5.75h 2.25h 0h 

--------------------------------------- 0.00h | 0.00h 5.25h | 1.50h 3.25h 0.50h 10.00h | 3.00h 6.00h 1.00h 8.50h | 5.50h 2.25h 0.75h 8.25h | 2.25h 3.00h 3.00h 8.00h | 5.75h 2.25h 0.00h | 0.00h --------------------------------------- Weekly Total: 40.00h

Notice how in the output file all the numbers are nicely formatted as right-aligned. Hint: you will probably need to use splitting, string slicing, converting data types, and string formatting.

For your assignment, create a program that uses a data file that you have created, parses the data in that file to create a calculation per row and a running total, then writes the report to an output file. Your program should prompt a user to input a file containing the data, then prompt the user to enter a file name for outputting the report and the total, formatted similarly to the example above. Here is an example interaction for our timesheet example:

Enter timesheet file name: random_timesheet_20210606.txt Enter name for report file: random_timereport_20210606.txt Done writing totals to random_timereport_20210606.txt

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!