Новости
Python & Excel Easily migrate spreadsheets to a database |
В разделе: - [Информация] |
|||
Python & Excel: Easily migrate spreadsheets to a database .MP4 | Video: 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | 489 MB Duration: 1 hours | Genre: eLearning | Language: English Automate the reading / writing of Excel document and/or migrate them to a database What Will I Learn? Reading data from Excel documents Writing data to Excel documents Migrate data from Excel documents to a database Create objects that represent tables in a database Requirements You should know the basics of Python You should know what a Excel document is You should know the concept of a database Description Welcome! Learn to use Python for migrating your excel files in almost any format to a relational database. The first section of this course is a basic introduction to openpyxl: the ideas behind reading and writing data from and to Excel. In the second section we will see how to read from multiple Excel documents and save them to a database. The database could be any relational database, but for this section we will use SQLite, as it's fast to setup and easy to use. The third section is a more advanced case, where we will learn how to deal with a more 'messy' Excel document and with a more complex database structure using a foreign key. For the next sections, I like to hear from you what you would like! :-) At the moment I'm first thinking of some other kind of databases, like MySQL and PostgreSQL. But let me know Who is the target audience? Those who want to parse or create Excel documents with Python Those who need to migrate their Excel documents to a database
|
||||
|