July2026-Nutrition

Optimizing Nutrition on a Budget

PROJECT DESCRIPTION

In this challenge, lists of food prices and nutritional values are joined to put together meals with budgetary and nutritional constraints of a customer.

The client wants to know:

1. What are the top 5 foods that offer the best value for money in terms of protein (i.e. with the highest protein per dollar ratio)?

2. Which 4 food items should they buy for their next meal to get a high protein on a tight budget? (Best meal combination for price and proteins intake)

CUSTOMER MEALS CONSTRAINTS

• one protein item (must be a high-protein (>25g proteins) and low-fat (<5g fats) source),

• one carbohydrate item (must be a low-carb source with <50g carbs), and

• two different vegetables (must be less than 100 kcal and ideally as much protein as possible).

EXTRACT AND TRANSFORM

After data cleaning, food items satisfying meals criterias are put in a pool.

1) To answer client's questions, 4 Items are selected based on lower Price per serving. Vegetables are selected on protein values first, price per serving next.

2) Meals are suggested to the customer based on a maximum Price per serving for the meal. To promote food diversity, meal combinations are selected randomly, but with a price cap.

VISUALIZING RESULTS

Customer can select a maximum price for meal suggestions.

CREATE RANDOM MEALS

This part of the workflow generates 200 combinations of 4 food items.

Some constraints are applied on the meal combination instead

of the food items for better food diversity.