In [1]:
import pandas as pd

In [8]:
p = pd.read_pickle("../CDPdata/sheet18_2014.pkl")
initiatives = p[p.columns[14:15]]

In [9]:
initiatives.rename(columns={p.columns[14]:"itype"}, inplace=True)

In [11]:
initiatives.itype.value_counts()


Out[11]:
Energy efficiency: Building services    1974
Energy efficiency: Processes            1909
Low carbon energy installation           558
Behavioral change                        533
Energy efficiency: Building fabric       476
Process emissions reductions             468
Transportation: fleet                    464
Other                                    382
Transportation: use                      329
Low carbon energy purchase               287
Product design                           187
Fugitive emissions reductions            110
dtype: int64

In [ ]: