In [1]:

    

import pandas as pd


    

In [2]:

    

xlsfile = pd.ExcelFile('Lec_28_test.xlsx')


    

In [3]:

    

dframe = xlsfile.parse('Sheet1')


    

In [4]:

    

dframe


    

    
Out[4]:






  

    

      

      
This is a test
      
Unnamed: 1
      
Unnamed: 2
    
  
  

    

      
0
      
23
      
6678
      
456
    
    

      
1
      
234
      
678
      
456
    
    

      
2
      
234
      
7
      
345
    
    

      
3
      
34
      
56
      
234
    
    

      
4
      
5
      
456
      
4265
    
  

In [ ]: