Read excel file spyder

How to read excel file in jupyter notebook

import pandas as pd

df = pd.read_excel (r'Path where the Excel file is stored\File name.xlsx', sheet_name='your Excel sheet name')
print (df)

Source: datatofish.com

Read excel file spyder

import pandas as pd

df = pd.read_excel (r'C:\Users\Ron\Desktop\Product List.xlsx') #place "r" before the path string to address special character, such as '\'. Don't forget to put the file name at the end of the path + '.xlsx'
print (df)

Source: datatofish.com

Similar codes

0 vote269 views1 answer
List Get a Element
Python
24 votes331 views6 answers
Strings in python
Python
-2 votes332 views2 answers
Where to import reverse_lazy in django
Python Django
0 vote280 views1 answer
Check this id exist in database django
Python
0 vote303 views1 answer
Mac big sur and python3 problems
Python
0 vote253 views1 answer
How to open html file in python
Python
0 vote309 views2 answers
Displaying flash message django
Python Django
71 votes285 views6 answers
Shuffle array python
Python
10 votes290 views6 answers
Declaring variables in python
Python
2 votes269 views3 answers
Python pandas difference between two data frames
Python