gaia-enhanced-agent / tmp_calc.py
GAIA Agent Deployment
Deploy Complete Enhanced GAIA Agent with Phase 1-6 Improvements
9a6a4dc
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