In [1]:
import numpy as np, pandas as pd, os
from synthicity.utils import misc
from drcog.models import elcm_simulation, hlcm_simulation, regression_model_simulation, dataset
dset = dataset.DRCOGDataset(os.path.join(misc.data_dir(),'drcog.h5'))
#Variable Library
from drcog.variables import variable_library
variable_library.calculate_variables(dset)
In [2]:
establishments = dset.establishments
households = dset.households
households_for_estimation = dset.households_for_estimation
buildings = dset.buildings
In [17]:
def export_uc(variable,name):
df = pd.DataFrame({'values':variable}, index=variable.index)
df = df[df.values>0]
df.to_csv('c://users//janowicz//desktop//%s.csv'%name)
In [18]:
variable = buildings.groupby('parcel_id').non_residential_sqft.sum()
export_uc(variable,'non_residential_sqft')
In [19]:
variable = buildings.groupby('parcel_id').residential_units.sum()
export_uc(variable,'residential_units')
In [3]:
dset.travel_data.columns
Out[3]:
In [5]:
td = dset.travel_data
td.am_single_vehicle_to_work_travel_time = td.am_single_vehicle_to_work_travel_time*2
In [10]:
td.head()
Out[10]:
In [8]:
td.to_csv('C:\\urbansim\\data\\swap\\travel_data.csv')
In [11]:
td2 = pd.read_csv('C:\\urbansim\\data\\swap\\travel_data.csv', index_col=['from_zone_id','to_zone_id'])
In [15]:
td2.head()
Out[15]:
In [2]:
dist_rail = dset.parcels[['dist_rail']]
In [5]:
dist_rail.to_csv('C:\\urbansim\\data\\swap\\parcel_dist_rail.csv')
In [8]:
dist_rail.dist_rail.index.values.max()
Out[8]:
In [22]:
if dset.parcels.index.name != 'parcel_id':
print 'yoyo'
dset.parcels = dset.parcels.set_index('parcel_id')
In [10]:
p2 = pd.read_csv('C:\\urbansim\\data\\swap\\parcel_dist_rail.csv', index_col=['parcel_id'])
In [15]:
p2.dist_rail
Out[15]:
In [14]:
dist_rail.di
Out[14]:
In [25]:
dset.parcels
Out[25]: