Python library is outdated and not able to install newer version despite it is there

[desmond99890]

I tried installing openai library in the jupyter notebook from alteryx workflow and this is what i get when i run the code. i have tried installing it again but i get the same error again and again. someone suggested to run the application as administrator also which i did but again after running the code i get the same error.

```

Requirement already satisfied: openai in c:\users\67344\appdata\roaming\python\python36\site-packages (0.10.5)
Requirement already satisfied: tqdm in c:\users\67344\appdata\roaming\python\python36\site-packages (from openai) (4.64.1)
Requirement already satisfied: openpyxl>=3.0.7 in c:\users\67344\appdata\roaming\python\python36\site-packages (from openai) (3.1.2)
Requirement already satisfied: requests>=2.20 in c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\site-packages (from openai) (2.22.0)
Requirement already satisfied: pandas-stubs>=1.1.0.11 in c:\users\67344\appdata\roaming\python\python36\site-packages (from openai) (1.2.0.62)
ERROR: Could not find a version that satisfies the requirement pandas>=1.2.3 (from openai) (from versions: 0.1, 0.2, 0.3.0, 0.4.0, 0.4.1, 0.4.2, 0.4.3, 0.5.0, 0.6.0, 0.6.1, 0.7.0, 0.7.1, 0.7.2, 0.7.3, 0.8.0, 0.8.1, 0.9.0, 0.9.1, 0.10.0, 0.10.1, 0.11.0, 0.12.0, 0.13.0, 0.13.1, 0.14.0, 0.14.1, 0.15.0, 0.15.1, 0.15.2, 0.16.0, 0.16.1, 0.16.2, 0.17.0, 0.17.1, 0.18.0, 0.18.1, 0.19.0, 0.19.1, 0.19.2, 0.20.0, 0.20.1, 0.20.2, 0.20.3, 0.21.0, 0.21.1, 0.22.0, 0.23.0, 0.23.1, 0.23.2, 0.23.3, 0.23.4, 0.24.0, 0.24.1, 0.24.2, 0.25.0, 0.25.1, 0.25.2, 0.25.3, 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.1.0, 1.1.1, 1.1.2, 1.1.3, 1.1.4, 1.1.5)
ERROR: No matching distribution found for pandas>=1.2.3 (from openai)
---------------------------------------------------------------------------
CalledProcessError                        Traceback (most recent call last)
<ipython-input-9-c8e98e9419e6> in <module>
      2 # script here (only missing packages will be installed)
      3 from ayx import Alteryx
----> 4 Alteryx.installPackages(package="openai",install_type="install --user")

c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\site-packages\ayx\export.py in installPackage(package, install_type, debug, **kwargs)
    131     This function will install a package or list of packages into the virtual environment used by the Python tool. If using an admin installation of Alteryx, you must run Alteryx as administrator in order to use this function and install packages.
    132     """
--> 133     __installPackages__(package, install_type=install_type, debug=debug, **kwargs)
    134 
    135 

c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\site-packages\ayx\Package.py in installPackages(package, install_type, debug)
    200     print(pip_install_result["msg"])
    201     if not pip_install_result["success"]:
--> 202         raise pip_install_result["err"]

c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\site-packages\ayx\Utils.py in runSubprocess(args_list, debug)
    118 
    119     try:
--> 120         result = subprocess.check_output(args_list, stderr=subprocess.STDOUT)
    121         if debug:
    122             print("[Subprocess success!]")

c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\subprocess.py in check_output(timeout, *popenargs, **kwargs)
    354 
    355     return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,
--> 356                **kwargs).stdout
    357 
    358 

c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\subprocess.py in run(input, timeout, check, *popenargs, **kwargs)
    436         if check and retcode:
    437             raise CalledProcessError(retcode, process.args,
--> 438                                      output=stdout, stderr=stderr)
    439     return CompletedProcess(process.args, retcode, stdout, stderr)
    440 

CalledProcessError: Command '['c:\\program files\\alteryx\\bin\\miniconda3\\envs\\jupytertool_venv\\python.exe', '-m', 'pip', 'install', '--user', 'openai']' returned non-zero exit status 1.

```

and when i am using my code i get this error

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-20-078be38b86cc> in <module>
     25         messages = [{"role": "system", "content": "assistant."}]
     26         messages.append({"role": "user", "content": message},)
---> 27         chat = openai.ChatCompletion.create(model="gpt-3.5-turbo", messages=messages,temperature=0.7)
     28         reply = chat.choices[0].message.content
     29         #print(f"ChatGPT: {reply}")

AttributeError: module 'openai' has no attribute 'ChatCompletion'

[PhilipMannering]

What version of Python is Alteryx using?

You can find that by,

import sys
sys.version

in a cell in the Python Tool.

I have Python version 3.8.5 (Alteryx version 2022.3 Admin install)

I ran,

Alteryx.installPackage('openai --user')

(because I couldn't be bothered to reopen Alteryx as admin)

And it seemed to work fine.