Import excel file with xlrd error
I am a beginner in python, and I have the following (embarassing) issue:
I am trying to import an excel file using xlrd but I have the "FilenotfoundError".
Anyone is able to help a newbie?
Thanks a lot,
#load the data file
wb = xlrd.open_workbook(path)
sheet = wb.sheet_by_index(0)
You don't need to do all of that. You can't import an xl spreadsheet directly to a python repl. You have to convert it into csv. So go to the xl file you want to import and save it as `CSV, there should be an option there. After that, you can upload the file directly into you repl. And because you will be dealing with CSV, it is best to use Jupyter and pandas. it is a better data visualizer.