Provide python pandas code for a given requirement
Budget: $10 – $30 USD
I need Python Pandas code to create a new column in the dataframe. The sample excel file and details of calculations for new column are attached in the word document. Provide me the code that uses pandas and calculate the new column values.