Description: You are a data analyst working for nutrition counseling. Your client shared two datasets with you: One containing nutrition facts of various foods (kcal, protein, fat, carbs) per serving size; The other containing a list with food items and their local store prices (in $).
Your client is on a budget but still wants to improve their fitness goal. You were asked to create a budget friendly high protein meal. The meal should consist of four items:
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).
Clean and process the two datasets. Your client wants to know:
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)?
Which 4 food items should they buy for their next meal to get a high protein on a tight budget?
