tmp_calc.py

import pandas as pd

# Read the data
data = {
    "Menu Item": ["Burger", "Fries", "Soda", "Pizza", "Water", "Chicken Sandwich", "Salad", "Coffee", "Ice Cream", "Milkshake"],
    "Category": ["Food", "Food", "Drink", "Food", "Drink", "Food", "Food", "Drink", "Dessert", "Drink"],
    "Price": [5.99, 2.99, 1.49, 8.99, 0.99, 6.49, 4.99, 1.99, 2.49, 2.99],
    "Quantity Sold": [150, 200, 300, 120, 250, 180, 90, 150, 220, 110]
}

df = pd.DataFrame(data)

# Calculate total sales for food items
food_sales = df[df['Category'] == 'Food']
total_sales = (food_sales['Price'] * food_sales['Quantity Sold']).sum()

# Print the total sales
result = total_sales