Reading xlsx file using jupyter notebook

Question

I have tried to read an xlsx file which is stored in my system using jupyter notebook.I had run the jupyter notebook from the present directory where my file is present.But it is showing an error as "module not found error".

Answer 1

The below code should able to access /read your excel file

import pandas as pd
path = ('...\\filename.xlsx')
xl = pd.ExcelFile(path)
print(xl.sheet_names)

The above command shows the sheets in a xlsx file

df1 = xl.parse('Sheet1')

Above command parses the sheet required

Answer 2

Same outout, but this one worked for me.

import pandas as pd

df = pd.read_excel (r'C:\Users\(NAME)\Desktop\(FILENAME).xlsx')
print (df)