Tutorials Tutorials
Python & Excel Easily Migrate Spreadsheets to a Database
Date: 15-10-2018, 02:37 | Author: ptitno1 | Favorites: |


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


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








Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me

скачать dle 12.0


Add Comment
Add Comment
Your Name:*
E-Mail:
Comment:
Security Code: *
reload, if the code cannot be seen