Python & Excel: Easily migrate spreadsheets to a database
.MP4 | Video: 1280×720, 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
You should know the basics of Python
You should know what a Excel document is
You should know the concept of a database
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