Database formation in the R software environment: experience of economic research at the municipal level
The absence or long lag of publication of official statistics on the level of so cio-economic development of territories forces researchers to turn to alternative data sourc es arising because of the rapid development of digital technologies. Programming language R is required to work with these dat...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Ural State University of Economics
2025-01-01
|
| Series: | Цифровые модели и решения |
| Subjects: | |
| Online Access: | http://usue-journal.ru/en/issues-2024/70-anglijskij-yazyk/tsmiren/11/521-database-formation-in-the-r-software-environment-experience-of-economic-research-at-the-municipal-level |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1841556344557010944 |
|---|---|
| author | E.A. Prokopyev V.A. Igolkin |
| author_facet | E.A. Prokopyev V.A. Igolkin |
| author_sort | E.A. Prokopyev |
| collection | DOAJ |
| description | The absence or long lag of publication of official statistics on the level of so cio-economic development of territories forces researchers to turn to alternative data sourc es arising because of the rapid development of digital technologies. Programming language R is required to work with these datasets. The purpose of the paper is to acquaint readers with the capabilities of the R software environment when forming a municipal database for socio-economic research from various sources. The following data sources are considered here Rosstat database “Indicators of Municipalities”; 5-NDFL tax report form, web sources of the Federal Tax Service, website of the Central Electoral Commission of the Russian Federation, TurgetHunter service. As part of the preparatory stage of database creation, it is shown which parameters must be taken into account when creating an auxiliary key table. Using the example of working with data, the functions left_join(), pivot_longer(), fill(), group_by(), arrange(), summarize(), separate() are analyzed. The presented material can be used to develop educational tasks within the framework of the disciplines “Basics of Statis tics” or “Data Analysis”, as well as to prepare a statistical base for research into socio-eco nomic processes at the municipal level. |
| format | Article |
| id | doaj-art-3e41cc8613394495a535e39854cd6ea7 |
| institution | Kabale University |
| issn | 2949-477X 2782-4934 |
| language | English |
| publishDate | 2025-01-01 |
| publisher | Ural State University of Economics |
| record_format | Article |
| series | Цифровые модели и решения |
| spelling | doaj-art-3e41cc8613394495a535e39854cd6ea72025-01-07T09:06:49ZengUral State University of EconomicsЦифровые модели и решения2949-477X2782-49342025-01-0134274610.29141/2949-477X-2024-3-4-2Database formation in the R software environment: experience of economic research at the municipal levelE.A. Prokopyev0 V.A. Igolkin1Karelian Research Center of the Russian Academy of Sciences, Petrozavodsk, Russian FederationKarelian Research Center of the Russian Academy of Sciences, Petrozavodsk, Russian FederationThe absence or long lag of publication of official statistics on the level of so cio-economic development of territories forces researchers to turn to alternative data sourc es arising because of the rapid development of digital technologies. Programming language R is required to work with these datasets. The purpose of the paper is to acquaint readers with the capabilities of the R software environment when forming a municipal database for socio-economic research from various sources. The following data sources are considered here Rosstat database “Indicators of Municipalities”; 5-NDFL tax report form, web sources of the Federal Tax Service, website of the Central Electoral Commission of the Russian Federation, TurgetHunter service. As part of the preparatory stage of database creation, it is shown which parameters must be taken into account when creating an auxiliary key table. Using the example of working with data, the functions left_join(), pivot_longer(), fill(), group_by(), arrange(), summarize(), separate() are analyzed. The presented material can be used to develop educational tasks within the framework of the disciplines “Basics of Statis tics” or “Data Analysis”, as well as to prepare a statistical base for research into socio-eco nomic processes at the municipal level.http://usue-journal.ru/en/issues-2024/70-anglijskij-yazyk/tsmiren/11/521-database-formation-in-the-r-software-environment-experience-of-economic-research-at-the-municipal-levelr software environmentdatabasemunicipal statisticsalternative data sourcesdata collection and processing |
| spellingShingle | E.A. Prokopyev V.A. Igolkin Database formation in the R software environment: experience of economic research at the municipal level Цифровые модели и решения r software environment database municipal statistics alternative data sources data collection and processing |
| title | Database formation in the R software environment: experience of economic research at the municipal level |
| title_full | Database formation in the R software environment: experience of economic research at the municipal level |
| title_fullStr | Database formation in the R software environment: experience of economic research at the municipal level |
| title_full_unstemmed | Database formation in the R software environment: experience of economic research at the municipal level |
| title_short | Database formation in the R software environment: experience of economic research at the municipal level |
| title_sort | database formation in the r software environment experience of economic research at the municipal level |
| topic | r software environment database municipal statistics alternative data sources data collection and processing |
| url | http://usue-journal.ru/en/issues-2024/70-anglijskij-yazyk/tsmiren/11/521-database-formation-in-the-r-software-environment-experience-of-economic-research-at-the-municipal-level |
| work_keys_str_mv | AT eaprokopyev databaseformationinthersoftwareenvironmentexperienceofeconomicresearchatthemunicipallevel AT vaigolkin databaseformationinthersoftwareenvironmentexperienceofeconomicresearchatthemunicipallevel |