Python & Excel: Easily migrate spreadsheets to a database
- 3.8
-
![]()
![]()
![]()
![]()
1 hour on-demand video
$
12.99
Brief Introduction
Automate the reading / writing of Excel document and/or migrate them to a databaseDescription
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
Requirements
- Requirements
- You should know the basics of Python
- You should know what a Excel document is
- You should know the concept of a database
Peter Hijma
3.8 Raiting
Python & Excel: Easily migrate spreadsheets to a database
- 3.8
-
![]()
![]()
![]()
![]()
![]()
Automate the reading / writing of Excel document and/or migrate them to a database The database could be any relational database, but for this section we will use SQLite, as it's...
