How to install Python3
1.Download the latest version of Python and install it
2.In order to connect python with database, some libs need to be installed
pip install pyodbc
ip install PyMySQL
For Python3 on windows you might have issue like “error Microsoft Visual C++ 14.0 is required”
Install using any ONE of these choices:
Microsoft Build Tools for Visual Studio.
Select: Workloads → C++ build tools.
Other errors might like “PYODBC–Data source name not found and no default driver specified” try to “cnxn = pyodbc.connect(‘DRIVER={ODBC Driver 13 for SQL Server}” instead of ‘DRIVER={SQL Server}’