In [1]:

    

import pandas as pd

xlsfile = 'lecture28_in.xlsx'


    

In [2]:

    

xls = pd.ExcelFile(xlsfile)


    

In [4]:

    

df = xls.parse('Sheet1')


    

In [5]:

    

df


    

    
Out[5]:






  

    

      

      
Column A
      
Column B
    
  
  

    

      
0
      
dog
      
55
    
    

      
1
      
cat
      
14
    
    

      
2
      
horse
      
65
    
    

      
3
      
rabbit
      
98
    
  

In [ ]: