In [1]:
import pandas as pd, os
from synthicity.utils import misc
coeff_store_path = os.path.join(misc.data_dir(),'coeffs.h5')
coeff_store = pd.HDFStore(coeff_store_path)

In [2]:
coeff_store.coeffs


Out[2]:
<class 'pandas.core.frame.DataFrame'>
Int64Index: 23 entries, 0 to 22
Data columns (total 94 columns):
(hh_location_1, coeffs)        20  non-null values
(hh_location_1, fnames)        20  non-null values
(hh_location_2, coeffs)        21  non-null values
(hh_location_2, fnames)        21  non-null values
(hh_location_3, coeffs)        22  non-null values
(hh_location_3, fnames)        22  non-null values
(hh_location_4, coeffs)        18  non-null values
(hh_location_4, fnames)        18  non-null values
(hh_location_5, coeffs)        21  non-null values
(hh_location_5, fnames)        21  non-null values
(emp_location_11, coeffs)      23  non-null values
(emp_location_11, fnames)      23  non-null values
(emp_location_21, coeffs)      23  non-null values
(emp_location_21, fnames)      23  non-null values
(emp_location_22, coeffs)      23  non-null values
(emp_location_22, fnames)      23  non-null values
(emp_location_23, coeffs)      23  non-null values
(emp_location_23, fnames)      23  non-null values
(emp_location_31, coeffs)      23  non-null values
(emp_location_31, fnames)      23  non-null values
(emp_location_32, coeffs)      23  non-null values
(emp_location_32, fnames)      23  non-null values
(emp_location_33, coeffs)      23  non-null values
(emp_location_33, fnames)      23  non-null values
(emp_location_42, coeffs)      23  non-null values
(emp_location_42, fnames)      23  non-null values
(emp_location_44, coeffs)      23  non-null values
(emp_location_44, fnames)      23  non-null values
(emp_location_45, coeffs)      23  non-null values
(emp_location_45, fnames)      23  non-null values
(emp_location_48, coeffs)      23  non-null values
(emp_location_48, fnames)      23  non-null values
(emp_location_49, coeffs)      23  non-null values
(emp_location_49, fnames)      23  non-null values
(emp_location_51, coeffs)      23  non-null values
(emp_location_51, fnames)      23  non-null values
(emp_location_52, coeffs)      23  non-null values
(emp_location_52, fnames)      23  non-null values
(emp_location_53, coeffs)      23  non-null values
(emp_location_53, fnames)      23  non-null values
(emp_location_54, coeffs)      23  non-null values
(emp_location_54, fnames)      23  non-null values
(emp_location_55, coeffs)      23  non-null values
(emp_location_55, fnames)      23  non-null values
(emp_location_56, coeffs)      23  non-null values
(emp_location_56, fnames)      23  non-null values
(emp_location_61, coeffs)      23  non-null values
(emp_location_61, fnames)      23  non-null values
(emp_location_62, coeffs)      23  non-null values
(emp_location_62, fnames)      23  non-null values
(emp_location_71, coeffs)      23  non-null values
(emp_location_71, fnames)      23  non-null values
(emp_location_81, coeffs)      23  non-null values
(emp_location_81, fnames)      23  non-null values
(emp_location_92, coeffs)      23  non-null values
(emp_location_92, fnames)      23  non-null values
(emp_location_7211, coeffs)    23  non-null values
(emp_location_7211, fnames)    23  non-null values
(emp_location_7221, coeffs)    23  non-null values
(emp_location_7221, fnames)    23  non-null values
(emp_location_7222, coeffs)    23  non-null values
(emp_location_7222, fnames)    23  non-null values
(emp_location_7223, coeffs)    23  non-null values
(emp_location_7223, fnames)    23  non-null values
(emp_location_7224, coeffs)    23  non-null values
(emp_location_7224, fnames)    23  non-null values
(resprice_2, coeffs)           21  non-null values
(resprice_2, fnames)           21  non-null values
(resprice_3, coeffs)           21  non-null values
(resprice_3, fnames)           21  non-null values
(resprice_20, coeffs)          21  non-null values
(resprice_20, fnames)          21  non-null values
(resprice_24, coeffs)          21  non-null values
(resprice_24, fnames)          21  non-null values
(nrprice_5, coeffs)            20  non-null values
(nrprice_5, fnames)            20  non-null values
(nrprice_8, coeffs)            20  non-null values
(nrprice_8, fnames)            20  non-null values
(nrprice_9, coeffs)            20  non-null values
(nrprice_9, fnames)            20  non-null values
(nrprice_11, coeffs)           20  non-null values
(nrprice_11, fnames)           20  non-null values
(nrprice_16, coeffs)           20  non-null values
(nrprice_16, fnames)           20  non-null values
(nrprice_17, coeffs)           20  non-null values
(nrprice_17, fnames)           20  non-null values
(nrprice_18, coeffs)           20  non-null values
(nrprice_18, fnames)           20  non-null values
(nrprice_21, coeffs)           20  non-null values
(nrprice_21, fnames)           20  non-null values
(nrprice_22, coeffs)           20  non-null values
(nrprice_22, fnames)           20  non-null values
(nrprice_23, coeffs)           20  non-null values
(nrprice_23, fnames)           20  non-null values
dtypes: float64(47), object(47)

In [3]:
print coeff_store.coeffs[('hh_location_1', 'fnames')]
print coeff_store.coeffs[('hh_location_1', 'coeffs')]


0                              ln_dist_rail
1                    ln_avg_unit_price_zone
2                        median_age_of_head
3                median_yearbuilt_post_1990
4     percent_hh_with_child_x_hh_with_child
5                 percent_renter_hh_in_zone
6                                  townhome
7                               multifamily
8                         jobs_within_45min
9                                county8001
10                               county8005
11                               county8013
12                               county8014
13                               county8019
14                               county8031
15                               county8035
16                               county8039
17                               county8047
18                               county8059
19                               county8123
20                                      NaN
21                                      NaN
22                                      NaN
Name: (hh_location_1, fnames), dtype: object
0    -0.118801
1     0.080263
2     0.002833
3    -0.179051
4    -0.000572
5    -0.002036
6     1.292723
7     2.141486
8     0.005013
9     0.000100
10    0.000100
11    0.000100
12    0.000100
13    0.000100
14    0.000100
15    0.000100
16    0.000100
17    0.000100
18    0.000100
19    0.000100
20         NaN
21         NaN
22         NaN
Name: (hh_location_1, coeffs), dtype: float64

In [4]:
print coeff_store.coeffs[('emp_location_11', 'fnames')]
print coeff_store.coeffs[('emp_location_11', 'coeffs')]


0                         ln_jobs_within_30min
1                ln_avg_nonres_unit_price_zone
2                            median_year_built
3             ln_residential_unit_density_zone
4                          ln_pop_within_20min
5                                   nonres_far
6                                       office
7                         retail_or_restaurant
8                          industrial_building
9     employees_x_ln_non_residential_sqft_zone
10                                ln_dist_rail
11                            rail_within_mile
12                                  county8001
13                                  county8005
14                                  county8013
15                                  county8014
16                                  county8019
17                                  county8031
18                                  county8035
19                                  county8039
20                                  county8047
21                                  county8059
22                                  county8123
Name: (emp_location_11, fnames), dtype: object
0     0.037131
1    -0.058391
2    -0.000077
3    -1.155136
4     0.053440
5     0.009870
6     3.000000
7     2.836146
8     2.709390
9     0.001911
10    0.453700
11    0.910769
12    0.000100
13    0.000100
14    0.000100
15    0.000100
16    0.000100
17    0.000100
18    0.000100
19    0.000100
20    0.000100
21    0.000100
22    0.000100
Name: (emp_location_11, coeffs), dtype: float64