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.
- Production friendly
- Automation purpuses: connect with other python code like an auto-emailer for example
The online retail business dataset is found on Kaggle
Link: https://www.kaggle.com/umerkk12/online-retail-business
sudo apt install python3-pandassudo apt install sqlite3pip install SQLAlchemy