Python

Search

read excel file spyder

import pandas as pd

df = pd.read_excel (r'C:UsersRonDesktopProduct 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)

Comment

PREVIOUS	NEXT

Code Example
Python :: python hello world
Python :: print a text in python
Python :: remove first 2 rows in pandas
Python :: star operator python
Python :: accessing data on django sessionstore
Python :: column.replace
Python :: remove all rows without a value pandas
Python :: label encoding column pandas
Python :: selectfield flask wtf
Python :: pyhton regex to find string in file
Python :: df concat
Python :: import matplotlib plt
Python :: merge two dataframes with common columns
Python :: py how to deactivate venv
Python :: read live video from usb opencv python
Python :: delete specific indeces from numpy array
Python :: python extract text from image
Python :: how to get location using python
Python :: os.listdir in python
Python :: python day of the week
Python :: pyqt5 qlineedit on change
Python :: find how many of each columns value pd
Python :: simple http server python
Python :: find the first occurrence of item in a list in python
Python :: colored text in py
Python :: how to replace first line of a textfile python
Python :: random.shuffle
Python :: convert string to utf8 python
Python :: python print utf-8
Python :: how to add delay in python

Search

PYTHON

read excel file spyder

ADD CONTENT