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.

 

Transcribed Image Text:

Order Num Customer <dbl> <chr> 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 <dbl> 1 2 3 4 5 1 2 3 1 2 Year Purchased Product Code <dbl> <chr> 2019 X1189 2019 A33 2019 BW243 2019 X1388 2019 Y12 2020 X1388 2020 BW243 2020 2020 X1388 2020 HC155 GG2554 Quantity <dbl> 65 63 75 20 82 83 29 70 52 73 Unit Price <dbl> Previous Cost <dbl> 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 Order Num Customer <dbl> <chr> 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 <dbl> 1 2 3 4 5 1 2 3 1 2 Year Purchased Product Code <dbl> <chr> 2019 X1189 2019 A33 2019 BW243 2019 X1388 2019 Y12 2020 X1388 2020 BW243 2020 2020 X1388 2020 HC155 GG2554 Quantity <dbl> 65 63 75 20 82 83 29 70 52 73 Unit Price <dbl> Previous Cost <dbl> 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