Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Read the data from the picture and display the first 10 rows of data, draw a histogram based on the frequency of each item in

Read the data from the picture and display the first 10 rows of data, draw a histogram based on the frequency of each item in the column name item_name. Based on order number (order_id), figure out the total spent amount of each order. For example $11.56 for order number 1, then draw a scatter chart based on the total amount of each order and the total number of items purchased for each order (the total amount denotes the X-axis and the total number of items denotes the Y-axi)

image text in transcribed

choice_description (Clementine) [Apple] [Tomatillo-Red Chili Salsa (Hot), [Black Beans, Rice, Cheese, Sour Cream]] [Fresh Tomato Salsa (Mild), (Rice, Cheese, Sour Cream, Guacamole, Lettuce]] [Tomatillo Red Chili Salsa, [Fajita Vegetables, Black Beans, Pinto Beans, Cheese, Sour Cream, Guacamole, Lettuce]] [Tomatillo Green Chili Salsa, [Pinto Beans, Cheese, Sour Cream, Lettuce]] [Fresh Tomato Salsa, [Rice, Black Beans, Pinto Beans, Cheese, Sour Cream, Lettuce]] [Roasted Chili Corn Salsa, [Fajita Vegetables, Rice, Black Beans, Cheese, Sour Cream]] [Roasted Chili Corn Salsa, (Rice, Black Beans, Cheese, Sour Cream]] [Fresh Tomato Salsa, [Fajita Vegetables, Rice, Cheese, Sour Cream, Guacamole]] order_id Iquantity item_name 0 1 1 Chips and Fresh Tomato Salsa 1 1 1 Izze 2 1 1 Nantucket Nectar 3 1 1 Chips and Tomatillo-Green Chili Salsa 4 2 2 Chicken Bowl 5 3 1 Chicken Bowl 6 3 1 Side of Chips 7 4 1 Steak Burrito 8 4 1 Steak Soft Tacos 9 5 1 Steak Burrito 10 5 1 Chips and Guacamole 11 6 1 Chicken Crispy Tacos 12 6 1 Chicken Soft Tacos 13 7 1 Chicken Bowl 14 7 1 Chips and Guacamole 15 8 1 Chips and Tomatillo-Green Chili Salsa 16 8 1 Chicken Burrito 17 9 1 Chicken Burrito 18 9 2 Canned Soda 19 10 1 Chicken Bowl 20 10 1 Chips and Guacamole 21 11 1 Barbacoa Burrito 22 11 1 Nantucket Nectar 23 12 1 Chicken Burrito 24 12 1 Izze 25 13 1 Chips and Fresh Tomato Salsa 26 13 1 Chicken Bowl 27 14 1 Carnitas Burrito 28 14 1 Canned Soda 29 15 1 Chicken Burrito 30 15 1 Chips and Tomatillo-Green Chili Salsa item_price $2.39 $3.39 $3.39 $2.39 $16.98 $10.98 $1.69 $11.75 $9.25 $9.25 $4.45 $8.75 $8.75 $11.25 $4.45 $2.39 $8.49 $8.49 $2.18 $8.75 $4.45 $8.99 $3.39 $10.98 $3.39 $2.39 $8.49 $8.99 $1.09 $8.49 $2.39 [Tomatillo-Green Chili Salsa (Medium), [Pinto Beans, Cheese, Sour Cream]] [Fresh Tomato Salsa (Mild), [Black Beans, Rice, Cheese, Sour Cream, Lettuce]] [Sprite] [Tomatillo Red Chili Salsa, [Fajita Vegetables, Black Beans, Sour Cream, Cheese, Lettuce]] [[Fresh Tomato Salsa (Mild), Tomatillo-Green Chili Salsa (Medium), Tomatillo-Red Chili Salsa (Hot)], [Rice, Cheese, Sour Cream, Lettuce]] [Pomegranate Cherry] [[Tomatillo-Green Chili Salsa (Medium), Tomatillo-Red Chili Salsa (Hot)], [Pinto Beans, Rice, Cheese, Sour Cream, Guacamole, Lettuce]] [Grapefruit] [Roasted Chili Corn Salsa (Medium), [Pinto Beans, Rice, Fajita Veggies, Cheese, Sour Cream, Lettuce]] [[Tomatillo-Green Chili Salsa (Medium), Roasted Chili Corn Salsa (Medium)], [Black Beans, Rice, Sour Cream, Lettuce]] [Dr. Pepper) [Tomatillo-Green Chili Salsa (Medium), [Pinto Beans, Rice, Cheese, Sour Cream]]

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_2

Step: 3

blur-text-image_3

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

Fraud Casebook Lessons From The Bad Side Of Business

Authors: Joseph T. Wells

1st Edition

0470134682, 978-0470134689

More Books

Students also viewed these Accounting questions