search

learn-co-students / dsc-1-03-04-importing-data-using-pandas-seattle-ds-career-040119

Other
0 stars 24 forks source link

error in final box: ModuleNotFoundError: No module named 'openpyxl' #2

Open UpwardTrajectory opened 5 years ago

UpwardTrajectory commented 5 years ago

when resolving df.to_excel(...) it refers to openpyxl, which we never installed on our learn-env. I tried going to command line and using conda install openpyxl but this doesn't seem to be immediately usable in this notebook, b/c when I attempted import openpyxl I got: ModuleNotFoundError: No module named 'openpyxl'

cenuno commented 5 years ago

Just want to second @UpwardTrajectory note here. When I run pd.__version__ in the Learn.co jupyter notebook, the output returns 0.23.4. This is a few versions behind the most up-to-date version of pandas which is currently at 0.24.2.

I was able to resolve this by doing this:

!pip install openpyxl
import openpyxl
df.to_excel('NewSavedView.xlsx')

staff