Applying Python’s Time Series Forecasting Method in Microsoft Excel – Integration as a Business Process Supporting Tool for Small Enterprises

• Autorzy: Litwin Jolanta , Olech Marcin , Szymusik Anna

Identyfikatory

DOI

10.31648/ts.7058

• Języki publikacji: EN

Abstrakty

EN

The paper describes the current state of research, where integration of Microsoft Excel and Python interpreter, gives the business user the right tool to solve chosen business process analysis problems like: forecasting, classification or clustering. The integration is done by using Visual Basic for Application (VBA), as well as XLWings Python’s library. Both mechanisms serve as an interfaces between MS Excel and Python to allow the data exchange between each other. Creating the suitable Graphical User Interface (GUI) in Microsoft Excel, gives the business user opportunity to select specific data analysis method available in Python’s environment and set its parameters, without Python’s programming. Running the method by Python’s interpreter can bring the results, which are hard or even impossible to obtain by using Microsoft Excel only. However, the data analysis methods stored in the Python’s script, which are available to the business user, as well as VBA source code, must be designed and implemented by the data scientist. Sample, basic integration between Microsoft Excel and Python’s interpreter is presented in the paper. To present value-added of the proposed software solution, simple case study according to time series forecasting problem is described, where forecasting errors of different methods available in the Microsoft Excel and Python are presented and discussed. The paper ends with conclusions according to the results of the current researches and suggested directions of further research.

Słowa kluczowe

EN

time series forecasting; python integration; excel integration

• Wydawca: Wydawnictwo Uniwersytetu Warmińsko-Mazurskiego w Olsztynie
• Czasopismo: Technical Sciences / University of Warmia and Mazury in Olsztyn
• Rocznik: 2021
• Tom: nr 24(1)
• Strony: 115--133
• Opis fizyczny: Bibliogr. 20 poz., rys., tab., wykr.

Twórcy

autor

Litwin Jolanta

• Zakład Informatyki, Wydział Budowy Maszyn i Lotnictwa, Politechnika Rzeszowska im. Ignacego Łukasiewicza, al. Powstańców Warszawy 12, 35-959 Rzeszów

• https://orcid.org/0000-0002-3650-1953

autor

Olech Marcin

• Department of Computer Science, Rzeszow University of Technology

• https://orcid.org/0000-0002-8346-4673

autor

Szymusik Anna

• Department of Computer Science, Rzeszow University of Technology

• https://orcid.org/0000-0002-2472-851X

Bibliografia

• Birch D., Lyford-Smith D., Guo Y. 2018. The Future of Spreadsheets in the Big Data Era. Proceedings of the EuSpRIG 2017 Conference “Spreadsheet Risk Management”. Imperial College, London, UK.
• Brownlee J. 2020. Introduction to Time Series Forecasting with Python: How to Prepare Data and Develop Models to Predict the Future. Machine Learning Mastery, San Francisco, p. 2-5.
• Chicco D., Warrens M.J., Jurman G. 2021. The coefficient of determination R-squared is more informative than SMAPE, MAE, MAPE, MSE and RMSE in regression analysis evaluation. PeerJ Computer Science, 7: e623. DOI: https://doi.org/10.7717/peerj-cs.623.
• Donati G., Woolston C. 2017. Information management: Data domination. Nature 548: 613–614. DOI: https://doi.org/10.1038/nj7669-613a.
• Ehrhardt M., Günther M., ter Maten E.J.W. 2017. Novel Methods in Computational Finance. Springer, Cham, p. 545.
• Hansun S., Kristanda M.B. 2017. Performance Analysis of Conventional Moving Average Methods in Forex Forecasting. Proceedings of 2017 International Conference on Smart Cities, Automation & Intelligent Computing Systems. Yogyakarta, Indonesia.
• Hyndman R.J., Athanasopoulos G. 2018. Forecasting: Principles and Practice. 2nd ed. OTexts, Melbourne, p. 57-58. https://otexts.com/fpp2/ (access: 18.06.2021).
• Januschowski T., Gasthaus J., Wang Y. 2019. Open-Source Forecasting Tools in Python. The International Journal of Applied Forecasting, 55: 20-26.
• Kim S., Kim H. 2016. A new metric of absolute percentage error for intermittent demand forecasts. International Journal of Forecasting, 32(3): 669-679.
• Koh L., Orzes G., Jia F. 2019. The fourth industrial revolution (Industry 4.0): technologies disruption on operations and supply chain management. International Journal of Operations & Production Management, 39(6/7/8): 817-828.
• Kurzak L. 2012. Importance of forecasting in enterprise management. Advanced Logistic Systems, 6(1): 173-182.
• Nelli F. 2018. Python Data Analytics with Pandas, NumPy and Matplotlib. 2nd ed. Apress, Rome, p. 143-145.
• Pena-Sanchez Y., Ringwood J. 2017. A Critical Comparison of AR and ARMA Models for Shortterm Wave Forecasting. Proceedings of the 12th European Wave and Tidal Energy Conference, Kildare, Ireland.
• Raschka S., Mirjalili V. 2019. Python Machine Learning: Machine Learning and Deep Learning with Python, scikit-learn, and TensorFlow 2. 3rd ed. Packt Publishing Ltd., Birmingham, p. 207-211.
• Saabith A.L.S., Fareez M.M.M., Vinothraj T. 2019. Python Current Trend Applications – An Overview. International Journal of Advance Engineering and Research Development, 6(10): 6-12.
• Shim J.K., Siegel J.G., Shim A.I. 2012. Budgeting Basics and Beyond. 4th ed. John Wiley & Sons, Inc., Hoboken, p. 277-279.
• Siami-Namini S., Namin A.S. 2018. Forecasting economic and financial time series: ARIMA vs. LSTM. http://arxiv.org/abs/1803.06386 (access: 17.06.2021).
• Speight A. 2021. Visual Studio Code for Python Programmers. John Wiley & Sons, Inc., Hoboken, p. 3-49.
• Swamynathan M. 2019. Mastering Machine Learning with Python in Six Steps. A Practical Implementation Guide to Predictive Data Analytics Using Python. 2nd ed. Apress, Bangalore, p. 234-243.
• Winkowski C. 2019. Classification of forecasting methods in production engineering. Engineering Management in Production and Services, 11(4): 23-33.

Uwagi

Opracowanie rekordu ze środków MEiN, umowa nr SONP/SP/546092/2022 w ramach programu "Społeczna odpowiedzialność nauki" - moduł: Popularyzacja nauki i promocja sportu (2022-2023)