Create a new column in thus table that is equal to the total profit for that line item (note: profit equals the price that you
Create a new column in thus table that is equal to the total profit for that line item (note: profit equals the price that you charge for an item minus the cost that you have to pay to get that item from your supplier). Display the resulting dataframe. Please just assume the original dataframe is df.
Order Num Customer 1000 Customer A 1000 Customer A 1000 Customer A 1000 Customer A 1000 Customer A 1001 Customer B 1001 Customer B 1001 Customer B 1002 Customer C 1002 Customer C 1-10 of 16 rows Line Item 1 2 3 4 5 1 2 3 1 2 Year Purchased Product Code 2019 X1189 2019 A33 2019 BW243 2019 X1388 2019 Y12 2020 X1388 2020 BW243 2020 2020 X1388 2020 HC155 GG2554 Quantity 65 63 75 20 82 83 29 70 52 73 Unit Price Previous Cost 314 244.92 698 467.66 483 367.08 684 540.36 474 322.32 684 566.36 483 380.08 595 447.40 684 566.36 404 303.80 1 2 Next
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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