nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Alteryx Python Import Error, How to install module in alteryx python?

wonka1234

Hi,

I am getting the error:


ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.

my code:

from ayx import Alteryx

import pandas as pd
import zipfile

archive = zipfile.ZipFile(r'O:\Alteryx\Original - All fields - October 2022.zip')
xlfile = archive.open('Original - All fields - October 2022.xls')

df = pd.concat(pd.read_excel(xlfile, header = 1, sheet_name=None), ignore_index=True)

Alteryx.write(df, 1)

However I have this module installed on my python on pc and the code runs fine locally.

Why doesnt this work in alteryx python tool?

Thanks.

Custom Tools

Accepted answers

IraWatt

@wonka1234 from reading the blog I think there are a few options. If you have already got the xlrd module on your computer, you can reference it with:

examplePackage = Alteryx.importPythonModule("C:\\ProgramData\\PythonLibs\\example")

All comments

IraWatt

Hey @wonka1234,

Alteryx has its own Python environment separate from the one on your PC. You can do the equivalent of a PIP install here:

There is a good blog on the topic here: How To: Use Alteryx.installPackages() in Python to... - Alteryx Community

wonka1234

@IraWatt

getting an error on line Package.installPackages(['xlrd'])

getting an SSL error here

ERROR: Could not find a version that satisfies the requirement xlrd (from versions: none)

IraWatt

@wonka1234 you may need to run Alteryx in Admin mode to allow package installs (you will only need to do this once):

wonka1234

@IraWatt company will not allow admin priviledges . is there any console for alteryx similar to anaconda prompt I can run? I could try installing there..

IraWatt

@wonka1234 from reading the blog I think there are a few options. If you have already got the xlrd module on your computer, you can reference it with:

examplePackage = Alteryx.importPythonModule("C:\\ProgramData\\PythonLibs\\example")

wonka1234

@IraWatt seems to be working to install it, but now getting a new error!

KeyError: 0

The above exception was the direct cause of the following exception:

KeyError                                  Traceback (most recent call last)
<ipython-input-2-f55c6e3a6b4a> in <module>
     11 df = pd.concat(pd.read_excel(xlfile, header = 1, sheet_name=None), ignore_index=True)
     12 
---> 13 Alteryx.write(df, 1)
     14

IraWatt

@wonka1234 you will want to check the bottom of the error message for the useful information. I would guess pd.concat is returning a Series not a dataframe causing Alteryx.write to throw an error.

Why not write:

df = pd.read_excel(xlfile, header = 1, sheet_name=None)

Alteryx.write(df, 1)

wonka1234

@IraWatt

there are several sheets and I want to read them and concat them!

IraWatt

@wonka1234,

What does the error message say at the bottom? Does my code work at least, that way you know it is a dataframe issue?

wonka1234

No it didnt - I think for some reason it is not being read in as a DF. Getting this at the bottom

KeyError: 0

and when i run your code:

ERROR: Alteryx.write(pandas_df, outgoing_connection_number):
Currently only pandas dataframes can be used to pass data to outgoing connections in Alteryx

TypeError: Currently only pandas dataframes can be used to pass data to outgoing connections in Alteryx

IraWatt

pd.read_excel should always return a DataFrame pandas.read_excel — pandas 1.5.2 documentation (pydata.org). You can check if it is a dataframe by doing things like this: python - Testing if a pandas DataFrame exists - Stack Overflow. Does this work:

pd.read_excel(xlfile, header = 1, sheet_name=None).head()

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703