Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi! I am trying to import xlsx file via python script but it shows
"Details: "ADO.NET: Python script error.
<pi>ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.
</pi>""
You may say why i am not importing directly to power bi, the issue is i have a large dataset which i am trying to make pivot table by using lookup formula of python. To do the look up i need to import xlsx file and then squeeze it via pivot_table.
You also may say that i need to only install xlrd library to python but this one also already installed and when i write a script "import xlrd" it shows :
Details: "ADO.NET: Python script error.
<pi>ModuleNotFoundError: No module named 'xlrd'
</pi>"
Could someone help with this issue please, I would really appreciate it in advance!
@Ismail94 , it seems it not installed or not the proper version
use as suggested
pip install xlrd
or
conda install xlrd
I have already installed 2.0.1 version of xlrd but not working
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |