Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate some statistics about cereal. The csv file of the cereals is available through the below link. https://www.kaggle.com/crawford/80-cereals/home In python, use your preferred graphing library,

Calculate some statistics about cereal.

The csv file of the cereals is available through the below link.

https://www.kaggle.com/crawford/80-cereals/home

In python, use your preferred graphing library, and whatever form of data storage you prefer, produce the following graphs.

A histogram of the cereal manufacturers, with the manufacturer on the x-axis and the cereal count on the y axis. Each manufacturer should have a different bar color!

A histogram of the calories per serving, along with a line graph showing the distribution around the mean plotted over that histogram

A boxplot of the calories per cereal for each manufacturer.

image text in transcribed

name,mfrttype,calories,protein;fat,sodium;fiber;carbo;sugars;potass;vitamins,shelf;weight:cups;rating String;Categorical;Categorical;Int; Int;Int;Int;Float;Float;lnt;Int;Int;Int;Float;Float;Float 100% Bran,N, C,70,4; 1,130; 10,5%;280,25,3,1:0.33,68.402973 100% Natural Bran;Q:C120,3,5:15,2,83, 135,0;3,1,1:33.983679 All-Bran;K;C;70;4;1:260,9;7;5;320;25;3,1;0.33;59.425505 All-Bran with Extra Fiber;K,C;50,4,0;140;14;8;0;330;25;3;1;0.5;93.704912 Almond Delight;R;C,110,2,2,200;1;14;8;-1;25;3;1;0.75;34.384843 Apple Cinnamon Cheerios,G,C;110;2;2;180;1.5;10.5;10;70;25;1,1;0.75;29.509541 Apple Jacks;K;C;110,2,0;125;1;11;14;30;25,2:1;1;33.174094 Basic 4;G;C;130;3;2;210;2;18;8;100;25;3;1.33;0.75;37.038562 Bran Chex;R,C,90;2; 1,200,4; 15:6; 125,25,1,1:0.67,49. 120253 Bran Flakes,P;C;90;3,0;210;5,13,5,190;25,3,1,0.67;53.313813 Cap'n'Crunch;Q;C;120;1;2;220;0;12;12;35;25;2,1;0.75;18.042851 Cheerios;G;C,110;6;2;290;2,17;1;105;25;1;1;1.25;50.764999 Cinnamon Toast Crunch;G;C;120;1;3,210;0;13;9;45;25;2,1;0.75;19.823573 name,mfrttype,calories,protein;fat,sodium;fiber;carbo;sugars;potass;vitamins,shelf;weight:cups;rating String;Categorical;Categorical;Int; Int;Int;Int;Float;Float;lnt;Int;Int;Int;Float;Float;Float 100% Bran,N, C,70,4; 1,130; 10,5%;280,25,3,1:0.33,68.402973 100% Natural Bran;Q:C120,3,5:15,2,83, 135,0;3,1,1:33.983679 All-Bran;K;C;70;4;1:260,9;7;5;320;25;3,1;0.33;59.425505 All-Bran with Extra Fiber;K,C;50,4,0;140;14;8;0;330;25;3;1;0.5;93.704912 Almond Delight;R;C,110,2,2,200;1;14;8;-1;25;3;1;0.75;34.384843 Apple Cinnamon Cheerios,G,C;110;2;2;180;1.5;10.5;10;70;25;1,1;0.75;29.509541 Apple Jacks;K;C;110,2,0;125;1;11;14;30;25,2:1;1;33.174094 Basic 4;G;C;130;3;2;210;2;18;8;100;25;3;1.33;0.75;37.038562 Bran Chex;R,C,90;2; 1,200,4; 15:6; 125,25,1,1:0.67,49. 120253 Bran Flakes,P;C;90;3,0;210;5,13,5,190;25,3,1,0.67;53.313813 Cap'n'Crunch;Q;C;120;1;2;220;0;12;12;35;25;2,1;0.75;18.042851 Cheerios;G;C,110;6;2;290;2,17;1;105;25;1;1;1.25;50.764999 Cinnamon Toast Crunch;G;C;120;1;3,210;0;13;9;45;25;2,1;0.75;19.823573

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database Design With Microcomputer Applications

Authors: Glenn A. Jackson

1st Edition

0137718411, 978-0137718412

More Books

Students also viewed these Databases questions

Question

1. Prepare a short profile of Mikhail Zoshchenko ?

Answered: 1 week ago

Question

What is psychology disorder?

Answered: 1 week ago