Search
 
SCRIPT & CODE EXAMPLE
 

PYTHON

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 
ADD CONTENT
Topic
Content
Source link
Name
2+5 =