hard T-Level Task 4A

T-Level Task 4A: Full Recoats Solution

The Brief

You are completing the full Pearson T-Level DPD Core Task 4A. The senior developer has already written code that lets users see the total income from each revenue source — that is your starting point. Recoats Adventure Park has now requested significant additions: identify trends and patterns over time for different payment types and income sources, show income on different days of the week, make the solution secure, and produce textual, numerical and graphical outputs. EXTEND the senior developers existing code — keep their main_menu, total_menu, convert_total_men_coice and get_total_data functions working, and ADD new menu options + new functions to deliver the new requirements. The CSV has columns: Day, Pay Type, Tickets, Gift Shop, Snack Stand, Pictures (56 rows = 4 weeks x 7 days x 2 payment types).

Acceptance Criteria

Tap a criterion to mark it off as you work. Tap a category header to expand or collapse.

2 Ensure the file path isTask4a_data.csv

15 Option 7 (Quit) breaks the main loop with a goodbye message

1 KEEP the senior developers original functions: main_menu, total_menu, convert_total_men_coice, get_total_data — they should still work for option 1

7 Convert the if main_menu_choice == 1 block at the bottom of the file into a proper while True loop so the user can keep choosing options without restarting the program

8 Add a new function for option 2 (payment trends): for each source calculate Card vs Cash totals AND percentages, print a clear table

16 Invalid menu input prints a friendly error and re-shows the menu without crashing

17 Each new feature is in its own named function with a clear docstring or comment

18 Demonstrate the extended program by calling each new function once at the bottom (so the grader can see they all work), then leave a comment showing how to run the interactive menu

9 Add a new function for option 3 (day of week): groupby Day, sum the four sources across both payment types, print sorted from highest to lowest, identify busiest and quietest days

10 Add a new function for option 4 (busiest day): use idxmax to find the single record with the highest combined income, print its day, payment type, total, and which source contributed most

14 Add a new function for option 6: print the full DataFrame

3 EXTEND main_menu to display new options: 1) Total income by source (existing), 2) Trends by payment type, 3) Trends by day of week, 4) Busiest day analysis, 5) Generate charts, 6) Show full dataset, 7) Quit

11 Add a new function for option 5 (generate charts): use matplotlib with the Agg backend to produce AT LEAST THREE saved PNG charts — bar chart of source totals, line chart of daily total over the 4 weeks, pie chart of overall card vs cash

12 All matplotlib calls must use matplotlib.use(Agg) BEFORE importing pyplot, and plt.savefig rather than plt.show

13 All charts have titles, axis labels, and a legend if multiple series are plotted

4 Wrap the CSV loading in get_total_data (and any new data-loading code) in try/except handling at least FileNotFoundError, pd.errors.EmptyDataError, and a generic Exception — print a clear message and return None / safe default on failure

6 Replace the bare except: in the senior developers code with except ValueError: — bare excepts are a security and maintainability issue

5 Validate that expected columns are present after loading and refuse to proceed if they are missing

💡 Hints 0 / 8

Guest Mode Attempt this challenge freely, or log in to earn EXP & CodeCoins.

solution.py

Python 3

import pandas as pd

# Outputs the initial menu and checks validates the input
def main_menu():
    flag = True

    while flag:

        print("####################################################")
        print("############## Recoats Adventure Park ##############")
        print("####################################################")
        print("")
        print("########### Please select an option ################")
        print("### 1. Total income by source")

        choice = input("Enter your number selection here: ")

        try:
            int(choice)
        except:
            print("Sorry, you did not enter a valid option")
            flag = True
        else:
            print("Choice accepted!")
            flag = False

    return choice

# Submenu for totals, provides type check validation for the input
def total_menu ():
    flag = True

    while flag:

        print("####################################################")
        print("############## Total income by source ##############")
        print("####################################################")
        print("")
        print("########## Please select an income source ##########")
        print("### 1. Tickets")
        print("### 2. Gift Shop")
        print("### 3. Snack Stand")
        print("### 4. Pictures")

        choice = input("Enter your number selction here: ")

        try:
            int(choice)
        except:
            print("Sorry, you did not enter a valid option")
            flag = True
        else:
            print("Choice accepted!")
            flag = False

    return choice

# takes the total submenu input and converts the number to a string of the source name
def convert_total_men_coice(total_men_choice):

    if total_men_choice == "1":
        tot_choice = "Tickets"
    elif total_men_choice == "2":
        tot_choice = "Gift Shop"
    elif total_men_choice == "3":
        tot_choice= "Snack Stand"
    else:
        tot_choice = "Pictures"

    return tot_choice

# creates a new dataframe with the selected income source then creates a total row
# outputs the final total in a message
def get_total_data(total_choice):

    df = pd.read_csv("Task4a_data.csv")

    income = df[["Day", total_choice]]

    total = income[total_choice].sum()

    msg = "The total income from {} was: GBP{}".format(total_choice, total)
    return msg

main_menu_choice = main_menu()
if main_menu_choice == "1":
    total_men_choice = total_menu()
    total_choice = convert_total_men_coice(total_men_choice)
    print(get_total_data(total_choice))

# ============================================================
# TODO: Recoats has requested additional functionality.
# Extend this program to meet the new requirements:
#   - Trends by payment type and income source
#   - Income on different days of the week
#   - Secure data loading (file may be missing/empty/corrupt)
#   - Textual, numerical AND graphical output
#   - Easy-to-use menu (extend main_menu and the dispatch loop)

Console