In [1]:

    

import pandas as pd
#Read and write to excel


    

In [2]:

    

dataFileUrl = r"../data/coalpublic2012.xls"
data = pd.read_table(dataFileUrl)


    

In [3]:

    

data


    

    
Out[3]:







  

    

      

      
<?xml version="1.0"?>
    
  
  

    

      
0
      
<?mso-application progid="Excel.Sheet"?>
    
    

      
1
      
<Workbook xmlns="urn:schemas-microsoft-com:off...
    
    

      
2
      
xmlns:o="urn:schemas-microsoft-com:office:off...
    
    

      
3
      
xmlns:x="urn:schemas-microsoft-com:office:excel"
    
    

      
4
      
xmlns:ss="urn:schemas-microsoft-com:office:sp...
    
    

      
5
      
xmlns:html="http://www.w3.org/TR/REC-html40">
    
    

      
6
      
<DocumentProperties xmlns="urn:schemas-micros...
    
    

      
7
      
<LastAuthor>Raghuveer, Tejasvi</LastAuthor>
    
    

      
8
      
<LastSaved>2013-12-16T13:32:57Z</LastSaved>
    
    

      
9
      
<Version>14.00</Version>
    
    

      
10
      
</DocumentProperties>
    
    

      
11
      
<OfficeDocumentSettings xmlns="urn:schemas-mi...
    
    

      
12
      
<AllowPNG/>
    
    

      
13
      
</OfficeDocumentSettings>
    
    

      
14
      
<ExcelWorkbook xmlns="urn:schemas-microsoft-c...
    
    

      
15
      
<WindowHeight>10005</WindowHeight>
    
    

      
16
      
<WindowWidth>10005</WindowWidth>
    
    

      
17
      
<WindowTopX>120</WindowTopX>
    
    

      
18
      
<WindowTopY>135</WindowTopY>
    
    

      
19
      
<ProtectStructure>False</ProtectStructure>
    
    

      
20
      
<ProtectWindows>False</ProtectWindows>
    
    

      
21
      
</ExcelWorkbook>
    
    

      
22
      
<Styles>
    
    

      
23
      
<Style ss:ID="Default" ss:Name="Normal">
    
    

      
24
      
<Alignment ss:Vertical="Bottom"/>
    
    

      
25
      
<Borders/>
    
    

      
26
      
<Font ss:FontName="Calibri" x:Family="Swiss...
    
    

      
27
      
<Interior/>
    
    

      
28
      
<NumberFormat/>
    
    

      
29
      
<Protection/>
    
    

      
...
      
...
    
    

      
53746
      
</Print>
    
    

      
53747
      
<Selected/>
    
    

      
53748
      
<FreezePanes/>
    
    

      
53749
      
<FrozenNoSplit/>
    
    

      
53750
      
<SplitHorizontal>4</SplitHorizontal>
    
    

      
53751
      
<TopRowBottomPane>4</TopRowBottomPane>
    
    

      
53752
      
<ActivePane>2</ActivePane>
    
    

      
53753
      
<Panes>
    
    

      
53754
      
<Pane>
    
    

      
53755
      
<Number>3</Number>
    
    

      
53756
      
</Pane>
    
    

      
53757
      
<Pane>
    
    

      
53758
      
<Number>2</Number>
    
    

      
53759
      
<ActiveRow>8</ActiveRow>
    
    

      
53760
      
<ActiveCol>15</ActiveCol>
    
    

      
53761
      
</Pane>
    
    

      
53762
      
</Panes>
    
    

      
53763
      
<ProtectObjects>False</ProtectObjects>
    
    

      
53764
      
<ProtectScenarios>False</ProtectScenarios>
    
    

      
53765
      
</WorksheetOptions>
    
    

      
53766
      
</Worksheet>
    
    

      
53767
      
<ss:DocumentProperties xmlns="urn:schemas-mic...
    
    

      
53768
      
<ss:Author>tr4</ss:Author>
    
    

      
53769
      
<ss:LastAuthor>tr4</ss:LastAuthor>
    
    

      
53770
      
<ss:Created>2013-12-16T08:16:38</ss:Created>
    
    

      
53771
      
<ss:LastSaved>2013-12-16T08:16:38</ss:LastS...
    
    

      
53772
      
<ss:Company>SAS Institute Inc. http://www.s...
    
    

      
53773
      
<ss:Version>9.02.02M3P04132010</ss:Version>
    
    

      
53774
      
</ss:DocumentProperties>
    
    

      
53775
      
</Workbook>
    
  

53776 rows × 1 columns

In [ ]: