xlrd >= 2.0, only the xls format is supported. Install openpyxl instead #1
Description
Hi John,
I was trying to reproduce your code - I'm almost there.
At some stage, (I don't remember when), I got this error regarding xls/xlsx files:
"Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead."
I added "import openpyxl" to the code and altered taxonomy_df = pd.read_excel(taxonomy_path, header=0).fillna('') --> taxonomy_df = pd.read_excel(taxonomy_path, header=0, engine='openpyxl').fillna(''). It seemed to work but then the last section of the code (the Main section), gives me an error: "Processing raw-spacytest-small
Preparing taxon patterns
Argument 'string' has incorrect type (expected str, got int)".
That may relate to the imported xlsx file or not. I'm quite new to Jupyter Notebook / python and therefore not able to say what is going on here. If you find a way to fix this, it would be great.
All the best,
-Kari