main.py

# -*- coding: UTF-8 -*-
"""PyRamen Homework Starter."""

# @TODO: Import libraries
import csv
from pathlib import Path

# @TODO: Set file paths for menu_data.csv and sales_data.csv
menu_filepath = Path('./menu_data.csv')
sales_filepath = Path('./sales_data.csv')

# @TODO: Initialize list objects to hold our menu and sales data
menu = []
sales = []

# @TODO: Read in the menu data into the menu list
with open(menu_filepath, 'r') as menufile:
    csvreader = csv.reader(menufile, delimiter=',')
    header = next(csvreader)
    for row in csvreader:
        #print(row)
        menu.append(row)

# @TODO: Read in the sales data into the sales list
with open(sales_filepath, 'r') as salesfile:
    csvreader = csv.reader(salesfile, delimiter=',')
    header = next(csvreader)
    for row in csvreader:
        #print(row)
        sales.append(row)

# @TODO: Initialize dict object to hold our key-value pairs of items and metrics
report = {}

# Initialize a row counter variable
row_count = 0

# @TODO: Loop over every row in the sales list object
for row in sales:

    # Line_Item_ID,Date,Credit_Card_Number,Quantity,Menu_Item
    # @TODO: Initialize sales data variables
    quantity = int(row[3])
    sales_item = row[4]

    # @TODO:
    # If the item value not in the report, add it as a new entry with initialized metrics
    # Naming convention allows the keys to be ordered in logical fashion, count, revenue, cost, profit
    if sales_item not in report:
        report[sales_item] = {
                             "01-count": 0,
                             "02-revenue": 0,
                             "03-cogs": 0,
                             "04-profit": 0,
                             }

    # @TODO: For every row in our sales data, loop over the menu records to determine a match
    found_match = False
    for row2 in menu:

        # Item,Category,Description,Price,Cost
        # @TODO: Initialize menu data variables
        menu_item = row2[0]
        price = float(row2[3])
        cost = float(row2[4])

        # @TODO: Calculate profit of each item in the menu data
        profit = price - cost

        # @TODO: If the item value in our sales data is equal to the any of the items in the menu, then begin tracking metrics for that item
        if menu_item == sales_item:

            # @TODO: Print out matching menu data
            print(f"Item: {sales_item} Quantity: {quantity} Price: {price} Cost: {cost} Profit: {profit}")

            # @TODO: Cumulatively add up the metrics for each item key
            report[sales_item]["01-count"] += quantity
            report[sales_item]["02-revenue"] += price * quantity
            report[sales_item]["03-cogs"] += cost * quantity
            report[sales_item]["04-profit"] += profit * quantity
            found_match = True

        # @TODO: Else, the sales item does not equal any fo the item in the menu data, therefore no match
    if not found_match:
        print(f"Could not match {sales_item} in menu")

    # @TODO: Increment the row counter by 1
    row_count += 1

# @TODO: Print total number of records in sales data
print(f"Total number of records in sales data: {row_count}")

# @TODO: Write out report to a text file (won't appear on the command line output)
with open('output.txt', 'w') as f:
    for key in report:
        f.write(f"{key} {str(report[key])}\n")