Spaces:
Running
Running
File size: 652 Bytes
9a6a4dc |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
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 |