Spaces:
Running
Running
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 |