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