{ "cells": [ { "cell_type": "markdown", "id": "54c34b47-2a1e-4036-8d7c-83f49f250644", "metadata": {}, "source": [ "Project Assignment 3" ] }, { "cell_type": "markdown", "id": "0b6aefff-3897-4ec0-b740-aaa38d8e85b3", "metadata": {}, "source": [ "MAPPING THE ESTIMATED POVERTY RATE OF THE UNITED STATES, 2023" ] }, { "cell_type": "markdown", "id": "9827de89-eee3-41c8-9d99-31b3bb68fcb6", "metadata": {}, "source": [ "# Description:\n", "The 'Mapping the Estimated Poverty Rate of the United States, 2023' project aimed to analyze and visualize the poverty rate across states in the United States in 2023. Utilizing CyberGISX Notebook, this project calculated the 2023 U.S. poverty rate, comparing it to 2022's official poverty rate to discern trends. Additionally, this project identified states exceeding the average poverty rate and pinpointed the top five states with the highest poverty rates. \n" ] }, { "cell_type": "markdown", "id": "ad7f3ea6-8310-4fdc-b0c4-faaaaede59c9", "metadata": {}, "source": [ "# Background:\n", "Poverty serves as a crucial socioeconomic metric, and comprehending how it is dispersed across the nation's landscapes can offer valuable insights into the economic well-being of communities and potential areas for targeted interventions. The U.S. Census Bureau announced the official poverty rate in 2022 was 11.5%, with 37.9 million people in poverty. " ] }, { "cell_type": "markdown", "id": "f3f85554-8221-4349-9408-31411382ab49", "metadata": {}, "source": [ "# Read the data" ] }, { "cell_type": "code", "execution_count": 1, "id": "e52256df-f148-45f6-b0f9-6c8bdab74de1", "metadata": {}, "outputs": [], "source": [ "%matplotlib inline\n", "import os\n", "from geopandas import GeoSeries, GeoDataFrame, read_file, gpd\n", "from pandas import Series\n", "from matplotlib import pyplot as plt\n", "import IPython\n", "import geopandas as gpd\n", "import matplotlib.pyplot as plt" ] }, { "cell_type": "code", "execution_count": 2, "id": "dcfb109b-d996-4353-b430-b3251d20acf3", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | ID | \n", "NAME | \n", "ST_ABBREV | \n", "STATE_NAME | \n", "TOTPOP_CY | \n", "HHPOP_CY | \n", "GQPOP_CY | \n", "POPDENS_CY | \n", "TOTHH_CY | \n", "AVGHHSZ_CY | \n", "... | \n", "PERC_WORKA | \n", "PERC_NOHSD | \n", "PERC_HSGRA | \n", "PERC_COLLE | \n", "PERC_OWNER | \n", "PERC_RENTE | \n", "PERC_VACAN | \n", "Shape__Are | \n", "Shape__Len | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "01 | \n", "Alabama | \n", "AL | \n", "Alabama | \n", "5098606 | \n", "4970917 | \n", "127689 | \n", "100.7 | \n", "2052801 | \n", "2.42 | \n", "... | \n", "60.252665 | \n", "11.124213 | \n", "32.469333 | \n", "37.567986 | \n", "61.135901 | \n", "26.511792 | \n", "12.352307 | \n", "1.898838e+11 | \n", "3.381161e+06 | \n", "MULTIPOLYGON (((-9804827.172 3535998.323, -980... | \n", "
1 | \n", "02 | \n", "Alaska | \n", "AK | \n", "Alaska | \n", "732320 | \n", "702029 | \n", "30291 | \n", "1.3 | \n", "272068 | \n", "2.58 | \n", "... | \n", "62.370139 | \n", "6.227315 | \n", "28.664002 | \n", "42.956445 | \n", "53.502922 | \n", "28.488984 | \n", "18.008095 | \n", "8.202573e+12 | \n", "8.103864e+07 | \n", "MULTIPOLYGON (((-19938359.968 6674706.391, -19... | \n", "
2 | \n", "04 | \n", "Arizona | \n", "AZ | \n", "Arizona | \n", "7427991 | \n", "7268090 | \n", "159901 | \n", "65.4 | \n", "2832889 | \n", "2.57 | \n", "... | \n", "58.614907 | \n", "9.868275 | \n", "24.253297 | \n", "43.880887 | \n", "58.995037 | \n", "29.658466 | \n", "11.346497 | \n", "4.340564e+11 | \n", "2.907243e+06 | \n", "POLYGON ((-12314791.031 4439600.741, -12309722... | \n", "
3 rows × 163 columns
\n", "\n", " | STATENS | \n", "GEOID | \n", "STUSPS | \n", "NAME | \n", "ALAND | \n", "AWATER | \n", "B17020_001 | \n", "B17020_002 | \n", "B17020_003 | \n", "B17020_004 | \n", "... | \n", "C17002_c_5 | \n", "C17002_c_6 | \n", "C17002_c_7 | \n", "C17002_c_8 | \n", "C17002_c_9 | \n", "C17002__16 | \n", "C17002__17 | \n", "C17002__18 | \n", "C17002__19 | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "01779775 | \n", "01 | \n", "AL | \n", "Alabama | \n", "1.311755e+11 | \n", "4.591898e+09 | \n", "4876863 | \n", "1677.0 | \n", "769819 | \n", "12595.0 | \n", "... | \n", "0.145042 | \n", "4.8 | \n", "0.155419 | \n", "6.8 | \n", "0.182787 | \n", "2.7 | \n", "0.104325 | \n", "64.9 | \n", "0.352986 | \n", "MULTIPOLYGON (((-9805779.623 3536997.578, -980... | \n", "
1 | \n", "01785533 | \n", "02 | \n", "AK | \n", "Alaska | \n", "1.478943e+12 | \n", "2.453784e+11 | \n", "719086 | \n", "595.0 | \n", "75016 | \n", "2458.0 | \n", "... | \n", "0.238761 | \n", "3.9 | \n", "0.328179 | \n", "5.3 | \n", "0.370305 | \n", "2.1 | \n", "0.182863 | \n", "75.1 | \n", "0.576424 | \n", "MULTIPOLYGON (((-19938361.670 6674706.152, -19... | \n", "
2 | \n", "01779777 | \n", "04 | \n", "AZ | \n", "Arizona | \n", "2.943640e+11 | \n", "8.558716e+08 | \n", "6926281 | \n", "1660.0 | \n", "934911 | \n", "13056.0 | \n", "... | \n", "0.147132 | \n", "4.5 | \n", "0.138671 | \n", "6.5 | \n", "0.152310 | \n", "2.9 | \n", "0.094738 | \n", "68.3 | \n", "0.277719 | \n", "POLYGON ((-12138854.213 4438965.000, -12138854... | \n", "
3 rows × 79 columns
\n", "\n", " | ID | \n", "States | \n", "ST_ABBREV | \n", "STATE_NAME | \n", "Total_pop | \n", "HHPOP_CY | \n", "GQPOP_CY | \n", "POPDENS_CY | \n", "TOTHH_CY | \n", "AVGHHSZ_CY | \n", "... | \n", "PERC_WORKA | \n", "PERC_NOHSD | \n", "PERC_HSGRA | \n", "PERC_COLLE | \n", "PERC_OWNER | \n", "PERC_RENTE | \n", "PERC_VACAN | \n", "Shape__Are | \n", "Shape__Len | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "01 | \n", "Alabama | \n", "AL | \n", "Alabama | \n", "5098606 | \n", "4970917 | \n", "127689 | \n", "100.7 | \n", "2052801 | \n", "2.42 | \n", "... | \n", "60.252665 | \n", "11.124213 | \n", "32.469333 | \n", "37.567986 | \n", "61.135901 | \n", "26.511792 | \n", "12.352307 | \n", "1.898838e+11 | \n", "3.381161e+06 | \n", "MULTIPOLYGON (((-9804827.172 3535998.323, -980... | \n", "
1 | \n", "02 | \n", "Alaska | \n", "AK | \n", "Alaska | \n", "732320 | \n", "702029 | \n", "30291 | \n", "1.3 | \n", "272068 | \n", "2.58 | \n", "... | \n", "62.370139 | \n", "6.227315 | \n", "28.664002 | \n", "42.956445 | \n", "53.502922 | \n", "28.488984 | \n", "18.008095 | \n", "8.202573e+12 | \n", "8.103864e+07 | \n", "MULTIPOLYGON (((-19938359.968 6674706.391, -19... | \n", "
2 | \n", "04 | \n", "Arizona | \n", "AZ | \n", "Arizona | \n", "7427991 | \n", "7268090 | \n", "159901 | \n", "65.4 | \n", "2832889 | \n", "2.57 | \n", "... | \n", "58.614907 | \n", "9.868275 | \n", "24.253297 | \n", "43.880887 | \n", "58.995037 | \n", "29.658466 | \n", "11.346497 | \n", "4.340564e+11 | \n", "2.907243e+06 | \n", "POLYGON ((-12314791.031 4439600.741, -12309722... | \n", "
3 rows × 163 columns
\n", "\n", " | STATENS | \n", "GEOID | \n", "STUSPS | \n", "States | \n", "ALAND | \n", "AWATER | \n", "B17020_001 | \n", "B17020_002 | \n", "Poverty_pop | \n", "B17020_004 | \n", "... | \n", "C17002_c_5 | \n", "C17002_c_6 | \n", "C17002_c_7 | \n", "C17002_c_8 | \n", "C17002_c_9 | \n", "C17002__16 | \n", "C17002__17 | \n", "C17002__18 | \n", "C17002__19 | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "01779775 | \n", "01 | \n", "AL | \n", "Alabama | \n", "1.311755e+11 | \n", "4.591898e+09 | \n", "4876863 | \n", "1677.0 | \n", "769819 | \n", "12595.0 | \n", "... | \n", "0.145042 | \n", "4.8 | \n", "0.155419 | \n", "6.8 | \n", "0.182787 | \n", "2.7 | \n", "0.104325 | \n", "64.9 | \n", "0.352986 | \n", "MULTIPOLYGON (((-9805779.623 3536997.578, -980... | \n", "
1 | \n", "01785533 | \n", "02 | \n", "AK | \n", "Alaska | \n", "1.478943e+12 | \n", "2.453784e+11 | \n", "719086 | \n", "595.0 | \n", "75016 | \n", "2458.0 | \n", "... | \n", "0.238761 | \n", "3.9 | \n", "0.328179 | \n", "5.3 | \n", "0.370305 | \n", "2.1 | \n", "0.182863 | \n", "75.1 | \n", "0.576424 | \n", "MULTIPOLYGON (((-19938361.670 6674706.152, -19... | \n", "
2 | \n", "01779777 | \n", "04 | \n", "AZ | \n", "Arizona | \n", "2.943640e+11 | \n", "8.558716e+08 | \n", "6926281 | \n", "1660.0 | \n", "934911 | \n", "13056.0 | \n", "... | \n", "0.147132 | \n", "4.5 | \n", "0.138671 | \n", "6.5 | \n", "0.152310 | \n", "2.9 | \n", "0.094738 | \n", "68.3 | \n", "0.277719 | \n", "POLYGON ((-12138854.213 4438965.000, -12138854... | \n", "
3 rows × 79 columns
\n", "\n", " | STATENS | \n", "GEOID | \n", "STUSPS | \n", "States | \n", "ALAND | \n", "AWATER | \n", "B17020_001 | \n", "B17020_002 | \n", "Poverty_pop | \n", "B17020_004 | \n", "... | \n", "PERC_WORKA | \n", "PERC_NOHSD | \n", "PERC_HSGRA | \n", "PERC_COLLE | \n", "PERC_OWNER | \n", "PERC_RENTE | \n", "PERC_VACAN | \n", "Shape__Are_y | \n", "Shape__Len_y | \n", "geometry_y | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "01779775 | \n", "01 | \n", "AL | \n", "Alabama | \n", "1.311755e+11 | \n", "4.591898e+09 | \n", "4876863 | \n", "1677.0 | \n", "769819 | \n", "12595.0 | \n", "... | \n", "60.252665 | \n", "11.124213 | \n", "32.469333 | \n", "37.567986 | \n", "61.135901 | \n", "26.511792 | \n", "12.352307 | \n", "1.898838e+11 | \n", "3.381161e+06 | \n", "MULTIPOLYGON (((-9804827.172 3535998.323, -980... | \n", "
1 | \n", "01785533 | \n", "02 | \n", "AK | \n", "Alaska | \n", "1.478943e+12 | \n", "2.453784e+11 | \n", "719086 | \n", "595.0 | \n", "75016 | \n", "2458.0 | \n", "... | \n", "62.370139 | \n", "6.227315 | \n", "28.664002 | \n", "42.956445 | \n", "53.502922 | \n", "28.488984 | \n", "18.008095 | \n", "8.202573e+12 | \n", "8.103864e+07 | \n", "MULTIPOLYGON (((-19938359.968 6674706.391, -19... | \n", "
2 | \n", "01779777 | \n", "04 | \n", "AZ | \n", "Arizona | \n", "2.943640e+11 | \n", "8.558716e+08 | \n", "6926281 | \n", "1660.0 | \n", "934911 | \n", "13056.0 | \n", "... | \n", "58.614907 | \n", "9.868275 | \n", "24.253297 | \n", "43.880887 | \n", "58.995037 | \n", "29.658466 | \n", "11.346497 | \n", "4.340564e+11 | \n", "2.907243e+06 | \n", "POLYGON ((-12314791.031 4439600.741, -12309722... | \n", "
3 | \n", "00068085 | \n", "05 | \n", "AR | \n", "Arkansas | \n", "1.346608e+11 | \n", "3.121950e+09 | \n", "2923735 | \n", "1020.0 | \n", "468113 | \n", "8062.0 | \n", "... | \n", "59.279771 | \n", "10.207925 | \n", "35.205226 | \n", "34.904755 | \n", "57.623065 | \n", "29.776736 | \n", "12.600199 | \n", "2.054028e+11 | \n", "2.683084e+06 | \n", "POLYGON ((-10503535.097 4369606.658, -10503414... | \n", "
4 | \n", "01779778 | \n", "06 | \n", "CA | \n", "California | \n", "4.036718e+11 | \n", "2.029357e+10 | \n", "38701352 | \n", "3861.0 | \n", "4741175 | \n", "41071.0 | \n", "... | \n", "61.878353 | \n", "14.095767 | \n", "21.614179 | \n", "46.340204 | \n", "52.005259 | \n", "41.329172 | \n", "6.665569 | \n", "6.491796e+11 | \n", "8.059338e+06 | \n", "MULTIPOLYGON (((-13048031.362 3865261.112, -13... | \n", "
5 rows × 241 columns
\n", "\n", " | STATENS | \n", "GEOID | \n", "STUSPS | \n", "States | \n", "ALAND | \n", "AWATER | \n", "B17020_001 | \n", "B17020_002 | \n", "Poverty_pop | \n", "B17020_004 | \n", "... | \n", "PERC_NOHSD | \n", "PERC_HSGRA | \n", "PERC_COLLE | \n", "PERC_OWNER | \n", "PERC_RENTE | \n", "PERC_VACAN | \n", "Shape__Are_y | \n", "Shape__Len_y | \n", "geometry_y | \n", "Poverty_rate | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "01779775 | \n", "01 | \n", "AL | \n", "Alabama | \n", "1.311755e+11 | \n", "4.591898e+09 | \n", "4876863 | \n", "1677.0 | \n", "769819 | \n", "12595.0 | \n", "... | \n", "11.124213 | \n", "32.469333 | \n", "37.567986 | \n", "61.135901 | \n", "26.511792 | \n", "12.352307 | \n", "1.898838e+11 | \n", "3.381161e+06 | \n", "MULTIPOLYGON (((-9804827.172 3535998.323, -980... | \n", "15.10 | \n", "
1 | \n", "01785533 | \n", "02 | \n", "AK | \n", "Alaska | \n", "1.478943e+12 | \n", "2.453784e+11 | \n", "719086 | \n", "595.0 | \n", "75016 | \n", "2458.0 | \n", "... | \n", "6.227315 | \n", "28.664002 | \n", "42.956445 | \n", "53.502922 | \n", "28.488984 | \n", "18.008095 | \n", "8.202573e+12 | \n", "8.103864e+07 | \n", "MULTIPOLYGON (((-19938359.968 6674706.391, -19... | \n", "10.24 | \n", "
2 | \n", "01779777 | \n", "04 | \n", "AZ | \n", "Arizona | \n", "2.943640e+11 | \n", "8.558716e+08 | \n", "6926281 | \n", "1660.0 | \n", "934911 | \n", "13056.0 | \n", "... | \n", "9.868275 | \n", "24.253297 | \n", "43.880887 | \n", "58.995037 | \n", "29.658466 | \n", "11.346497 | \n", "4.340564e+11 | \n", "2.907243e+06 | \n", "POLYGON ((-12314791.031 4439600.741, -12309722... | \n", "12.59 | \n", "
3 | \n", "00068085 | \n", "05 | \n", "AR | \n", "Arkansas | \n", "1.346608e+11 | \n", "3.121950e+09 | \n", "2923735 | \n", "1020.0 | \n", "468113 | \n", "8062.0 | \n", "... | \n", "10.207925 | \n", "35.205226 | \n", "34.904755 | \n", "57.623065 | \n", "29.776736 | \n", "12.600199 | \n", "2.054028e+11 | \n", "2.683084e+06 | \n", "POLYGON ((-10503535.097 4369606.658, -10503414... | \n", "15.32 | \n", "
4 | \n", "01779778 | \n", "06 | \n", "CA | \n", "California | \n", "4.036718e+11 | \n", "2.029357e+10 | \n", "38701352 | \n", "3861.0 | \n", "4741175 | \n", "41071.0 | \n", "... | \n", "14.095767 | \n", "21.614179 | \n", "46.340204 | \n", "52.005259 | \n", "41.329172 | \n", "6.665569 | \n", "6.491796e+11 | \n", "8.059338e+06 | \n", "MULTIPOLYGON (((-13048031.362 3865261.112, -13... | \n", "11.89 | \n", "
5 rows × 242 columns
\n", "