Question
You will work with the Nutrition_subset data set in this assignment, using Python. The data set contains the weight in grams along with the amount
You will work with theNutrition_subsetdata set in this assignment, using Python. The data set contains the weight in grams along with the amount of saturated fat and the amount of cholesterol for a set of 961 foods.The elements in the data set are food items of various sizes, ranging from a teaspoon of cinnamon to an entire carrot cake.
To demonstrate completion of this assignment, create Word document with your working code, screenshots of program results, and written answers to questions. Upload your final Jupyter notebook and Word document to the LMS when complete.
- Sort the data set by the saturated fat variable (saturated_fat) and produce a listing of the five food items highest in saturated fat. Comment on the validity of comparing food items of different sizes.
- Derive a new variable,saturated_fat_per_gram, by dividing the amount of saturated fat by the weight in grams. Sort the data set bysaturated_fat_per_gramand produce a listing of the five food items highest in saturated fat per gram. Which food has the most saturated fat per gram?
- Derive a new variable,cholesterol_per_gram. Sort the data set bycholesterol_per_gramand produce a listing of the five food items highest in cholesterol fat per gram. Which food has the most cholesterol fat per gram?
- Standardize the fieldsaturated_fat_per_gram. Produce a listing of all the food items that are outliers at the high end of the scale. How many food items are outliers at the low end of the scale?
- Standardize the fieldcholesterol_per_gram. Produce a listing of all the food items that are outliers at the high end of the scale.
link for data set :
https://bcs.wiley.com/he-bcs/Books?action=resource&bcsId=11712&itemId=1119526817&resourceId=46601
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started