AUTOMATION OF THE PROCESS OF ECONOMIC REPORTING OF AN ORGANIZATION USING PYTHON AND MS EXCEL LANGUAGE TOOLS

UDC 004.89
DOI: 10.36871/ek.up.p.r.2024.04.02.003

Authors

Khava A. Gubasheva,
Institute of Economics and Finance, Chechen State University named after A. A. Kadyrov
Olga A. Pyrnova,
Kazan State Power Engineering University, Kazan, Russia
Mansoor S. Ganchaev,
Grozny State Petroleum Technical University named after Academician Millionshchikov, Grozny, Russia

Abstract

The article is an overview of the use of Python and MS Excel programming language tools to automate the reporting process in an organization. The authors discuss methods and techniques for using Python to collect, process, and analyze data, as well as generate reports. Particular attention is paid to the integration of Python with MS Excel, which allows you to combine the powerful analytical capabilities of Python with the convenience and flexibility of Excel spreadsheets. The article provides Python code examples and explains steps to create automated reports using tools from both platforms. This approach can significantly increase the efficiency of the reporting process and reduce the likelihood of errors by automating routine tasks. In addition, the article highlights the benefits of using Python, such as the ability to work with large amounts of data, create custom functions and scripts for specialized analytical tasks. This approach allows organizations to significantly reduce the time spent on reporting preparation and improve the quality of its analysis.

Keywords

automation of reporting, data analysis, integration of Python with MS Excel, data processing and analysis, quality of data analysis, report generation.