In [1]:

    

from __future__ import division
%pylab --no-import-all
%matplotlib inline
import pandas as pd


    

    




Using matplotlib backend: MacOSX
Populating the interactive namespace from numpy and matplotlib

In [2]:

    

df=pd.read_excel('http://www.rug.nl/research/ggdc/data/pwt/v80/pwt80.xlsx',sheetname=1)
dfpwt=pd.read_excel('http://www.rug.nl/research/ggdc/data/pwt/v80/pwt80.xlsx',sheetname=2)


    

In [4]:

    

df


    

    
Out[4]:






  

    

      

      
Variable name
      
Variable definition
    
  
  

    

      
0 
      
                             Identifier variables
      
                                               NaN
    
    

      
1 
      
                                      countrycode
      
                         3-letter ISO country code
    
    

      
2 
      
                                          country
      
                                      Country name
    
    

      
3 
      
                                    currency_unit
      
                                     Currency unit
    
    

      
4 
      
                                             year
      
                                              Year
    
    

      
5 
      
                                              NaN
      
                                               NaN
    
    

      
6 
      
       Real GDP, employment and population levels
      
                                               NaN
    
    

      
7 
      
                                            rgdpe
      
 Expenditure-side real GDP at chained PPPs (in ...
    
    

      
8 
      
                                            rgdpo
      
 Output-side real GDP at chained PPPs (in mil. ...
    
    

      
9 
      
                                              pop
      
                          Population (in millions)
    
    

      
10
      
                                              emp
      
           Number of persons engaged (in millions)
    
    

      
11
      
                                              avh
      
    Average annual hours worked by persons engaged
    
    

      
12
      
                                               hc
      
 Index of human capital per person, based on ye...
    
    

      
13
      
                                              NaN
      
                                               NaN
    
    

      
14
      
               Current price GDP, capital and TFP
      
                                               NaN
    
    

      
15
      
                                            cgdpe
      
 Expenditure-side real GDP at current PPPs (in ...
    
    

      
16
      
                                            cgdpo
      
 Output-side real GDP at current PPPs (in mil. ...
    
    

      
17
      
                                               ck
      
   Capital stock at current PPPs (in mil. 2005US$)
    
    

      
18
      
                                             ctfp
      
                 TFP level at current PPPs (USA=1)
    
    

      
19
      
                                              NaN
      
                                               NaN
    
    

      
20
      
                National accounts-based variables
      
                                               NaN
    
    

      
21
      
                                           rgdpna
      
 Real GDP at constant 2005 national prices (in ...
    
    

      
22
      
                                             rkna
      
 Capital stock at constant 2005 national prices...
    
    

      
23
      
                                           rtfpna
      
          TFP at constant national prices (2005=1)
    
    

      
24
      
                                            labsh
      
 Share of labour compensation in GDP at current...
    
    

      
25
      
                                              NaN
      
                                               NaN
    
    

      
26
      
              Exchange rates and GDP price levels
      
                                               NaN
    
    

      
27
      
                                               xr
      
 Exchange rate, national currency/USD (market+e...
    
    

      
28
      
                                          pl_gdpe
      
 Price level of CGDPe (PPP/XR), price level of ...
    
    

      
29
      
                                          pl_gdpo
      
 Price level of CGDPo (PPP/XR),  price level of...
    
    

      
30
      
                                              NaN
      
                                               NaN
    
    

      
31
      
                       Data information variables
      
                                               NaN
    
    

      
32
      
                                            i_cig
      
 0/1/2: relative price data for consumption, in...
    
    

      
33
      
                                             i_xm
      
 0/1/2: relative price data for exports and imp...
    
    

      
34
      
                                             i_xr
      
 0/1: the exchange rate is market-based (0) or ...
    
    

      
35
      
                                        i_outlier
      
 0/1: the observation on pl_gdpe or pl_gdpo is ...
    
    

      
36
      
                                          cor_exp
      
 Correlation between expenditure shares of the ...
    
    

      
37
      
                                          statcap
      
 Statistical capacity indicator (source: World ...
    
    

      
38
      
                                              NaN
      
                                               NaN
    
    

      
39
      
                                  Shares in CGDPo
      
                                               NaN
    
    

      
40
      
                                            csh_c
      
    Share of household consumption at current PPPs
    
    

      
41
      
                                            csh_i
      
  Share of gross capital formation at current PPPs
    
    

      
42
      
                                            csh_g
      
   Share of government consumption at current PPPs
    
    

      
43
      
                                            csh_x
      
      Share of merchandise exports at current PPPs
    
    

      
44
      
                                            csh_m
      
      Share of merchandise imports at current PPPs
    
    

      
45
      
                                            csh_r
      
 Share of residual trade and GDP statistical di...
    
    

      
46
      
                                              NaN
      
                                               NaN
    
    

      
47
      
 Price levels, expenditure categories and capital
      
                                               NaN
    
    

      
48
      
                                             pl_c
      
 Price level of household consumption,  price l...
    
    

      
49
      
                                             pl_i
      
 Price level of capital formation,  price level...
    
    

      
50
      
                                             pl_g
      
 Price level of government consumption,  price ...
    
    

      
51
      
                                             pl_x
      
 Price level of exports, price level of USA GDP...
    
    

      
52
      
                                             pl_m
      
 Price level of imports, price level of USA GDP...
    
    

      
53
      
                                             pl_k
      
 Price level of the capital stock, price level ...