Importing Excel dataset into SQL using Python

The main goal of this script is to import a dataset from excel to sql, efficiently extract some insights and output it back to excel if needed.

Why Python?

  • Production friendly
  • Automation purpuses: connect with other python code like an auto-emailer for example

Dataset

The online retail business dataset is found on Kaggle Link: https://www.kaggle.com/umerkk12/online-retail-business

Requirements

Pandas

sudo apt install python3-pandas

sqlite3

sudo apt install sqlite3

sqlalchemy

pip install SQLAlchemy

GitHub

View Github