Note: Read the resources posted in week 12 folder and the chapter 7 of the ebook in the week 12 folder (Python for Data Analysis).

Note: Read the resources posted in week 12 folder and the chapter 7 of the ebook in the week 12 folder (Python for Data Analysis).

Solve the following problems 1 to 3, work with the Nutrition_subset data set. 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. Use Python.

1. The elements in the data set are food items of various sizes, ranging from a teaspoon of cinnamon to an entire carrot cake.

a. Sort the data set by the saturated fat (saturated_fat) and produce a listing of the five food items highest in saturated fat.

b. Comment on the validity of comparing food items of different sizes.

2. Derive a new variable, saturated_fat_per_gram, by dividing the amount of saturated fat by the weight in grams.

a. Sort the data set by saturated_fat_per_gram and produce a listing of the five food items highest in saturated fat per gram.

b. Which food has the most saturated fat per gram?

3.Derive a new variable, cholesterol_per_gram.

a. Sort the data set by cholesterol_per_gram and produce a listing of the five food items highest in cholesterol fat per gram.

b. Which food has the most cholesterol fat per gram?

Solve the following problems 4 to 6, work with the adult_ch3_training data set. The response is whether income exceeds $50,000. Use Python.

4. Add a record index field to the data set

5. Determine whether any outliers exist for the education field.

6. Do the following for the age field. a. Standardize the variable. b. Identify how many outliers there are and identify the most extreme outlier.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Operational Excellence Week 2 AssignmentInformation

Operational Excellence Week 2 Assignment Information Systems for Business and Beyond Questions: · Chapter 3 – study questions 1-8, Exercise 2, 4 & 5 Information Technology and Organizational Learning Assignment: Chapter 3 – Complete the two essay assignments noted below:  · Review the strategic integration section.  Note what strategic integration is and how

Operational Excellence Week 2 Assignmentinformation

Operational Excellence Week 2 Assignment information Systems for Business and Beyond Questions · Chapter 2 – study questions 1-10, Exercise 2      Information Technology and Organizational Learning Questions · Chapter 2 – Note why the IT organizational structure is an important concept to understand.  Also, note the role of

Pg. 01Project I ProjectDeadline: Sunday 12/5/2024 @ 23:59[Total

Pg. 01 Project I Project Deadline: Sunday 12/5/2024 @ 23:59 [Total Mark is 14] Introduction to Database IT244 College of Computing and Informatics Project Instructions · You can work on this project as a group (minimum 2 and maximum 3 students). Each group member must submit the project individually with