AUTOIMPORT OF A LARGE VOLUME INFORMATION INTO A DATABASE USING THE PYTHON PROGRAMMING LANGUAGE

The article discusses an efficient and automated way to import large amounts of data from Excel tables into a database. In various projects, there are tasks in which the flow of huge data, such as logs of program operations or manual operations performed at work sites, is vital for effective analysi...

Celý popis

Uložené v:
Podrobná bibliografia
Vydané v:International journal of advanced studies Ročník 13; číslo 2; s. 33 - 46
Hlavní autori: Krapivin, Roman R., Filatov, Yuri M., Gareeva, Gulnara A., Faizullina, Aigul G., Myshkina, Irina Yu
Médium: Journal Article
Jazyk:English
Vydavateľské údaje: Science and Innovation Center Publishing House 30.06.2023
Predmet:
excel
library
pandas
postgresql
python
query
xlsx
ISSN:2328-1391, 2227-930X
On-line prístup:Získať plný text
Tagy: Pridať tag
Žiadne tagy, Buďte prvý, kto otaguje tento záznam!
Popis
Shrnutí:The article discusses an efficient and automated way to import large amounts of data from Excel tables into a database. In various projects, there are tasks in which the flow of huge data, such as logs of program operations or manual operations performed at work sites, is vital for effective analysis. Purpose – development of a module for automatic import of a large amount of data from Excel format into a database. Method or methodology of work: the article discusses a method that implements automatic import of data from Excel tables into a Postgresql database. Result: developed its own unique module that is able to process huge Excel tables and import them into a Postgresql database without manual operations. Scope of the results: the data obtained, which are stored in the database, should be used to identify high-yield accounts for subsequent investment.
ISSN:2328-1391
2227-930X
DOI:10.12731/2227-930X-2023-13-2-33-46