Example Python codes that works with MySQL and Excel files
Python x MySQL x Excel by Zinglecode
Example Python codes that do the processes between MySQL database and Excel spreadsheet files.
YouTube videos
Setup database table
products table structure
product_notes table structure
categories table structure
hashtags table structure
products_hashtags table structure
Install Python 3 and pipenv
-
Download Python 3 installation file from https://www.python.org/
-
Install pipenv as global package by this command.
pip install pipenv
Note: for macOS with pre-installed Python 2, use pip3 instead of pip.
Install and