MRA Project Milestone 2/MARKETING & RETAIL ANALYTICS

PROBLEM STATEMENT ▪ An automobile parts manufacturing company has collected data of transactions for 3 years. They do not have any in-house data science team, thus they have hired you as their consultant. Your job is to use your magical data science skills to provide them with suitable insights about their data and their customers. ▪ DATA: Sales_D z DATA DICTIONARY ORDERNUMBER : Order Number CUSTOMERNAM E : customer QUANTITYORDERED : Quantity ordered PHONE : Phone of the customer PRICEEACH : Price of Each item ADDRESSLINE1 : Address of customer ORDERLINENUMBER : order line CITY : City of customer SALES : Sales amount POSTALCODE : Postal Code of customer ORDERDATE : Order Date COUNTRY : Country customer DAYS_SINCE_LASTO RDER : Days_ Since_Lastorder CONTACTLASTN AME : Contact person customer STATUS : Status of order like Shipped or not CONTACTFIRST NAME : Contact person customer PRODUCTLINE : Product line – CATEGORY DEALSIZE : Size of the deal based on Quantity and Item Price MSRP : Manufacturer's Suggested Retail Price PRODUCTCODE : Code of Product z READING THE DATASET The dataset is read using the read functi