dcolombara
commented
1 year ago - didn't work previously. Confirmed these changes work when testing the expected and actual distributions of regions per zip code for 85 zip codes
- 98001 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98001 South 1 ...actual distribution of target target_id count freq 1: South 25114 1 98002 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98002 South 1 ...actual distribution of target target_id count freq 1: South 38684 1 98003 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98003 South 1 ...actual distribution of target target_id count freq 1: South 44256 1 98004 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98004 East 1 ...actual distribution of target target_id count freq 1: East 19823 1 98005 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98005 East 1 ...actual distribution of target target_id count freq 1: East 12036 1 98006 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98006 East 1 ...actual distribution of target target_id count freq 1: East 19782 1 98007 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98007 East 1 ...actual distribution of target target_id count freq 1: East 19171 1 98008 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98008 East 1 ...actual distribution of target target_id count freq 1: East 16260 1 98010 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98010 South 1 ...actual distribution of target target_id count freq 1: South 3859 1 98011 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98011 North 1 ...actual distribution of target target_id count freq 1: North 18048 1 98014 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98014 East 1 ...actual distribution of target target_id count freq 1: East 4633 1 98019 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98019 East 1 ...actual distribution of target target_id count freq 1: East 6992 1 98022 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98022 South 1 ...actual distribution of target target_id count freq 1: South 17615 1 98023 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98023 South 1 ...actual distribution of target target_id count freq 1: South 36195 1 98024 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98024 East 1 ...actual distribution of target target_id count freq 1: East 3798 1 98027 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98027 East 0.997928277 2: 98027 South 0.002071723 ...actual distribution of target target_id count freq 1: East 18911 0.998258024 2: South 33 0.001741976 98028 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98028 North 1 ...actual distribution of target target_id count freq 1: North 15269 1 98029 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98029 East 1 ...actual distribution of target target_id count freq 1: East 17607 1 98030 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98030 South 1 ...actual distribution of target target_id count freq 1: South 28564 1 98031 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98031 South 1 ...actual distribution of target target_id count freq 1: South 31047 1 98032 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98032 South 1 ...actual distribution of target target_id count freq 1: South 30540 1 98033 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98033 East 1 ...actual distribution of target target_id count freq 1: East 22914 1 98034 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98034 North 0.007573582 2: 98034 East 0.992426418 ...actual distribution of target target_id count freq 1: East 33134 0.992392476 2: North 254 0.007607524 98038 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98038 South 0.99325362 2: 98038 East 0.00674638 ...actual distribution of target target_id count freq 1: South 21298 0.992821182 2: East 154 0.007178818 98039 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98039 East 1 ...actual distribution of target target_id count freq 1: East 1389 1 98040 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98040 East 1 ...actual distribution of target target_id count freq 1: East 14650 1 98042 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98042 South 1 ...actual distribution of target target_id count freq 1: South 33211 1 98045 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98045 East 1 ...actual distribution of target target_id count freq 1: East 10767 1 98047 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98047 South 1 ...actual distribution of target target_id count freq 1: South 5599 1 98050 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98050 East 1 ...actual distribution of target target_id count freq 1: East 388 1 98051 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98051 South 1 ...actual distribution of target target_id count freq 1: South 2647 1 98052 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98052 East 1 ...actual distribution of target target_id count freq 1: East 39842 1 98053 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98053 East 1 ...actual distribution of target target_id count freq 1: East 12798 1 98055 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98055 South 1 ...actual distribution of target target_id count freq 1: South 18122 1 98056 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98056 East 0.1883721 2: 98056 South 0.8116279 ...actual distribution of target target_id count freq 1: South 20152 0.8099678 2: East 4728 0.1900322 98057 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98057 South 1 ...actual distribution of target target_id count freq 1: South 11439 1 98058 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98058 South 1 ...actual distribution of target target_id count freq 1: South 30378 1 98059 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98059 South 0.6949492 2: 98059 East 0.3050508 ...actual distribution of target target_id count freq 1: South 16801 0.69679 2: East 7311 0.30321 98065 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98065 East 1 ...actual distribution of target target_id count freq 1: East 8959 1 98068 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98068 East 1 ...actual distribution of target target_id count freq 1: East 198 1 98070 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98070 South 1 ...actual distribution of target target_id count freq 1: South 6972 1 98072 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98072 East 0.357837 2: 98072 North 0.642163 ...actual distribution of target target_id count freq 1: North 10289 0.6381567 2: East 5834 0.3618433 98074 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98074 East 1 ...actual distribution of target target_id count freq 1: East 12063 1 98075 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98075 East 1 ...actual distribution of target target_id count freq 1: East 9782 1 98077 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98077 East 1 ...actual distribution of target target_id count freq 1: East 6156 1 98092 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98092 South 1 ...actual distribution of target target_id count freq 1: South 33068 1 98101 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98101 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 19575 1 98102 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98102 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 10052 1 98103 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98103 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 26599 1 98104 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98104 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 27365 1 98105 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98105 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 16242 1 98106 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98106 South 0.1025437 2: 98106 Seattle 0.8974563 ...actual distribution of target target_id count freq 1: Seattle 17374 0.8950595 2: South 2037 0.1049405 98107 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98107 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 15513 1 98108 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98108 South 0.02435864 2: 98108 Seattle 0.97564136 ...actual distribution of target target_id count freq 1: Seattle 17283 0.97754525 2: South 397 0.02245475 98109 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98109 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 14975 1 98112 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98112 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 13071 1 98115 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98115 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 27835 1 98116 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98116 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 15899 1 98117 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98117 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 20976 1 98118 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98118 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 37152 1 98119 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98119 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 12001 1 98121 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98121 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 11099 1 98122 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98122 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 21420 1 98125 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98125 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 30162 1 98126 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98126 South 0.012425 2: 98126 Seattle 0.987575 ...actual distribution of target target_id count freq 1: Seattle 17332 0.98752208 2: South 219 0.01247792 98133 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98133 Seattle 0.5183697 2: 98133 North 0.4816303 ...actual distribution of target target_id count freq 1: Seattle 20854 0.5162009 2: North 19545 0.4837991 98134 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98134 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 608 1 98136 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98136 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 10441 1 98144 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98144 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 22187 1 98146 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98146 South 0.8357585 2: 98146 Seattle 0.1642415 ...actual distribution of target target_id count freq 1: South 19038 0.8341951 2: Seattle 3784 0.1658049 98148 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98148 South 1 ...actual distribution of target target_id count freq 1: South 9756 1 98155 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98155 North 0.997202159 2: 98155 Seattle 0.002797841 ...actual distribution of target target_id count freq 1: North 25957 0.997463782 2: Seattle 66 0.002536218 98164 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98164 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 71 1 98166 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98166 South 1 ...actual distribution of target target_id count freq 1: South 17645 1 98168 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98168 South 1 ...actual distribution of target target_id count freq 1: South 30866 1 98177 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98177 Seattle 0.4059685 2: 98177 North 0.5940315 ...actual distribution of target target_id count freq 1: Seattle 5764 0.4047469 2: North 8477 0.5952531 98178 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98178 South 0.7417502 2: 98178 Seattle 0.2582498 ...actual distribution of target target_id count freq 1: South 15795 0.7406105 2: Seattle 5532 0.2593895 98188 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98188 South 1 ...actual distribution of target target_id count freq 1: South 20806 1 98195 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98195 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 90 1 98198 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98198 South 1 ...actual distribution of target target_id count freq 1: South 32390 1 98199 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98199 Seattle 1 ...actual distribution of target target_id count freq 1: Seattle 13333 1 98224 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98224 East 1 ...actual distribution of target target_id count freq 1: East 145 1 98288 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98288 East 1 ...actual distribution of target target_id count freq 1: East 271 1 98354 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98354 South 1 ...actual distribution of target target_id count freq 1: South 7625 1 98422 ...expected distribution of target based on crosswalk source_id target_id s2t_fraction 1: 98422 South 1 ...actual distribution of target target_id count freq 1: South 13872 1