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

2 votes154 views1 answer
Pandas series plot horizontal bar
Python
4 votes102 views1 answer
How to read a file into array in python
Python
1 vote103 views1 answer
Windows alert python
Python
0 vote106 views2 answers
How to find the transpose of a matrix in python
Python
2 votes106 views1 answer
Remove duplicates based on two columns in dataframe
Python
66 votes101 views6 answers
Alphabet python
Python
14 votes100 views5 answers
Python trim whitespace from end of string
Python
0 vote106 views2 answers
Adding a new column in pandas dataframe from another dataframe with different index
Python
0 vote115 views1 answer
Creating fake instagram accounts with python
Python
29 votes110 views4 answers
Basic flask app python
Python