In this data, I want to not only display how the carbon emissions are broken down by food category but illustrate, from an overview, the most common type of food that is generating this. Because I coded this in my file, I like how you can hover over the states to see exactly how much carbon dioxide
equivalent (CO2eq) each food category averages. Fresher produce (like apples or carrots) generate such a little amount in comparison, which is visually shown by the smaller slice of the pie and by the colors of the foods.
THINGS TO CHANGE IN THE FUTURE: I want to figure out how to change the colors of each slice to give a better visual understanding of the food (i.e. lower food slices being green and higher being red OR vegetables being green and dairy being white).
I also want to add a feature that when you hover over each bar, you can see the individual foods in that category (i.e. you see the individual contribution beef, chicken, or pork contribute when you are clicking on that slice.
In this data, I want to not only display how the carbon emissions are broken down by food category but illustrate, from an overview, the most common type of food that is generating this. Because I coded this in my file, I like how you can hover over the states to see exactly how much carbon dioxide
equivalent (CO2eq) each food category averages. Fresher produce (like apples or carrots) generate such a little amount in comparison, which is visually shown by the smaller slice of the pie and by the colors of the foods.
THINGS TO CHANGE IN THE FUTURE: This is not a very interesting chart and doesn't really show too much. If I were to continue this, I think adding a key that shows the relation between the nutrient breakdown of a food category and its carbon dioxide emissions
might be cool and a bit more interesting. Like, something I noticed was that foods higher in carbs in relation to calories tended to have lower CO2 emissions. Actually, if I am being fully transparent, calculating the nutrient breakdowns (carbs, protein, and fats) might
be better if I describe them in relation to % of calories they contribute since 10g of carbs have less calories than 10g of fat.
But IDEALLY, I would replace this chart and figure out how to create a heat map with this data to overlay on an image of the grocery store shelf instead.
This is the big and main data set:
This is the data set I created for the views:
| FoodCategory | AverageCO2eqEmissionsPer100g | Average10CalsOf100g | AverageProteinOf100g | AverageCarbsOf100g | AverageFatsOf100g | AverageCalsOf100g | AverageCO2eqPer100Cal |
|---|---|---|---|---|---|---|---|
| Beverage | 15.16 | 4.3 | 0.1 | 1.3 | 0 | 43 | 35.255814 |
| Confectionery | 46.65 | 59.8 | 7.8 | 45.9 | 42.6 | 598 | 7.801003 |
| Dairy | 13.515 | 22.2 | 14.025 | 3.04 | 18.185 | 222 | 6.087838 |
| Dairy Alternative | 0.98 | 5.4 | 3.3 | 6 | 1.8 | 54 | 1.814815 |
| Fruit | 0.852 | 6.14 | 0.738 | 15.51 | 0.244 | 61.4 | 1.387622 |
| Grain | 2.276 | 31.36 | 10.2 | 62.98 | 3.14 | 313.6 | 0.725765 |
| Legume | 1.385 | 21.4 | 13.4 | 38.95 | 0.75 | 214 | 0.647196 |
| Nut/Seed | 1.83 | 58.7 | 22.92 | 18.575 | 50.325 | 587 | 0.311755 |
| Protein (Animal) | 29.98125 | 20.7625 | 20.15125 | 0.09 | 8.11875 | 207.625 | 14.440096 |
| Protein (Plant) | 3.16 | 14.4 | 17.27 | 2.78 | 8.72 | 144 | 2.194444 |
| Root | 1.32 | 16 | 1.4 | 38.1 | 0.3 | 160 | 0.825 |
| Sugar | 2.505 | 38.7 | 0 | 99.95 | 0 | 387 | 0.647287 |
| Vegetable | 0.753333 | 4.51667 | 1.65 | 9.716667 | 0.183333 | 45.1667 | 1.667897 |