Question: 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


 

Order Num Customer 1000 Customer A 1000 Customer A 1000 Customer ACreate 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Physics Questions!