Learn

Finally, you can add a new column by performing a function on the existing columns.

Maybe we want to add a column to our inventory table with the amount of sales tax that we need to charge for each item. The following code multiplies each Price by 0.075, the sales tax for our state:

df['Sales Tax'] = df.Price * 0.075

Now our table has a column called Sales Tax:

Product ID Product Description Cost to Manufacture Price Sales Tax
1 3 inch screw 0.50 0.75 0.06
2 2 inch nail 0.10 0.25 0.02
3 hammer 3.00 5.50 0.41
4 screwdriver 2.50 3.00 0.22

Instructions

1.

Add a column to df called 'Margin', which is equal to the difference between the Price and the Cost to Manufacture.

Sign up to start coding

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?