# -*-coding:utf-8 -*-
import pandas as pd
xls_file=pd.ExcelFile('D:python_pro\address_list.xlsx')
table=xls_file.parse('Sheet1')
table
for i, row in table.iterrows():
if row['mobile']==13901079723:
print i,row
# -*-coding:utf-8 -*-
import pandas as pd
xls_file=pd.ExcelFile('D:python_pro\address_list.xlsx')
table=xls_file.parse('Sheet1')
table
for i, row in table.iterrows():
if row['mobile']==13901079723:
print i,row