{ "cells": [ { "cell_type": "code", "execution_count": 2, "id": "e78442aa", "metadata": { "tags": [ "remove-cell" ] }, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import openpyxl \n", "from matplotlib import pyplot as plt\n", "from matplotlib.font_manager import FontProperties\n", "\n", "city_name = 'HTC'" ] }, { "cell_type": "markdown", "id": "299d3498", "metadata": {}, "source": [ "# HTC Characteristic Breakdown\n", "\n", "This section shows the “hard-to-count” (HTC) characteristics of select variables for every city in Orange County." ] }, { "cell_type": "markdown", "id": "8b539e01", "metadata": {}, "source": [ "```{margin} To calculate raw population numbers, multiple the percentage of the population by the total population.\n", "\n", "For example, to find the total population of children under 5 in Orange County, multiply the county population of 3,168,044 by 5.9% (or 0.059). There are 186,914 residents in Orange County who are children 5 and under.\n", "\n", "Remember, these numbers are based on 2015-2019 ACS data, not the 2020 Census results (see the Methodology section for more information on data sources).\n", "```" ] }, { "cell_type": "markdown", "id": "ddc46062", "metadata": {}, "source": [ "## Summary\n", "The Cities of Stanton, Westminster, Santa Ana, Laguna Niguel, Garden Grove, and Buena Park have the highest combined share of their populations demonstrating the below HTC characteristics.\n", "\n", "In raw population numbers, the Cities of Santa Ana, Anaheim, Irvine, and Garden Grove have the highest number of residents exhibiting these characteristics.\n", "\n", "The Cities of Santa Ana, Anaheim, and Irvine each have the highest populations of residents who are children under 5 (over 15,000 people), and the City of Huntington Beach has the next highest population with this characteristic (over 10,000 people).\n", "\n", "The Cities of Santa Ana, Anaheim, and Irvine each have the highest populations of residents who were born outside of the U.S. (over 100,000 people), and the City of Garden Grove has the next highest population with this characteristic (over 75,000 people).\n", "\n", "The Cities of Santa Ana and Anaheim each have the highest populations of residents with an income below 150% of the poverty level (over 80,000 people), and the Cities of Irvine and Garden Grove each have the next highest populations with this characteristic (over 40,000 people).\n", "\n", "The City of Santa Ana has the highest population of residents with limited English speaking ability (over 50,000 people), and the Cities of Irvine, Fullerton, Huntington Beach, and Westminster each have the next highest populations with this characteristic (over 20,000 people).\n", "\n", "Lastly, the City of Anaheim has the highest population of residents living in non-family households (over 95,000 people), and the Cities of Huntington Beach, Irvine, Santa Ana, and Garden Grove each have the next highest populations with this characteristic (over 60,000 people).\n" ] }, { "cell_type": "markdown", "id": "367d9797", "metadata": {}, "source": [ "## Table \n", "HTC demographic distribution for every city in Orange County:" ] }, { "cell_type": "markdown", "id": "3281b2f4", "metadata": {}, "source": [ "```{margin} Note:\n", "This table can be copied and pasted into a spreadsheet for further analysis.\n", "```" ] }, { "cell_type": "code", "execution_count": 3, "id": "1aae258a", "metadata": { "scrolled": true, "tags": [ "remove-input" ] }, "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", " \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", " \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", " \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", " \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", " \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", "
CityTotal PopulationChildren Under 5Born Outside of the U.S.Income Below 150% of Poverty LevelLimited-English Speaking AbilityNon-Famiy (e.g. housemates, unmarried partners)
ORANGE COUNTY3,168,0445.9%30.1%17.9%3.3%30.9%
Aliso Viejo50,6637.1%22.2%7.4%11.9%26.1%
Anaheim349,9646.5%36.5%24.2%4.3%27.5%
Brea42,6785.8%21.7%10.9%12.9%18.1%
Buena Park82,4896.1%37.3%19.7%5.7%40.5%
Costa Mesa113,1595.8%25.0%20.2%8.0%19.1%
Cypress48,8934.8%29.3%11.4%2.4%39.7%
Dana Point33,7694.0%14.3%11.3%10.8%23.0%
Fountain Valley56,0264.5%30.7%13.8%9.6%30.2%
Fullerton139,6116.4%30.0%20.1%19.3%21.8%
Garden Grove173,2585.2%44.3%24.0%3.0%34.9%
Huntington Beach200,2595.3%16.1%13.1%10.5%33.9%
Irvine273,1576.4%41.2%16.9%10.2%23.9%
La Habra60,5946.8%28.9%19.4%9.9%18.8%
La Palma15,6043.7%34.4%10.5%0.9%41.5%
Laguna Beach23,0363.4%13.2%8.5%5.4%30.0%
Laguna Hills31,6175.8%26.3%13.0%3.4%28.2%
Laguna Niguel65,8085.0%21.5%10.8%13.9%63.8%
Laguna Woods16,0530.0%34.7%20.1%5.1%26.5%
Lake Forest83,9746.6%24.8%11.5%3.5%29.6%
Los Alamitos11,5344.0%15.6%16.0%4.0%23.2%
Mission Viejo95,5164.9%20.0%8.3%1.5%42.3%
Newport Beach85,6943.9%14.6%10.0%5.8%26.8%
Orange139,8876.1%22.8%17.5%8.7%28.3%
Placentia51,8185.9%24.4%14.3%6.6%23.7%
Rancho Santa Margarita48,5036.6%16.5%7.1%1.8%24.1%
San Clemente64,8785.1%12.0%9.6%2.5%28.9%
San Juan Capistrano35,9226.0%21.4%15.9%6.4%28.8%
Santa Ana332,7947.4%43.3%30.1%17.7%18.3%
Seal Beach24,2043.4%15.6%9.3%5.3%51.6%
Stanton38,3777.3%44.0%31.2%18.2%27.0%
Tustin79,8637.1%32.0%16.4%7.6%29.6%
Villa Park5,8612.0%19.2%8.9%1.2%15.4%
Westminster91,1374.9%44.5%26.9%21.9%22.3%
Yorba Linda67,7255.1%19.9%7.7%4.0%17.3%
\n" ], "text/plain": [ "" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#call to retrieve excel file\n", "path = '../../_static/' + city_name + '/' + city_name + '_Tables.xlsx'\n", "\n", "#define data frame\n", "df = pd.ExcelFile(path)\n", "\n", "Summary2020 = df.parse('Percent of Population')\n", "Summary2020.style.hide_index()" ] } ], "metadata": { "celltoolbar": "Tags", "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.9.6" } }, "nbformat": 4, "nbformat_minor": 5 }