calculate_total_sales.py

import pandas as pd

def read_excel_and_calculate_total_sales(file_path):
    # Read the Excel file
    df = pd.read_excel(file_path)
    
    # Calculate total sales
    total_sales = (df['Sales'] * df['Price']).sum()
    
    return total_sales

# File path to the Excel file
file_path = '/workspaces/gaia-agent-python/deployment-ready/7bd855d8-463d-4ed5-93ca-5fe35145f733.xlsx'

# Calculate total sales
result = read_excel_and_calculate_total_sales(file_path)

# Print the result
print(result)