{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import matplotlib\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "import statsmodels.api as sm\n", "import seaborn as sns\n", "import warnings\n", "warnings.filterwarnings('ignore')\n", "\n", "from sklearn.metrics import mean_squared_error\n", "import math\n", "\n", "sns.set_style('whitegrid')\n", "\n", "matplotlib.rcParams.update({'font.size':20})\n", "\n", "def rmse(y, y_hat):\n", " return np.sqrt(mean_squared_error(y, y_hat))\n" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Row ID | \n", "Order ID | \n", "Order Date | \n", "Ship Date | \n", "Ship Mode | \n", "Customer ID | \n", "Customer Name | \n", "Segment | \n", "Country | \n", "City | \n", "... | \n", "Postal Code | \n", "Region | \n", "Product ID | \n", "Category | \n", "Sub-Category | \n", "Product Name | \n", "Sales | \n", "Quantity | \n", "Discount | \n", "Profit | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "CA-2016-152156 | \n", "2016-11-08 | \n", "2016-11-11 | \n", "Second Class | \n", "CG-12520 | \n", "Claire Gute | \n", "Consumer | \n", "United States | \n", "Henderson | \n", "... | \n", "42420 | \n", "South | \n", "FUR-BO-10001798 | \n", "Furniture | \n", "Bookcases | \n", "Bush Somerset Collection Bookcase | \n", "261.9600 | \n", "2 | \n", "0.00 | \n", "41.9136 | \n", "
1 | \n", "2 | \n", "CA-2016-152156 | \n", "2016-11-08 | \n", "2016-11-11 | \n", "Second Class | \n", "CG-12520 | \n", "Claire Gute | \n", "Consumer | \n", "United States | \n", "Henderson | \n", "... | \n", "42420 | \n", "South | \n", "FUR-CH-10000454 | \n", "Furniture | \n", "Chairs | \n", "Hon Deluxe Fabric Upholstered Stacking Chairs,... | \n", "731.9400 | \n", "3 | \n", "0.00 | \n", "219.5820 | \n", "
2 | \n", "3 | \n", "CA-2016-138688 | \n", "2016-06-12 | \n", "2016-06-16 | \n", "Second Class | \n", "DV-13045 | \n", "Darrin Van Huff | \n", "Corporate | \n", "United States | \n", "Los Angeles | \n", "... | \n", "90036 | \n", "West | \n", "OFF-LA-10000240 | \n", "Office Supplies | \n", "Labels | \n", "Self-Adhesive Address Labels for Typewriters b... | \n", "14.6200 | \n", "2 | \n", "0.00 | \n", "6.8714 | \n", "
3 | \n", "4 | \n", "US-2015-108966 | \n", "2015-10-11 | \n", "2015-10-18 | \n", "Standard Class | \n", "SO-20335 | \n", "Sean O'Donnell | \n", "Consumer | \n", "United States | \n", "Fort Lauderdale | \n", "... | \n", "33311 | \n", "South | \n", "FUR-TA-10000577 | \n", "Furniture | \n", "Tables | \n", "Bretford CR4500 Series Slim Rectangular Table | \n", "957.5775 | \n", "5 | \n", "0.45 | \n", "-383.0310 | \n", "
4 | \n", "5 | \n", "US-2015-108966 | \n", "2015-10-11 | \n", "2015-10-18 | \n", "Standard Class | \n", "SO-20335 | \n", "Sean O'Donnell | \n", "Consumer | \n", "United States | \n", "Fort Lauderdale | \n", "... | \n", "33311 | \n", "South | \n", "OFF-ST-10000760 | \n", "Office Supplies | \n", "Storage | \n", "Eldon Fold 'N Roll Cart System | \n", "22.3680 | \n", "2 | \n", "0.20 | \n", "2.5164 | \n", "
5 rows × 21 columns
\n", "