community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Alteryx Designer failing to install fbprophet python package

Meteor

Hi,

 

I am currently stuck trying to install the 'fbprophet' package in Alteryx Admin Designer 2019.1.4.57073.

 

I run Alteryx with admin rights and tried to install the package with the following commands in the Python tool:

 

 

# List all non-standard packages to be imported by your 
# script here (only missing packages will be installed)
from ayx import Package
Package.installPackages('fbprophet')

 

 

 

Collecting fbprophet
  Using cached <a href="<a href="https://files.pythonhosted.org/packages/33/fb/ad98d46773929079657706e6b2b6e366ba6c282bc2397d8f9b0ea8e5614c/fbprophet-0.5.tar.gz" target="_blank">https://files.pythonhosted.org/packages/33/fb/ad98d46773929079657706e6b2b6e366ba6c282bc2397d8f9b0ea8e5614c/fbprophet-0.5.tar.gz</a>" target="_blank"><a href="https://files.pythonhosted.org/packages/33/fb/ad98d46773929079657706e6b2b6e366ba6c282bc2397d8f9b0ea8e5614c/fbprophet-0.5.tar.gz</a" target="_blank">https://files.pythonhosted.org/packages/33/fb/ad98d46773929079657706e6b2b6e366ba6c282bc2397d8f9b0ea8e5614c/fbprophet-0.5.tar.gz</a</a>>
Requirement already satisfied: Cython>=0.22 in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from fbprophet)
Requirement already satisfied: pystan>=2.14 in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from fbprophet)
Requirement already satisfied: numpy>=1.10.0 in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from fbprophet)
Requirement already satisfied: pandas>=0.23.4 in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from fbprophet)
Requirement already satisfied: matplotlib>=2.0.0 in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from fbprophet)
Requirement already satisfied: lunardate>=0.1.5 in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from fbprophet)
Collecting convertdate>=2.1.2 (from fbprophet)
  Using cached <a href="<a href="https://files.pythonhosted.org/packages/74/83/d0fa07078f4d4ae473a89d7d521aafc66d82641ea0af0ef04a47052e8f17/convertdate-2.1.3-py2.py3-none-any.whl" target="_blank">https://files.pythonhosted.org/packages/74/83/d0fa07078f4d4ae473a89d7d521aafc66d82641ea0af0ef04a47052e8f17/convertdate-2.1.3-py2.py3-none-any.whl</a>" target="_blank"><a href="https://files.pythonhosted.org/packages/74/83/d0fa07078f4d4ae473a89d7d521aafc66d82641ea0af0ef04a47052e8f17/convertdate-2.1.3-py2.py3-none-any.whl</a" target="_blank">https://files.pythonhosted.org/packages/74/83/d0fa07078f4d4ae473a89d7d521aafc66d82641ea0af0ef04a47052e8f17/convertdate-2.1.3-py2.py3-none-any.whl</a</a>>
Collecting holidays>=0.9.5 (from fbprophet)
  Using cached <a href="<a href="https://files.pythonhosted.org/packages/16/09/c882bee98acfa310933b654697405260ec7657c78430a14e785ef0f1314b/holidays-0.9.10.tar.gz" target="_blank">https://files.pythonhosted.org/packages/16/09/c882bee98acfa310933b654697405260ec7657c78430a14e785ef0f1314b/holidays-0.9.10.tar.gz</a>" target="_blank"><a href="https://files.pythonhosted.org/packages/16/09/c882bee98acfa310933b654697405260ec7657c78430a14e785ef0f1314b/holidays-0.9.10.tar.gz</a" target="_blank">https://files.pythonhosted.org/packages/16/09/c882bee98acfa310933b654697405260ec7657c78430a14e785ef0f1314b/holidays-0.9.10.tar.gz</a</a>>
Collecting setuptools-git>=1.2 (from fbprophet)
  Using cached <a href="<a href="https://files.pythonhosted.org/packages/05/97/dd99fa9c0d9627a7b3c103a00f1566d8193aca8d473884ed258cca82b06f/setuptools_git-1.2-py2.py3-none-any.whl" target="_blank">https://files.pythonhosted.org/packages/05/97/dd99fa9c0d9627a7b3c103a00f1566d8193aca8d473884ed258cca82b06f/setuptools_git-1.2-py2.py3-none-any.whl</a>" target="_blank"><a href="https://files.pythonhosted.org/packages/05/97/dd99fa9c0d9627a7b3c103a00f1566d8193aca8d473884ed258cca82b06f/setuptools_git-1.2-py2.py3-none-any.whl</a" target="_blank">https://files.pythonhosted.org/packages/05/97/dd99fa9c0d9627a7b3c103a00f1566d8193aca8d473884ed258cca82b06f/setuptools_git-1.2-py2.py3-none-any.whl</a</a>>
Requirement already satisfied: python-dateutil>=2.5.0 in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from pandas>=0.23.4->fbprophet)
Requirement already satisfied: pytz>=2011k in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from pandas>=0.23.4->fbprophet)
Requirement already satisfied: kiwisolver>=1.0.1 in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from matplotlib>=2.0.0->fbprophet)
Requirement already satisfied: cycler>=0.10 in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from matplotlib>=2.0.0->fbprophet)
Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.1 in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from matplotlib>=2.0.0->fbprophet)
Collecting ephem<3.8,>=3.7.5.3 (from convertdate>=2.1.2->fbprophet)
  Using cached <a href="<a href="https://files.pythonhosted.org/packages/c3/2c/9e1a815add6c222a0d4bf7c644e095471a934a39bc90c201f9550a8f7f14/ephem-3.7.6.0.tar.gz" target="_blank">https://files.pythonhosted.org/packages/c3/2c/9e1a815add6c222a0d4bf7c644e095471a934a39bc90c201f9550a8f7f14/ephem-3.7.6.0.tar.gz</a>" target="_blank"><a href="https://files.pythonhosted.org/packages/c3/2c/9e1a815add6c222a0d4bf7c644e095471a934a39bc90c201f9550a8f7f14/ephem-3.7.6.0.tar.gz</a" target="_blank">https://files.pythonhosted.org/packages/c3/2c/9e1a815add6c222a0d4bf7c644e095471a934a39bc90c201f9550a8f7f14/ephem-3.7.6.0.tar.gz</a</a>>
Requirement already satisfied: six in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from holidays>=0.9.5->fbprophet)
Requirement already satisfied: setuptools in c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages (from kiwisolver>=1.0.1->matplotlib>=2.0.0->fbprophet)
Installing collected packages: ephem, convertdate, holidays, setuptools-git, fbprophet
  Running setup.py install for ephem: started
    Running setup.py install for ephem: finished with status 'error'
    Complete output from command "c:\program files\alteryx\bin\miniconda3\pythontool_venv\scripts\python.exe" -u -c "import setuptools, tokenize;__file__='C:\\Users\\BI\\AppData\\Local\\Temp\\pip-build-3xot9u8p\\ephem\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\BI\AppData\Local\Temp\pip-p6he8u4m-record\install-record.txt --single-version-externally-managed --compile --install-headers "c:\program files\alteryx\bin\miniconda3\pythontool_venv\include\site\python3.6\ephem":
    running install
    running build
    running build_py
    creating build
    creating build\lib.win-amd64-3.6
    creating build\lib.win-amd64-3.6\ephem
    copying ephem\cities.py -> build\lib.win-amd64-3.6\ephem
    copying ephem\stars.py -> build\lib.win-amd64-3.6\ephem
    copying ephem\__init__.py -> build\lib.win-amd64-3.6\ephem
    creating build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_angles.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_bodies.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_cities.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_constants.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_dates.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_github_issues.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_jpl.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_launchpad_236872.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_launchpad_244811.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_locales.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_observers.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_rst.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_satellite.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_stars.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_usno.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\test_usno_equinoxes.py -> build\lib.win-amd64-3.6\ephem\tests
    copying ephem\tests\__init__.py -> build\lib.win-amd64-3.6\ephem\tests
    creating build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\angle.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\catalogs.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\CHANGELOG.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\coordinates.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\date.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\examples.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\faq.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\index.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\newton.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\quick.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\radec.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\reference.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\rise-set.rst -> build\lib.win-amd64-3.6\ephem\doc
    copying ephem\doc\tutorial.rst -> build\lib.win-amd64-3.6\ephem\doc
    creating build\lib.win-amd64-3.6\ephem\tests\jpl
    copying ephem\tests\jpl\europa.txt -> build\lib.win-amd64-3.6\ephem\tests\jpl
    copying ephem\tests\jpl\hyperion.txt -> build\lib.win-amd64-3.6\ephem\tests\jpl
    copying ephem\tests\jpl\jupiter.txt -> build\lib.win-amd64-3.6\ephem\tests\jpl
    copying ephem\tests\jpl\mars.txt -> build\lib.win-amd64-3.6\ephem\tests\jpl
    copying ephem\tests\jpl\neptune.txt -> build\lib.win-amd64-3.6\ephem\tests\jpl
    copying ephem\tests\jpl\oberon.txt -> build\lib.win-amd64-3.6\ephem\tests\jpl
    copying ephem\tests\jpl\phobos.txt -> build\lib.win-amd64-3.6\ephem\tests\jpl
    copying ephem\tests\jpl\saturn.txt -> build\lib.win-amd64-3.6\ephem\tests\jpl
    copying ephem\tests\jpl\uranus.txt -> build\lib.win-amd64-3.6\ephem\tests\jpl
    creating build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\appgeo_deneb.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\appgeo_jupiter.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\appgeo_moon.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\appgeo_sun.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\apptopo_deneb.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\apptopo_moon.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\apptopo_sun.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\astrom_antares.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\astrom_mercury.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\astrom_neptune.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\moon_phases.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\risettran_moon.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\risettran_rigel.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\riset_moon.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    copying ephem\tests\usno\riset_sun.txt -> build\lib.win-amd64-3.6\ephem\tests\usno
    running build_ext
    building 'ephem._libastro' extension
    error: Microsoft Visual C++ 14.0 is required. Get it with "Microsoft Visual C++ Build Tools": <a href="<a href="http://landinghub.visualstudio.com/visual-cpp-build-tools" target="_blank">http://landinghub.visualstudio.com/visual-cpp-build-tools</a>" target="_blank"><a href="http://landinghub.visualstudio.com/visual-cpp-build-tools</a" target="_blank">http://landinghub.visualstudio.com/visual-cpp-build-tools</a</a>>
    
    ----------------------------------------
Command ""c:\program files\alteryx\bin\miniconda3\pythontool_venv\scripts\python.exe" -u -c "import setuptools, tokenize;__file__='C:\\Users\\BI\\AppData\\Local\\Temp\\pip-build-3xot9u8p\\ephem\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\BI\AppData\Local\Temp\pip-p6he8u4m-record\install-record.txt --single-version-externally-managed --compile --install-headers "c:\program files\alteryx\bin\miniconda3\pythontool_venv\include\site\python3.6\ephem"" failed with error code 1 in C:\Users\BI\AppData\Local\Temp\pip-build-3xot9u8p\ephem\
You are using pip version 9.0.1, however version 19.1.1 is available.
You should consider upgrading via the 'python -m pip install --upgrade pip' command.
---------------------------------------------------------------------------
CalledProcessError                        Traceback (most recent call last)
<ipython-input-1-0597692990f2> in <module>
      2 # script here (only missing packages will be installed)
      3 from ayx import Package
----> 4 Package.installPackages('fbprophet')

c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\ayx\Package.py in installPackages(package, install_type, debug)
    112     print(pip_install_result['msg'])
    113     if not pip_install_result['success']:
--> 114         raise pip_install_result['err']

c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\ayx\Utils.py in runSubprocess(args_list, debug)
     39         result = subprocess.check_output(
     40             args_list,
---> 41             stderr = subprocess.STDOUT
     42             )
     43         if debug:

C:\Program Files\Alteryx\bin\Miniconda3\lib\subprocess.py in check_output(timeout, *popenargs, **kwargs)
    334 
    335     return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,
--> 336                **kwargs).stdout
    337 
    338 

C:\Program Files\Alteryx\bin\Miniconda3\lib\subprocess.py in run(input, timeout, check, *popenargs, **kwargs)
    416         if check and retcode:
    417             raise CalledProcessError(retcode, process.args,
--> 418                                      output=stdout, stderr=stderr)
    419     return CompletedProcess(process.args, retcode, stdout, stderr)
    420 

CalledProcessError: Command '['c:\\program files\\alteryx\\bin\\miniconda3\\pythontool_venv\\scripts\\python.exe', '-m', 'pip', 'install', 'fbprophet']' returned non-zero exit status 1.

 

 

How can I install this package? It's pretty urgent :(

Alteryx
Alteryx

Hi @pimp_fada 

 

It looks like ephem (one of the dependencies) is failing to install because of the following error message in the log that you sent over:

 

    error: Microsoft Visual C++ 14.0 is required. Get it with "Microsoft Visual C++ Build Tools": <a href="<a href="http://landinghub.visualstudio.com/visual-cpp-build-tools"

 

 I haven't used the fbprophet package before, but from the message log it looks like this is the issue. Are you currently using this package in Python outside of Alteryx?

Meteor

@BrandonB I use fbprophet outside of Alteryx without any issue. The latest version 0.5 works without any issues. This seems to be an Alteryx issue

Highlighted
Alteryx
Alteryx

I was able to install the R package relatively easily using install.packages from CRAN as referenced here: https://facebook.github.io/prophet/docs/installation.html

 

For Python it looks like your issue may be due to the pystan dependency: 

"The major dependency that Prophet has is pystan. PyStan has its own installation instructions. Install pystan with pip before using pip to install fbprophet."

 

It looks like Pystan requires its own C++ compiler: https://pystan.readthedocs.io/en/latest/windows.html 

 

 

Meteor

@BrandonB I just installed C++ tools requested by installing visual studio but the issue still persists. How can I activate the Python environment created by the Python tool? Maybe I try to install the package via command line?

Alteryx
Alteryx

I believe that the default python directory is C:\Program Files\Alteryx\bin\Miniconda3

Alteryx
Alteryx

@pimp_fada not sure if you ever got this resolved, but take a look at this article that was just written by one of my coworkers: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Manage-packages-for-Python-Tool-with-C... 

 

He was able to get fbprophet working using CONDA in 2019.3

 

@DavidM 

Meteor

@BrandonB this looks like exactly what I was looking for. I will update Alteryx, try to install the fbprophet package and report!

Alteryx
Alteryx

Hi guys,

 

Just fyi you may want to check this out out too, just fresh out of the oven:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-That-Prophet-Time-Series-with-...

 

Thanks @BrandonB for the shout out.

 

dm

David Matyas
Sales Engineer
Alteryx
Labels