\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
indexassessment_break
0count\$136
1mean\$-1,389,385
2std\$1,668,667
3min\$-15,048,700
425%\$-1,797,666
550%\$-924,590
675%\$-419,249
7max\$-8,246
\n", "
" ], "text/plain": [ " index assessment_break\n", "0 count \$136\n", "1 mean \$-1,389,385\n", "2 std \$1,668,667\n", "3 min \$-15,048,700\n", "4 25% \$-1,797,666\n", "5 50% \$-924,590\n", "6 75% \$-419,249\n", "7 max \$-8,246" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "williamson_df.assessment_break.describe().reset_index()" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
apnprimary_ownerwilliamson_assessmentprop13_assessmentassessment_break
10783680025HOLLISTER RANCH TRUST 1/5/16\$6,799,698\$21,848,398\$-15,048,700
8583680005HOLLISTER RANCH 54 GP CA\$1,823,680\$8,147,960\$-6,324,280
10683680024DASH HOLDINGS III, LLC\$4,401,121\$10,092,512\$-5,691,391
383700002HAYDEN PROPERTIES, LLC\$2,315,560\$6,746,081\$-4,430,521
10483680022HOWARD RANCH LLC\$2,409,530\$6,788,460\$-4,378,930
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
indextax_break_estimate
0count\$136
1mean\$-15,196
2std\$18,302
3min\$-165,064
425%\$-19,551
550%\$-10,162
675%\$-4,610
7max\$-83
\n", "
" ], "text/plain": [ " index tax_break_estimate\n", "0 count \$136\n", "1 mean \$-15,196\n", "2 std \$18,302\n", "3 min \$-165,064\n", "4 25% \$-19,551\n", "5 50% \$-10,162\n", "6 75% \$-4,610\n", "7 max \$-83" ] }, "execution_count": 30, "metadata": {}, "output_type": "execute_result" } ], "source": [ "williamson_df['tax_break_estimate'].describe().reset_index()" ] }, { "cell_type": "code", "execution_count": 31, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
apnprimary_ownerwilliamson_taxprop13_tax_estimatetax_break_estimate
10783680025HOLLISTER RANCH TRUST 1/5/16\$75,269\$240,332\$-165,064
8583680005HOLLISTER RANCH 54 GP CA\$20,187\$89,628\$-69,441
10683680024DASH HOLDINGS III, LLC\$48,718\$111,018\$-62,300
383700002HAYDEN PROPERTIES, LLC\$25,632\$74,207\$-48,575
10483680022HOWARD RANCH LLC\$26,672\$74,673\$-48,001
\n", "
" ], "text/plain": [ " apn primary_owner williamson_tax \\\n", "107 83680025 HOLLISTER RANCH TRUST 1/5/16 \$75,269 \n", "85 83680005 HOLLISTER RANCH 54 GP CA \$20,187 \n", "106 83680024 DASH HOLDINGS III, LLC \$48,718 \n", "3 83700002 HAYDEN PROPERTIES, LLC \$25,632 \n", "104 83680022 HOWARD RANCH LLC \$26,672 \n", "\n", " prop13_tax_estimate tax_break_estimate \n", "107 \$240,332 \$-165,064 \n", "85 \$89,628 \$-69,441 \n", "106 \$111,018 \$-62,300 \n", "3 \$74,207 \$-48,575 \n", "104 \$74,673 \$-48,001 " ] }, "execution_count": 31, "metadata": {}, "output_type": "execute_result" } ], "source": [ "williamson_df.sort_values(\"tax_break_estimate\").head()[[\n", " 'apn',\n", " 'primary_owner',\n", " 'williamson_tax',\n", " 'prop13_tax_estimate',\n", " 'tax_break_estimate'\n", "]]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Output the results" ] }, { "cell_type": "code", "execution_count": 32, "metadata": {}, "outputs": [], "source": [ "williamson_df.to_csv(f\"{settings.output_dir}/analyzed.csv\", index=False, encoding=\"utf-8\")" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.6.5" } }, "nbformat": 4, "nbformat_minor": 2 }