🔍 Exploratory Analysis

[CSFelix]

Find a way to take off the time into Date Feature:

DD/MM/YY HH:mm:ss 

TO

DD/MM/YY

[CSFelix]

Part of the Code:

import datetime

sales['Formatted Date'] = pd.to_datetime(sales['Date'], format='%d/%m/%y')
sales.head()

[CSFelix]

Create the Following Feature:

BUDGET TOTAL EXPENSES = BUDGET MARGIN - BUDGET PROFIT

[CSFelix]

Add this new feature aside Budget Profit

[CSFelix]

sales.insert(loc=12, column='Budget Total Expenses', value=sales['Budget Margin'] - sales['Budget Profit'])

[CSFelix]

To lower categorical features.