[GIS] Installing Python module within code and running from ArcGIS Pro script tool

Question

I am trying to install a third-party Python package from within a Python script so that other users can run the script and the package can be installed and loaded without having to manually download and install.

This is the code I'm using:

import subprocess

def install(package):
    subprocess.call([sys.executable, "-m", 'pip', 'install', package])

install('pyodbc')
import pyodbc

This seems to work fine from within my stand-alone Python script. However, when I try to run it as a script tool set up in ArcGIS Pro, it is not finding the installed package and is failing with this error message:

ModuleNotFoundError: No module named 'pyodbc'

Do I need to change a path or environment setting?

Answer 1

In your python code, you can install a package using

import pip

pip.main(['install','package-name'])

Write this at top of your code.