Python

Search

Reading Excel and other Microsoft Office files

#read excel

pd.read_excel('/content/drive/My Drive/Site sharing/PSD Resources/Values.xls',index_col=None,header=0) #last two attributes are not compulsary

#attributes given after comma after filename
# if index_col given 0 then it will take 0th coloumn as its label so keeping it none will automatically print coloumn index as 0 ,1,2,3...
# if header will be given 1 then it will take 1st row data as its label,
  #if it is given 0 then it will take its respective row name as in excel file

Comment

PREVIOUS	NEXT

Code Example
Python :: ValueError: minvalue must be less than or equal to maxvalue
Python :: dynamic list in python
Python :: Problem With This?
Python :: aws django create superuser
Python :: make max function returning more than one value python
Python :: slice all elements from list
Python :: enumerate for string
Python :: sum function in python
Python :: data structures in python
Python :: python decorator generator to list
Python :: python check anangram
Python :: python Access both key and value using iteritems() Return keys or values explicitly
Python :: cgi in python; get() method
Python :: python downsample image
Python :: dataframe no names from file
Python :: django multi column index
Python :: split column in exact spot python
Python :: how to write statements in python
Python :: python beacon
Python :: presto sequence example date
Python :: print greeting in python explication
Python :: tf.data.Dataset select files with labels filter
Python :: numpy generate sequence from 0 to n
Python :: Python Importing module from a package
Python :: Python match.span()
Python :: Python DateTime Time Class syntax
Python :: line of best fit in linear regression
Python :: pypy stragger
Python :: ABA Alphabet pyramid
Python :: django chain query

Search

PYTHON

Reading Excel and other Microsoft Office files

ADD CONTENT