pandas read_excel from outside file (xlrd needed?)

I'm trying to use the Python tool to bring in data using pd.read_excel("/path/"). However, when I do, I get an error:

ModuleNotFoundError Traceback (most recent call last)
c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\pandas\io\excel.py in __init__(self, io, **kwds)
351 try:
--> 352 import xlrd
353 except ImportError:

ModuleNotFoundError: No module named 'xlrd'

Does that mean xlrd is a dependency for pandas when trying to use read_excel? If that's the case, is there any way to use pandas for reading in outside data files?

Python

Accepted answers

All comments

Derangedvisions

To read in using jupyter notebooks (python tool) the the syntax is slightly different- you must use "Alteryx.read("#1")" you can read more about it Here or you can type in Alteryx.help() in the notebook to learn more.

hope that helps?

BenMoss

I'm thinking along the same lines as the poster above.

It sound spoke your trying to read in an excel file with python, why not just use the input data tool and then stream the data into python by connecting it to the python tool and then using the syntax notes by the user above.

Ben

DanWhalen

Sorry, I forgot to mention the file is outside Alteryx. I'm reading the data in from a fixed location/path, its not something inside the workflow.

I don't think its an Alteryx.read or Alteryx.write issue, because so far, I've only been getting this error with Excel files. CSVs, for example, seem to read in fine with traditional pandas syntax.

This is working for me fine:

from ayx import Alteryx
import pandas as pd
df = pd.read_csv("S:/PATH/TO/FILE/Data.csv")
Alteryx.write(df,1)

This is not:

from ayx import Alteryx
import pandas as pd
df = pd.read_excel("S:/PATH/TO/FILE/Data.xlsx")
Alteryx.write(df,1)

I'm wondering if it has something to do with the fact that Excel files aren't flat. Wouldn't they need a parser, then? Must be that pandas parses Excel files with xlrd? I never knew that, but it would make sense to me (given my very limited understanding of python under the hood!).

Promydia

I have had the same problem. I noticed that it fails then it tries to create a folder in the Alteryx Miniconda Env folder.

When I tried to do it manually it required me to continue as admin.

When I restarted the Alteryx app in admin mode:

Then I ran:

from ayx import Package
Package.installPackages(['xlrd', '-q'])

and it works!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703