{"id":136585,"date":"2024-09-25T14:12:52","date_gmt":"2024-09-25T08:42:52","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=136585"},"modified":"2024-09-25T14:12:53","modified_gmt":"2024-09-25T08:42:53","slug":"auto-arima-for-sales-data-code","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/","title":{"rendered":"Auto ARIMA for Sales Data (Code)"},"content":{"rendered":"\n<p>Auto ARIMA is a powerful tool for modeling and forecasting time series data, including sales data. By automating the process of selecting the best-fitting ARIMA model, Auto ARIMA can save time and effort while providing accurate predictions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Importing Necessary Libraries<\/strong><\/h3>\n\n\n\n<p>Python<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pandas as pd\nfrom statsmodels.tsa.arima.model import ARIMA\nfrom statsmodels.tsa.statespace.sarimax import SARIMAX\nfrom statsmodels.tsa.stattools import adfuller\nfrom &nbsp;  pmdarima import auto_arima\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Data Preparation<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Load the sales data:<\/strong> Load the sales data into a Pandas DataFrame.<\/li>\n\n\n\n<li><strong>Check for stationarity:<\/strong> Use the Augmented Dickey-Fuller (ADF) test to check if the data is stationary. If not, apply differencing to make it stationary.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Auto ARIMA Implementation<\/strong><\/h3>\n\n\n\n<p>Python<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Fit the Auto ARIMA model\nauto_arima_model = auto_arima(sales_data&#91;'Sales'], start_p=1, start_q=1, max_p=3, max_q=3, m=12, seasonal=True, stepwise=True)\n\n# Print the model summary\nprint(auto_arima_model.summary())\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Forecasting<\/strong><\/h3>\n\n\n\n<p>Python<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Generate forecasts for the next 12 months\nforecast = auto_arima_model.predict(horizon=12)\nprint(forecast)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Incorporating External Factors<\/strong><\/h3>\n\n\n\n<p>If there are external factors that may influence sales, such as promotions, seasonality, or economic indicators, you can include them as exogenous variables in the SARIMAX model.<\/p>\n\n\n\n<p>Python<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Include exogenous variables (e.g., promotions, seasonality)\nexogenous_vars = pd.DataFrame({'Promotions': &#91;0, 1, 0, ...], 'Season': &#91;1, 2, 3, ...]})\n\n# Fit the SARIMAX model with exogenous variables\nsarimax_model = SARIMAX(sales_data&#91;'Sales'], exog=exogenous_vars, order=(p, d, q), seasonal_order=(P, D, Q, s))\nsarimax_model_fit = sarimax_model.fit()\n\n# Generate forecasts\nforecast = sarimax_model_fit.forecast(horizon=12)\nprint(forecast)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Model Evaluation<\/strong><\/h3>\n\n\n\n<p>Evaluate the performance of the Auto ARIMA model using metrics like Mean Absolute Error (MAE), Mean Squared Error (MSE), and Root Mean Squared Error (RMSE).<\/p>\n\n\n\n<p>Python<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>from sklearn.metrics import mean_absolute_error, mean_squared_error\n\n# Evaluate the forecast accuracy\nmae = mean_absolute_error(actual_sales, forecast)\nmse = mean_squared_error(actual_sales, forecast)\nrmse = np.sqrt(mse)\n\nprint(\"MAE:\", mae)\nprint(\"MSE:\", mse)\nprint(\"RMSE:\", rmse)\n<\/code><\/pre>\n\n\n\n<p>By following these steps and using the Auto ARIMA model, you can effectively forecast sales data and make informed business decisions.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Auto ARIMA is a powerful tool for modeling and forecasting time series data, including sales data. By automating the process of selecting the best-fitting ARIMA model, Auto ARIMA can save time and effort while providing accurate predictions. Importing Necessary Libraries Python Data Preparation Auto ARIMA Implementation Python Forecasting Python Incorporating External Factors If there are&#8230;<\/p>\n","protected":false},"author":16,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-136585","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Auto ARIMA for Sales Data (Code) - Tutorial<\/title>\n<meta name=\"description\" content=\"Learn how to apply Auto ARIMA to sales data with practical code examples, optimizing forecasting techniques for improved business insights.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Auto ARIMA for Sales Data (Code) - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Learn how to apply Auto ARIMA to sales data with practical code examples, optimizing forecasting techniques for improved business insights.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-25T08:42:53+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/\",\"name\":\"Auto ARIMA for Sales Data (Code) - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2024-09-25T08:42:52+00:00\",\"dateModified\":\"2024-09-25T08:42:53+00:00\",\"description\":\"Learn how to apply Auto ARIMA to sales data with practical code examples, optimizing forecasting techniques for improved business insights.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Auto ARIMA for Sales Data (Code)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Auto ARIMA for Sales Data (Code) - Tutorial","description":"Learn how to apply Auto ARIMA to sales data with practical code examples, optimizing forecasting techniques for improved business insights.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/","og_locale":"en_US","og_type":"article","og_title":"Auto ARIMA for Sales Data (Code) - Tutorial","og_description":"Learn how to apply Auto ARIMA to sales data with practical code examples, optimizing forecasting techniques for improved business insights.","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-09-25T08:42:53+00:00","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/","name":"Auto ARIMA for Sales Data (Code) - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2024-09-25T08:42:52+00:00","dateModified":"2024-09-25T08:42:53+00:00","description":"Learn how to apply Auto ARIMA to sales data with practical code examples, optimizing forecasting techniques for improved business insights.","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/auto-arima-for-sales-data-code\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Auto ARIMA for Sales Data (Code)"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/136585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=136585"}],"version-history":[{"count":1,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/136585\/revisions"}],"predecessor-version":[{"id":136600,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/136585\/revisions\/136600"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=136585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=136585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=136585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}