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