Python read xls

# credit to Stack Overflow user in the source link

import pandas as pd

# use r before absolute file path
xls = pd.ExcelFile(r"yourfilename.xls")  

# 2 is the sheet number+1 thus 
# if the file has only 1 sheet write 0 in paranthesis
sheetX = xls.parse(2) 
var1 = sheetX['ColumnName']

# 1 is the row number
print(var1[1])

Source: stackoverflow.com

Similar codes

0 vote116 views1 answer
Terminal output redirect to a file
Python
0 vote109 views1 answer
Tags['tag'].value_counts()
Python
84 votes110 views6 answers
Python datetime from string
Python
3 votes112 views2 answers
Spark add column to dataframe
Python
-1 vote104 views1 answer
Histogram image processing python
Python
0 vote94 views1 answer
How to create frequency table in python
Python
6 votes146 views5 answers
How to create list python
Python
33 votes101 views4 answers
Split word python
Python
0 vote108 views1 answer
[Solved] TypeError: 'NoneType' object is not subscriptable
Python
0 vote109 views2 answers
How to put a header title per dataframe after concatenate using pandas in python
Python