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

1 vote208 views1 answer
'Polygon' object has no property 'normed'
Python
39 votes181 views4 answers
Convert datetime to date python
Python
-1 vote197 views1 answer
Create excel file python
Python
1 vote212 views1 answer
Correr servidor django
Python
0 vote195 views1 answer
Rounding with .2g gives strange results
Python
0 vote186 views1 answer
Python save base64 temp file
Python
1 vote210 views1 answer
Pygame disable message
Python
0 vote191 views1 answer
How to uninstall python-dotenv
Python
1 vote168 views1 answer
Key down python
Python
0 vote268 views1 answer
Python , cv2 change font type
Python