Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

*PYTHON COURSE* Can someone please help me answer this question for my class. I will 100% like you solving my answering. Thank you so much!!!!

image text in transcribedimage text in transcribedimage text in transcribed*PYTHON COURSE* Can someone please help me answer this question for my class. I will 100% like you solving my answering. Thank you so much!!!!

- Part 2: Produce Execute the cell below to import some packages. import numpy as np tmatolotlib inline import matplatlib.pyplot as plt plt.style.use('fivethirtyeight') np.set_printoptions (legacy-'1.13') import numpy as np import pandas as pd from matplotlib import cm import seaborn as ons Run the cell below to create a frame. Normally, you'd load it from a file or database, but since this is just an exercise, for convenience we'll just create it directly 'Unit Price': [0.1, 0.12,0.13, 0.14]}, index=["1", [ ] produce_0 = pd.DataFrame({ 'Item': [ "Apple", "Spinach", "Peach", "Broccoli"], 'Quantity': [10, 3, 11, 7], produce_0.index.name = "Order ID" produce_0 Item Quantity Unit Price Order ID Item Quantity Unit Price Order ID 1 Apple 10 0.10 2 Spinach 3 0.12 3 Peach 11 0.13 4 Broccoli 7 0.14 (11 pts) Problem 4 Put code in the cell below to add a column named Total that has the total amount for the order. (Hint: Use square bracket indexing on the frame, giving it a new column.) Don't change the original, but rather use a copy, name it produce_1 (11 pts) Problem 5 Now put code in the cell below to add a column named Category that has the string Fruit if the item is a fruit, otherwise vegetable if it is a vegetable. Don't change produce_1, but rather create a copy, named produce_2 . You must use the .map() method. [] (11 pts] Problem 6 Now put code in the cell below to generate a series containing the total revenue for each category, Fruit and vegetable. Assign it to the series named produce_3. [ ] 41 cell hidden

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

Database Processing Fundamentals Design And Implementation

Authors: David M. Kroenke

5th Edition

B000CSIH5A, 978-0023668814

More Books

Students also viewed these Databases questions