calculate_sales.py

import pandas as pd

def calculate_food_sales(file_path):
    # Read the Excel file
    df = pd.read_excel(file_path)
    # Filter out the rows where Category is 'Drink'
    food_sales = df[df['Category'] != 'Drink']
    # Calculate the total sales for food items
    total_sales = food_sales['Sales'].sum()
    return total_sales

# Call the function and print the result
file_path = '/tmp/tmpn1g1t02t.xlsx'
total_food_sales = calculate_food_sales(file_path)
print(total_food_sales)