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ženo v:
Podrobná bibliografie
Vydáno v:International journal of advanced studies Ročník 13; číslo 2; s. 33 - 46
Hlavní autoři: Krapivin, Roman R., Filatov, Yuri M., Gareeva, Gulnara A., Faizullina, Aigul G., Myshkina, Irina Yu
Médium: Journal Article
Jazyk:angličtina
Vydáno: Science and Innovation Center Publishing House 30.06.2023
Témata:
excel
library
pandas
postgresql
python
query
xlsx
ISSN:2328-1391, 2227-930X
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
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