TAZ analysis summaries

Below are the freshly-generated TAZ-level summary CSV snapshots created by analysis/analyze_taz_controls_vs_results.py.

taz_analysis_summary.csv (regional variable summary)

Header + values (current):

variable,total_control,total_result,total_diff,total_diff_pct,mae,rmse,mape,r_squared,perfect_matches,perfect_pct,taz_count
numhh_gq,3032012.0,3032146,134.0,0.004419507574508281,0.028438030560271648,1.459411235566984,0.0010244036045110572,0.9999885650036583,4710,99.95755517826825,4712
hh_gq_university,52288.0,50802,-1486.0,-2.841952264381885,1.034804753820034,14.765038663114288,4.919743033221721,0.994980653630686,4553,96.62563667232598,4712
hh_gq_noninstitutional,76791.0,73764,-3027.0,-3.9418681876782435,2.4267826825127337,11.86092119579686,8.412914357934476,0.9730913672362441,3189,67.67826825127334,4712
hh_size_1,914150.0,899379,-14771.0,-1.6158179729803643,40.11481324278438,117.517994323479,21.864096890398155,0.8184852584093216,130,2.7589134125636674,4712
hh_size_2,972432.0,934422,-38010.0,-3.9087566020040474,40.0606960950764,124.33003651421681,19.78459708452401,0.5699461242316931,81,1.7190152801358234,4712
hh_size_3,510692.0,488644,-22048.0,-4.31727929946034,19.765704584040748,49.50318540281491,21.461495901277203,0.7146511407319989,229,4.8599320882852295,4712
hh_size_4,446230.0,423919,-22311.0,-4.999887950160231,17.980263157894736,45.28115573299923,23.735401069817957,0.757308454236321,321,6.812393887945671,4712
hh_size_5,181861.0,173631,-8230.0,-4.525434260231716,7.362478777589134,15.578583858696684,22.04700454408305,0.8755998353934838,1158,24.57555178268251,4712
hh_size_6_plus,120378.0,112151,-8227.0,-6.834305271727392,5.787988115449915,15.837694124406754,22.61037657111827,0.8327230582316584,1901,40.34380305602717,4712
hh_wrks_0,610138.0,640123,29985.0,4.914461974176334,20.064728353140918,32.17656417073793,23.01606715702099,0.9064976897039876,123,2.6103565365025467,4712
hh_wrks_1,1020038.0,1064960,44922.0,4.403953578200028,31.917657045840407,53.787104696004484,22.582678419701008,0.8978324006886346,60,1.2733446519524618,4712
hh_wrks_2,884346.0,922419,38073.0,4.305215379500783,26.65683361629881,42.28756705787203,19.535692268771676,0.910426032655451,81,1.7190152801358234,4712
hh_wrks_3_plus,268013.0,280078,12065.0,4.501647308152963,8.996392190152802,14.310014955043979,20.628925607066364,0.9268744804991272,336,7.130730050933787,4712
pers_age_00_19,1693504.0,1699288,5784.0,0.3415403801821549,48.946519524618,89.83677662647395,20.326388501727763,0.9009780813061613,50,1.061120543293718,4712
pers_age_20_34,1577133.0,1584180,7047.0,0.44682344482044317,50.524405772495754,110.44077552304867,20.29127797495757,0.857587810639706,42,0.8913412563667233,4712
pers_age_35_64,3093525.0,3103519,9994.0,0.3230618792477837,95.0097623089983,137.7014159914274,26.790908930102287,0.8969626862823591,27,0.5730050933786078,4712
pers_age_65_plus,1251236.0,1256704,5468.0,0.43700788660172823,37.89006791171477,54.76523828377302,21.95195343807052,0.9112253247339446,71,1.5067911714770799,4712
hh_kids_yes,910632.0,883270,-27362.0,-3.0047263878273553,33.988964346349746,87.54266968330435,20.868586446093715,0.7306872163728603,110,2.3344651952461803,4712
hh_kids_no,2110053.0,2024310,-85743.0,-4.063547218956112,86.53459252971138,255.79590951767824,22.427169056592298,0.5321024069721343,29,0.6154499151103565,4712
inc_lt_20k,233290.0,222640,-10650.0,-4.565133524797462,10.149830220713072,32.19959110350002,18.262662727901752,0.7716701380447738,1088,23.089983022071305,4712
inc_20k_45k,285989.0,276248,-9741.0,-3.406075058830934,11.389006791171477,31.004507723089294,19.271046540234416,0.7706540510556614,691,14.664685908319186,4712
inc_45k_60k,176786.0,171369,-5417.0,-3.06415666398923,7.11141765704584,21.70946156775818,17.940671585289724,0.7786680114020593,1180,25.042444821731745,4712
inc_60k_75k,177473.0,171966,-5507.0,-3.103007217999358,6.768039049235993,16.81200986561577,17.718587514277612,0.850246033281567,1174,24.915110356536502,4712
inc_75k_100k,283923.0,276225,-7698.0,-2.711298485857081,10.627758913412563,24.844251691392582,18.866459338030968,0.82917245803467,590,12.521222410865873,4712
inc_100k_150k,486027.0,470572,-15455.0,-3.1798644931248674,18.612691001697794,45.521532153953956,19.339822537225775,0.7415340084679397,288,6.112054329371817,4712
inc_150k_200k,378626.0,363461,-15165.0,-4.005271692910682,15.215407470288625,43.531117512080876,19.907541777184214,0.6972125860357761,370,7.852292020373515,4712
inc_200k_plus,998563.0,949208,-49355.0,-4.942602519820983,41.35165534804754,147.17138511247796,20.688237656211008,0.6244391616221254,203,4.308149405772496,4712

taz_population_summary.csv (per-TAZ population summary)

Header + first rows (current):

id,total_pop_control,total_pop_result,total_pop_diff,total_pop_pct_error
1,1387.0,1075,-312.0,-22.49459264599856
2,2109.0,2241,132.0,6.258890469416785
3,2562.0,2527,-35.0,-1.366120218579235
4,1377.0,2130,753.0,54.68409586056645
5,1398.0,1387,-11.0,-0.7868383404864091
6,1064.0,473,-591.0,-55.545112781954884
7,907.0,1117,210.0,23.15325248070562
8,902.0,881,-21.0,-2.328159645232816
9,940.0,1028,88.0,9.361702127659575
10,1051.0,1126,75.0,7.1360608943863
11,1306.0,899,-407.0,-31.16385911179173
12,849.0,818,-31.0,-3.651354534746761
13,1882.0,2029,147.0,7.810839532412326
14,1404.0,1664,260.0,18.51851851851852
15,987.0,1142,155.0,15.704154002026344
16,1850.0,1969,119.0,6.432432432432432
17,2241.0,2406,165.0,7.362784471218206
18,1790.0,2223,433.0,24.18994413407821
19,1718.0,1622,-96.0,-5.587892898719441
20,1437.0,1280,-157.0,-10.925539318023661
21,1061.0,1348,287.0,27.04995287464656
22,758.0,636,-122.0,-16.094986807387862
23,773.0,904,131.0,16.946959896507117
24,995.0,1044,49.0,4.924623115577889
25,1119.0,1444,325.0,29.0437890974084
26,532.0,669,137.0,25.75187969924812
27,4388.0,5035,647.0,14.744758432087512
28,1664.0,1239,-425.0,-25.540865384615387
29,929.0,885,-44.0,-4.736275565123789
30,417.0,641,224.0,53.71702637889688
31,922.0,1678,756.0,81.99566160520607
32,844.0,866,22.0,2.6066350710900474
33,1201.0,1434,233.0,19.40049958368027
34,1385.0,1351,-34.0,-2.454873646209386
35,2431.0,2466,35.0,1.439736733854381
36,2258.0,2336,78.0,3.454384410983171
37,1528.0,1805,277.0,18.1282722513089
38,3147.0,3483,336.0,10.676835081029552
39,1178.0,1038,-140.0,-11.884550084889643
40,1512.0,1833,321.0,21.23015873015873
41,962.0,1274,312.0,32.432432432432435
42,2262.0,2140,-122.0,-5.393457117595048
43,1120.0,1373,253.0,22.589285714285715
44,955.0,2117,1162.0,121.67539267015708
45,1252.0,1270,18.0,1.4376996805111821
46,811.0,1101,290.0,35.75832305795315
47,1144.0,1099,-45.0,-3.9335664335664338
48,867.0,751,-116.0,-13.379469434832755
49,784.0,1154,370.0,47.19387755102041
50,1181.0,1233,52.0,4.403048264182896
51,1222.0,877,-345.0,-28.23240589198036
52,844.0,909,65.0,7.701421800947868
53,970.0,935,-35.0,-3.608247422680412
54,1237.0,1202,-35.0,-2.8294260307194827
55,1211.0,1146,-65.0,-5.367464905037159
56,1736.0,1888,152.0,8.755760368663594
57,861.0,790,-71.0,-8.246225319396052
58,1428.0,1333,-95.0,-6.652661064425771
59,1232.0,1269,37.0,3.0032467532467533