Introduction
Provided by the Food & Nutrition Service (FNS), my pyramid food dataset provides information regarding the calories, added sugars and milk content of different food items including condiments. These facts are necessary for both the provider and the consumer as the latter has the right to know how to meet the recommended dietary allowance of each food and the number of calories acquired. CNPP used this dataset as a reference to create an interactive tool for consumers to use on a regular basis.
The analysis was carried out on the "lu_Condiment_Food_Table" dataset which is one of the three datasets published by the FNS. The dataset has 63 condiments used in meals along with their corresponding portion size, grain content, meat content, calories content and many other features.
A thorough exploration of the data was done and the following insights were concluded:
- The dataset has 22 different features and 63 rows.
- All fields have numeric data types except the "Display_Name" & "Condiment_Portion_Size" which are string fields.
- All fields are complete in the dataset, there're no null values.
- All food items have calories in them.
- The food item with the lowest amounts of all additives is "1% milk (low fat).
- Brown sugar, vinegar, lemon juice, white sugar (granulated or lump) and honey are the only condiments that have zero saturated fats.
- The condiment with the highest amount of calories (125.33) is "Fried rice (plain)", while Lettuce has the lowest proportion of calories (0.8).
- The condiment with the highest amount of grains is "Brown rice, no fat added".
- The condiment with the highest amount of vegetables is "Sauerkraut, no fat added" and "Fried rice (plain)" has the greatest amount of starchy vegetables.
- The condiment with the highest amount of fruits is "Applesauce (unsweetened)".
- The condiment with the highest amount of milk is "Low-fat Cheddar or Swiss".
- The condiment with the highest amount of meat is "Chili con carne (with beans)".
- The condiment with the highest amount of soy is "Soy milk (calcium-fortified)".
- The condiment with the highest amount of dry beans (peas) is "Hummus".
- The condiment with the highest amount of oils is "Mayonnaise (regular).
- The condiment with the highest amount of solid fats & saturated fats is "Whipped cream (sweetened)".
- Of all condiments "Honey" has the greatest quantity of added sugars.
The previous insights are clearly displayed in the following visualizations:
 |
Food Item Vs Condiment Grains
|
Some condiments like butter, ketchup and white sugar have no grains content at all, while others have a high proportion of grains, with brown rice having the highest grains content (1.000350).
 |
| Food item Vs Condiment vegetables |
Of all condiments, Sauerkraut (with no fat added) has the highest amount of vegetables (0.249920) followed by Chili con carne (0.17526).
 |
| Food item Vs Condiment Fruits |
Unsweetened Applesauce comes in the first place having the highest amount of fruits (0.25010) while some condiments like cheese spread and salsa have no fruits in them.
 |
| Food Item Vs Condiment Added Sugars |
Of course Honey has the highest amount of added sugars (63.84000) followed by syrup ( 49.47393) and then jelly (27.46698) and on the other side, some foods as vegetable oil, fried rice and butter have Zero added sugars.
 |
| Food Item Vs Condiment Calories |
If you intend on decreasing calories in your diet, then you should stay away from fried rice (125.33000) and Cheddar or Swiss cheese (114.25050) as well as brown rice (107.25000). Also, have some Lettuce, Tomato and Lemon juice since they have low calories.
If you want to see the rest of the visuals and interact with them click on the link below.
Visuals Dashboard
16/9/2021
0 Comments