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 vote261 views1 answer
How to make a password generating program in python
Python
0 vote320 views1 answer
Superpixel
Python
0 vote316 views1 answer
Django get group users
Python Django
0 vote237 views1 answer
How to take out every even number from a list in python
Python
21 votes231 views5 answers
Basic tkinter window
Python
1 vote265 views1 answer
Filter with different operator in django
Python Django
0 vote281 views1 answer
How to order randomly in django orm
Python Django
0 vote264 views1 answer
Assign multiple vabies in one line
Python
2 votes246 views3 answers
Discord.py clear
Python
0 vote246 views1 answer
How to change the starting number for the loop count in pythin
Python