When I tried to read a xlsx file (xls = pd.ExcelFile(‘yelp.xlsx’)), I got a msg: 'ImportError: Missing optional dependency ‘openpyxl’. Use pip or conda to install openpyxl.
Anyone can help me to figure it out? Thanks a lot
When I tried to read a xlsx file (xls = pd.ExcelFile(‘yelp.xlsx’)), I got a msg: 'ImportError: Missing optional dependency ‘openpyxl’. Use pip or conda to install openpyxl.
Anyone can help me to figure it out? Thanks a lot
Hello,
you can install the missing dependency via Environments → Packages, or by executing the following command:
!pip install openpyxl
Will ask the devs if it is possible to include this package into the default env.
Thank you!