{"id":1943312,"date":"2023-05-26T08:28:28","date_gmt":"2023-05-26T15:28:28","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1943312"},"modified":"2023-07-26T14:16:15","modified_gmt":"2023-07-26T21:16:15","slug":"creating-an-economic-distress-index-using-python","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python","title":{"rendered":"Creating an economic distress index layer using Census data with Python"},"author":317312,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341],"tags":[36021,387782,31361,769372,771242],"industry":[],"product":[36841],"class_list":["post-1943312","blog","type-blog","status-publish","format-standard","hentry","category-analytics","tag-american-community-survey","tag-arcgis-api-for-python","tag-census","tag-composite-index","tag-economic-distress","product-api-python"],"acf":{"authors":[{"ID":317312,"user_firstname":"Elif","user_lastname":"Bulut","nickname":"Elif Bulut","user_nicename":"ebulut","display_name":"Elif Bulut","user_email":"ebulut@esri.com","user_url":"","user_registered":"2022-08-24 18:23:17","user_description":"Elif is a Product Engineer of Social Analysis and Data Science on the ArcGIS Business Analyst team. She holds a PhD in Sociology and applies spatial data science and social research to help users explore demographic trends, community characteristics, and access to resources. She is passionate about turning complex data into clear insights that support real-world decision-making.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/10\/Elif-Bulut_Nov-24_2021_profie-pic.jpeg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"},{"ID":14081,"user_firstname":"Joel","user_lastname":"McCune","nickname":"Joel McCune","user_nicename":"jmccune","display_name":"Joel McCune","user_email":"jmccune@esri.com","user_url":"https:\/\/joelmccune.com","user_registered":"2020-03-03 13:30:02","user_description":"One way or another, I have always been a geographer. While I do remember learning how to read, I do not recall learning how to interpret a topo map. I would look at different maps for hours, visualizing what the place looked like, and dreaming of going there. Over 30 years later, I still am fascinated by the power of information and geography.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/279A062A-730E-4A1D-818F-10D4BEC51D29_1_201_a-465x465.jpeg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"}],"short_description":"Creating an economic distress index layer from Census data using Python.","flexible_content":[{"acf_fc_layout":"content","content":"<p>Indexes are commonly used across government programs, epidemiology, and socioeconomic research to measure and compare complex phenomena such as economic distress, social inequality, or quality of life.<\/p>\n<p>How does an index work? Indexes condense multiple variables into a single indicator. This simplification allows researchers to compare and analyze data systematically and help policymakers communicate complex information in a more accessible manner.<\/p>\n<p>Suppose a policymaker or an analyst wants to identify the underlying causes contributing to economic distress in specific communities and target interventions in these communities. There is a wide array of economic factors to consider\u2014but how to present all that data in a single map? They can achieve this by developing an index that integrates multiple economic factors and use this index as a diagnostic tool to identify the areas with the greatest economic disadvantage. By quantifying and ranking the level of distress across different areas, policymakers can prioritize interventions and target support where it is most needed.<\/p>\n<p>For example, using an economic distress index, the<a href=\"https:\/\/arcg.is\/8SvPD\"> map<\/a> presented below highlights the US census tracts that fall within the top 10 percentile, which exhibit higher levels of economic distress in comparison to the remaining 90 percent.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943332,"id":1943332,"title":"Economic Distress Index Map","filename":"percetile-map.jpg","filesize":98763,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/percetile-map.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/percetile-map","alt":"using an economic distress index, the map shows a subset of US tracts, roughly 10 percent, which exhibit higher levels of economic distress in comparison to the remaining 90 percent.","author":"317312","description":"","caption":"","name":"percetile-map","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 14:31:40","modified":"2023-05-26 14:32:30","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":832,"height":453,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/percetile-map-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/percetile-map.jpg","medium-width":464,"medium-height":253,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/percetile-map.jpg","medium_large-width":768,"medium_large-height":418,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/percetile-map.jpg","large-width":832,"large-height":453,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/percetile-map.jpg","1536x1536-width":832,"1536x1536-height":453,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/percetile-map.jpg","2048x2048-width":832,"2048x2048-height":453,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/percetile-map-826x450.jpg","card_image-width":826,"card_image-height":450,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/percetile-map.jpg","wide_image-width":832,"wide_image-height":453}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>In this blog article, we will guide you through creating an economic distress index at the county level using data from the U.S. Census Bureau\u2019s most recent American Community Survey (ACS) 5-Year Estimates (2017-2021). Based on the commonly used economic risk factors, the six components of our index include:<\/p>\n<ul>\n<li>Percent population with less than a high school degree for population 25 years and over<\/li>\n<li>Percent population living below poverty in the past 12 months<\/li>\n<li>Percent unemployed for the population 16 years and over<\/li>\n<li>Percent households with cash public assistance or food stamps\/SNAP<\/li>\n<li>Percent households with Supplemental Security Income (SSI)<\/li>\n<li>Percent households with $30,000 or less income<\/li>\n<\/ul>\n<p>To create the index, we will follow a five-step process:<\/p>\n<ol>\n<li>Retrieve Census data<\/li>\n<li>Calculate composite index components<\/li>\n<li>Calculate the economic distress index<\/li>\n<li>Add geometry to the data and create a feature layer<\/li>\n<li>Share your feature layer to ArcGIS Online for mapping<\/li>\n<\/ol>\n<p><strong>Use Python to streamline this workflow<\/strong><\/p>\n<p>Although it is possible to manually complete the above steps in ArcGIS Pro, the Python programming language allows you to automate these tasks more efficiently and with greater ease. If you have never used the ArcGIS API for Python before, read the <a href=\"https:\/\/developers.arcgis.com\/python\/guide\/\">getting started guide <\/a>to see how you can leverage the Python API for GIS visualization and analysis, spatial data management, and GIS system administration.<\/p>\n<p><strong>1.Retrieve Census data<\/strong><\/p>\n<p>Our first step is retrieving the pertinent data from the U.S. Census Bureau. We use the <a href=\"https:\/\/github.com\/cenpy-devs\/cenpy\">cenpy<\/a> Python library to access the Census API and retrieve data.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943612,"id":1943612,"title":"","filename":"census-api-1.jpg","filesize":15664,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/census-api-1.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/census-api-2","alt":"","author":"317312","description":"","caption":"","name":"census-api-2","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 15:13:02","modified":"2023-05-26 15:13:09","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":819,"height":79,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/census-api-1-213x79.jpg","thumbnail-width":213,"thumbnail-height":79,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/census-api-1.jpg","medium-width":464,"medium-height":45,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/census-api-1.jpg","medium_large-width":768,"medium_large-height":74,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/census-api-1.jpg","large-width":819,"large-height":79,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/census-api-1.jpg","1536x1536-width":819,"1536x1536-height":79,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/census-api-1.jpg","2048x2048-width":819,"2048x2048-height":79,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/census-api-1.jpg","card_image-width":819,"card_image-height":79,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/census-api-1.jpg","wide_image-width":819,"wide_image-height":79}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The <a href=\"https:\/\/cenpy-devs.github.io\/cenpy\/generated\/cenpy.remote.APIConnection.html#cenpy.remote.APIConnection\">APIConnection<\/a> object is the way we interrogate and retrieve data from the U.S. Census Bureau.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943622,"id":1943622,"title":"","filename":"object.jpg","filesize":32106,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/object.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/object","alt":"","author":"317312","description":"","caption":"","name":"object","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 15:13:30","modified":"2023-05-26 15:13:37","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1018,"height":170,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/object-213x170.jpg","thumbnail-width":213,"thumbnail-height":170,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/object.jpg","medium-width":464,"medium-height":77,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/object.jpg","medium_large-width":768,"medium_large-height":128,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/object.jpg","large-width":1018,"large-height":170,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/object.jpg","1536x1536-width":1018,"1536x1536-height":170,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/object.jpg","2048x2048-width":1018,"2048x2048-height":170,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/object-826x138.jpg","card_image-width":826,"card_image-height":138,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/object.jpg","wide_image-width":1018,"wide_image-height":170}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Once we have access to the Census API, we are ready to get started with retrieving all the required data to use later for calculating our composite index.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943662,"id":1943662,"title":"","filename":"req.jpg","filesize":182050,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/req.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/req","alt":"","author":"317312","description":"","caption":"","name":"req","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 15:19:09","modified":"2023-05-26 15:19:17","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":843,"height":748,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/req-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/req.jpg","medium-width":294,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/req.jpg","medium_large-width":768,"medium_large-height":681,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/req.jpg","large-width":843,"large-height":748,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/req.jpg","1536x1536-width":843,"1536x1536-height":748,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/req.jpg","2048x2048-width":843,"2048x2048-height":748,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/req-524x465.jpg","card_image-width":524,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/req.jpg","wide_image-width":843,"wide_image-height":748}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>One of the nice things about the cenpy package is the ability to retrieve <em>intelligible<\/em> descriptions of the coded variables available. Here, we can retrieve the descriptions associated with the variables we are retrieving for reference.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943382,"id":1943382,"title":"Variable Labels","filename":"labels.jpg","filesize":497130,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/labels.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/labels-12","alt":"","author":"317312","description":"","caption":"","name":"labels-12","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 14:43:09","modified":"2023-05-26 14:43:25","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":900,"height":697,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/labels-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/labels.jpg","medium-width":337,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/labels.jpg","medium_large-width":768,"medium_large-height":595,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/labels.jpg","large-width":900,"large-height":697,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/labels.jpg","1536x1536-width":900,"1536x1536-height":697,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/labels.jpg","2048x2048-width":900,"2048x2048-height":697,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/labels-600x465.jpg","card_image-width":600,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/labels.jpg","wide_image-width":900,"wide_image-height":697}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p style=\"text-align: left\"><strong>2. Calculate composite index components<\/strong><\/p>\n<p>To calculate composite index components, we will first create a data frame that incorporates all the retrieved data at the county level.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943402,"id":1943402,"title":"Create Dataframe","filename":"make-request.jpg","filesize":48714,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/make-request.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/make-request","alt":"","author":"317312","description":"","caption":"","name":"make-request","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 14:50:17","modified":"2023-05-26 14:50:49","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":553,"height":323,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/make-request-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/make-request.jpg","medium-width":447,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/make-request.jpg","medium_large-width":553,"medium_large-height":323,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/make-request.jpg","large-width":553,"large-height":323,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/make-request.jpg","1536x1536-width":553,"1536x1536-height":323,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/make-request.jpg","2048x2048-width":553,"2048x2048-height":323,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/make-request.jpg","card_image-width":553,"card_image-height":323,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/make-request.jpg","wide_image-width":553,"wide_image-height":323}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Here are the first five rows of the resulting data frame:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943412,"id":1943412,"title":"","filename":"rows.jpg","filesize":121129,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/rows.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/rows","alt":"","author":"317312","description":"","caption":"","name":"rows","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 14:51:28","modified":"2023-05-26 14:51:36","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1298,"height":376,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/rows-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/rows.jpg","medium-width":464,"medium-height":134,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/rows.jpg","medium_large-width":768,"medium_large-height":222,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/rows.jpg","large-width":1298,"large-height":376,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/rows.jpg","1536x1536-width":1298,"1536x1536-height":376,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/rows.jpg","2048x2048-width":1298,"2048x2048-height":376,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/rows-826x239.jpg","card_image-width":826,"card_image-height":239,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/rows.jpg","wide_image-width":1298,"wide_image-height":376}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Now, we are ready to generate new variables for each index component that we want to incorporate into our economic distress index. Below, we present the calculation of the percent unemployed variable using the retrieved data. For information on the calculation of each index component, please refer to the accompanying <a href=\"https:\/\/knu2xs.github.io\/arcgis-economic-distress-index\/index.htm\">Python notebook.<\/a><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943432,"id":1943432,"title":"","filename":"unemployed.jpg","filesize":91301,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/unemployed.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/unemployed","alt":"","author":"317312","description":"","caption":"","name":"unemployed","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 14:53:37","modified":"2023-05-26 14:53:45","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1146,"height":354,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/unemployed-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/unemployed.jpg","medium-width":464,"medium-height":143,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/unemployed.jpg","medium_large-width":768,"medium_large-height":237,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/unemployed.jpg","large-width":1146,"large-height":354,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/unemployed.jpg","1536x1536-width":1146,"1536x1536-height":354,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/unemployed.jpg","2048x2048-width":1146,"2048x2048-height":354,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/unemployed-826x255.jpg","card_image-width":826,"card_image-height":255,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/unemployed.jpg","wide_image-width":1146,"wide_image-height":354}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><strong>\u00a03. <\/strong><strong>Calculate the economic distress index <\/strong><\/p>\n<p>With the percentage columns added, now we can prepare the data and calculate our composite index.<\/p>\n<p>First, we will ensure that the factors are equally scaled. In the percentage columns calculated earlier, the respective ranges vary. To calculate our composite index, we are going to need to rescale these columns. In this case, we are keeping it simple by using the <a href=\"https:\/\/scikit-learn.org\/stable\/modules\/generated\/sklearn.preprocessing.MinMaxScaler.html#sklearn.preprocessing.MinMaxScaler\">MinMaxScaler from SciKit-Learn<\/a>. Depending on the characteristics of the data you are using, there are a <a href=\"https:\/\/scikit-learn.org\/stable\/modules\/preprocessing.html#scaling-features-to-a-range\">large variety of other ways to scale data<\/a>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943442,"id":1943442,"title":"","filename":"minmaxscaler.jpg","filesize":166028,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/minmaxscaler.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/minmaxscaler","alt":"","author":"317312","description":"","caption":"","name":"minmaxscaler","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 14:55:53","modified":"2023-05-26 14:56:00","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":925,"height":521,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/minmaxscaler-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/minmaxscaler.jpg","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/minmaxscaler.jpg","medium_large-width":768,"medium_large-height":433,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/minmaxscaler.jpg","large-width":925,"large-height":521,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/minmaxscaler.jpg","1536x1536-width":925,"1536x1536-height":521,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/minmaxscaler.jpg","2048x2048-width":925,"2048x2048-height":521,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/minmaxscaler-826x465.jpg","card_image-width":826,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/minmaxscaler.jpg","wide_image-width":925,"wide_image-height":521}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Now we can calculate the composite index by averaging the scaled and weighted percentage columns.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943452,"id":1943452,"title":"Composite Index","filename":"composite-index.jpg","filesize":136935,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/composite-index.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/composite-index","alt":"","author":"317312","description":"","caption":"","name":"composite-index","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 14:56:33","modified":"2023-05-26 14:56:46","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":885,"height":420,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/composite-index-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/composite-index.jpg","medium-width":464,"medium-height":220,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/composite-index.jpg","medium_large-width":768,"medium_large-height":364,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/composite-index.jpg","large-width":885,"large-height":420,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/composite-index.jpg","1536x1536-width":885,"1536x1536-height":420,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/composite-index.jpg","2048x2048-width":885,"2048x2048-height":420,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/composite-index-826x392.jpg","card_image-width":826,"card_image-height":392,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/composite-index.jpg","wide_image-width":885,"wide_image-height":420}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><strong>4. Make the data geographic by adding geometry <\/strong><\/p>\n<p>Now that we have created a data frame, the next step is to add geographic information to our data and convert it into a feature layer in order to view the data on a map. This can be easily accomplished by accessing the USA county boundaries from Esri&#8217;s feature layer collection and adding them to the data created above.<\/p>\n<p>First, we connect to our ArcGIS profile and then access the County Boundaries item.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943472,"id":1943472,"title":"","filename":"connect-to-online.jpg","filesize":22630,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/connect-to-online.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/connect-to-online","alt":"","author":"317312","description":"","caption":"","name":"connect-to-online","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 15:02:33","modified":"2023-05-26 15:02:45","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":734,"height":92,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/connect-to-online-213x92.jpg","thumbnail-width":213,"thumbnail-height":92,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/connect-to-online.jpg","medium-width":464,"medium-height":58,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/connect-to-online.jpg","medium_large-width":734,"medium_large-height":92,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/connect-to-online.jpg","large-width":734,"large-height":92,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/connect-to-online.jpg","1536x1536-width":734,"1536x1536-height":92,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/connect-to-online.jpg","2048x2048-width":734,"2048x2048-height":92,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/connect-to-online.jpg","card_image-width":734,"card_image-height":92,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/connect-to-online.jpg","wide_image-width":734,"wide_image-height":92}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><a href=\"https:\/\/developers.arcgis.com\/python\/api-reference\/arcgis.gis.toc.html#item\">Item<\/a>s reference resources you can use through ArcGIS Online. In this case, we are taking advantage of an administrative boundaries dataset made available through ArcGIS Living Atlas.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943482,"id":1943482,"title":"","filename":"items.jpg","filesize":86620,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/items.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/items-2","alt":"","author":"317312","description":"","caption":"","name":"items-2","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 15:03:05","modified":"2023-05-26 15:03:13","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1274,"height":284,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/items-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/items.jpg","medium-width":464,"medium-height":103,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/items.jpg","medium_large-width":768,"medium_large-height":171,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/items.jpg","large-width":1274,"large-height":284,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/items.jpg","1536x1536-width":1274,"1536x1536-height":284,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/items.jpg","2048x2048-width":1274,"2048x2048-height":284,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/items-826x184.jpg","card_image-width":826,"card_image-height":184,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/items.jpg","wide_image-width":1274,"wide_image-height":284}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>This item references the variety of feature layers we can use. In our case, we need Counties, the layer referenced by the 2 index.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943492,"id":1943492,"title":"","filename":"layer-2.jpg","filesize":33199,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/layer-2.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/layer-2-2","alt":"","author":"317312","description":"","caption":"","name":"layer-2-2","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 15:03:31","modified":"2023-05-26 15:03:39","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":509,"height":200,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/layer-2-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/layer-2.jpg","medium-width":464,"medium-height":182,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/layer-2.jpg","medium_large-width":509,"medium_large-height":200,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/layer-2.jpg","large-width":509,"large-height":200,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/layer-2.jpg","1536x1536-width":509,"1536x1536-height":200,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/layer-2.jpg","2048x2048-width":509,"2048x2048-height":200,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/layer-2.jpg","card_image-width":509,"card_image-height":200,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/layer-2.jpg","wide_image-width":509,"wide_image-height":200}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Using the correct index, we can retrieve Counties as a <a href=\"https:\/\/developers.arcgis.com\/python\/api-reference\/arcgis.features.toc.html#featurelayer\">FeatureLayer: <\/a><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943502,"id":1943502,"title":"","filename":"feature-lyr.jpg","filesize":30517,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/feature-lyr.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/feature-lyr","alt":"","author":"317312","description":"","caption":"","name":"feature-lyr","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 15:04:20","modified":"2023-05-26 15:04:27","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":890,"height":120,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/feature-lyr-213x120.jpg","thumbnail-width":213,"thumbnail-height":120,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/feature-lyr.jpg","medium-width":464,"medium-height":63,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/feature-lyr.jpg","medium_large-width":768,"medium_large-height":104,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/feature-lyr.jpg","large-width":890,"large-height":120,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/feature-lyr.jpg","1536x1536-width":890,"1536x1536-height":120,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/feature-lyr.jpg","2048x2048-width":890,"2048x2048-height":120,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/feature-lyr-826x111.jpg","card_image-width":826,"card_image-height":111,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/feature-lyr.jpg","wide_image-width":890,"wide_image-height":120}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>By performing a join, we can now combine our custom data with the percent columns and the composite index describing economic distress with the geometries retrieved above to create a new spatially enabled DataFrame.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943512,"id":1943512,"title":"","filename":"dfgeo.jpg","filesize":147524,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/dfgeo.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/dfgeo","alt":"","author":"317312","description":"","caption":"","name":"dfgeo","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 15:06:05","modified":"2023-05-26 15:06:13","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":804,"height":549,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/dfgeo-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/dfgeo.jpg","medium-width":382,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/dfgeo.jpg","medium_large-width":768,"medium_large-height":524,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/dfgeo.jpg","large-width":804,"large-height":549,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/dfgeo.jpg","1536x1536-width":804,"1536x1536-height":549,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/dfgeo.jpg","2048x2048-width":804,"2048x2048-height":549,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/dfgeo-681x465.jpg","card_image-width":681,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/dfgeo.jpg","wide_image-width":804,"wide_image-height":549}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The resulting feature layer includes state and county information, as well as all six components comprising the index and the calculated composite index score. Below is a snapshot of the new spatially enabled DataFrame.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943532,"id":1943532,"title":"","filename":"result.jpg","filesize":100358,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/result.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/result-3","alt":"","author":"317312","description":"","caption":"","name":"result-3","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 15:07:00","modified":"2023-05-26 15:07:09","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":865,"height":415,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/result-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/result.jpg","medium-width":464,"medium-height":223,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/result.jpg","medium_large-width":768,"medium_large-height":368,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/result.jpg","large-width":865,"large-height":415,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/result.jpg","1536x1536-width":865,"1536x1536-height":415,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/result.jpg","2048x2048-width":865,"2048x2048-height":415,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/result-826x396.jpg","card_image-width":826,"card_image-height":396,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/result.jpg","wide_image-width":865,"wide_image-height":415}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><strong>5. Share your feature layer to ArcGIS Online for mapping<\/strong><\/p>\n<p>To enable further exploration and sharing, we now can share this to our organization on ArcGIS Online, where we can take advantage of <a href=\"https:\/\/storymaps.arcgis.com\/collections\/9dd9f03ac2554da4af78b42020fb40c1?item=1\">Smart Mapping<\/a>, <a href=\"https:\/\/www.esri.com\/en-us\/arcgis\/products\/arcgis-instant-apps\/overview\">Instant Apps<\/a> and <a href=\"https:\/\/www.esri.com\/en-us\/arcgis\/products\/arcgis-dashboards\/overview\">ArcGIS Dashboards<\/a> to share insights derived from this data.<\/p>\n<p>You are now ready to publish the newly created feature layer to ArcGIS Online. Here is a code snippet that illustrates how to connect to your ArcGIS Online using your Python account and publish the layer:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1943562,"id":1943562,"title":"","filename":"fl.jpg","filesize":55702,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/fl.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\/fl","alt":"","author":"317312","description":"","caption":"","name":"fl","status":"inherit","uploaded_to":1943312,"date":"2023-05-26 15:07:52","modified":"2023-05-26 15:08:00","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":707,"height":273,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/fl-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/fl.jpg","medium-width":464,"medium-height":179,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/fl.jpg","medium_large-width":707,"medium_large-height":273,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/fl.jpg","large-width":707,"large-height":273,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/fl.jpg","1536x1536-width":707,"1536x1536-height":273,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/fl.jpg","2048x2048-width":707,"2048x2048-height":273,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/fl.jpg","card_image-width":707,"card_image-height":273,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/fl.jpg","wide_image-width":707,"wide_image-height":273}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Publishing the layer enables us to visualize it as a map and allows us to configure various visual settings such as symbology, labels, and other elements as desired. Additionally, it allows others to view and interact with the map.<\/p>\n<p>If, however, you want to save the data locally to use with ArcGIS Pro for further analysis, you can also easily convert this spatially enabled data frame to a feature class using the <a href=\"https:\/\/developers.arcgis.com\/python\/api-reference\/arcgis.features.toc.html#arcgis.features.GeoAccessor.to_featureclass\">to_featureclass<\/a> method.<\/p>\n<p>For a thorough understanding of the step-by-step process involved in this workflow, we invite you to explore our comprehensive Python notebook available at this <a href=\"https:\/\/knu2xs.github.io\/arcgis-economic-distress-index\/index.htm\">link.<\/a><\/p>\n<p>Once transformed into maps, indexes serve as valuable tools for analysts and policymakers, enabling them to identify at-risk areas. This, in turn, provides a foundation for policy formulation and informed decision-making. Governments and NGOs can use the economic distress index to identify areas that need attention, prioritize resource allocation, and contribute to the design of interventions that promote equitable and sustainable development.<\/p>\n"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/banner-small.jpg","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/banner-large.jpg","related_articles":[{"ID":1854162,"post_author":"78361","post_date":"2023-02-24 11:00:37","post_date_gmt":"2023-02-24 19:00:37","post_content":"","post_title":"Design a web map to analyze residential segregation in the U.S.","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"design-a-web-map-to-analyze-residential-racial-segregation-in-the-us","to_ping":"","pinged":"","post_modified":"2025-03-07 13:54:28","post_modified_gmt":"2025-03-07 21:54:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1854162","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1813662,"post_author":"317312","post_date":"2023-01-10 14:30:18","post_date_gmt":"2023-01-10 22:30:18","post_content":"","post_title":"How we did it: Creating a web map to explore residential disadvantage across U.S. communities","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"how-we-did-it-designing-a-web-map-to-analyze-racial-disadvantage-in-the-u-s","to_ping":"","pinged":"","post_modified":"2025-04-29 09:26:31","post_modified_gmt":"2025-04-29 16:26:31","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1813662","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1866732,"post_author":"334612","post_date":"2023-03-13 10:48:46","post_date_gmt":"2023-03-13 17:48:46","post_content":"","post_title":"Explore the New Calculate Composite Index Tool in ArcGIS Pro 3.1","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"new-calculate-composite-index-tool-in-arcgis-pro-3-1","to_ping":"","pinged":"","post_modified":"2023-06-15 09:59:15","post_modified_gmt":"2023-06-15 16:59:15","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1866732","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}]},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Creating an economic distress index layer using Census data with Python<\/title>\n<meta name=\"description\" content=\"In this blog article, we will guide you through creating an economic distress index layer from Census data using Python.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating an economic distress index layer using Census data with Python\" \/>\n<meta property=\"og:description\" content=\"In this blog article, we will guide you through creating an economic distress index layer from Census data using Python.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-26T21:16:15+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\"},\"author\":{\"name\":\"Elif Bulut\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4387344ead563b42b8031495ffd80a5e\"},\"headline\":\"Creating an economic distress index layer using Census data with Python\",\"datePublished\":\"2023-05-26T15:28:28+00:00\",\"dateModified\":\"2023-07-26T21:16:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\"},\"wordCount\":11,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"American Community Survey\",\"ArcGIS API for Python\",\"Census\",\"composite index\",\"economic distress\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\",\"name\":\"Creating an economic distress index layer using Census data with Python\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2023-05-26T15:28:28+00:00\",\"dateModified\":\"2023-07-26T21:16:15+00:00\",\"description\":\"In this blog article, we will guide you through creating an economic distress index layer from Census data using Python.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating an economic distress index layer using Census data with Python\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4387344ead563b42b8031495ffd80a5e\",\"name\":\"Elif Bulut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/10\/Elif-Bulut_Nov-24_2021_profie-pic.jpeg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/10\/Elif-Bulut_Nov-24_2021_profie-pic.jpeg\",\"caption\":\"Elif Bulut\"},\"description\":\"Elif is a Product Engineer of Social Analysis and Data Science on the ArcGIS Business Analyst team. She holds a PhD in Sociology and applies spatial data science and social research to help users explore demographic trends, community characteristics, and access to resources. She is passionate about turning complex data into clear insights that support real-world decision-making.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/elif-bulut-phd\/\"],\"gender\":\"Female\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/ebulut\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Creating an economic distress index layer using Census data with Python","description":"In this blog article, we will guide you through creating an economic distress index layer from Census data using Python.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python","og_locale":"en_US","og_type":"article","og_title":"Creating an economic distress index layer using Census data with Python","og_description":"In this blog article, we will guide you through creating an economic distress index layer from Census data using Python.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2023-07-26T21:16:15+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python"},"author":{"name":"Elif Bulut","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4387344ead563b42b8031495ffd80a5e"},"headline":"Creating an economic distress index layer using Census data with Python","datePublished":"2023-05-26T15:28:28+00:00","dateModified":"2023-07-26T21:16:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python"},"wordCount":11,"commentCount":4,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["American Community Survey","ArcGIS API for Python","Census","composite index","economic distress"],"articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python","name":"Creating an economic distress index layer using Census data with Python","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2023-05-26T15:28:28+00:00","dateModified":"2023-07-26T21:16:15+00:00","description":"In this blog article, we will guide you through creating an economic distress index layer from Census data using Python.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Creating an economic distress index layer using Census data with Python"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4387344ead563b42b8031495ffd80a5e","name":"Elif Bulut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/10\/Elif-Bulut_Nov-24_2021_profie-pic.jpeg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/10\/Elif-Bulut_Nov-24_2021_profie-pic.jpeg","caption":"Elif Bulut"},"description":"Elif is a Product Engineer of Social Analysis and Data Science on the ArcGIS Business Analyst team. She holds a PhD in Sociology and applies spatial data science and social research to help users explore demographic trends, community characteristics, and access to resources. She is passionate about turning complex data into clear insights that support real-world decision-making.","sameAs":["https:\/\/www.linkedin.com\/in\/elif-bulut-phd\/"],"gender":"Female","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/ebulut"}]}},"text_date":"May 26, 2023","author_name":"Multiple Authors","author_page":"https:\/\/www.esri.com\/arcgis-blog\/products\/api-python\/analytics\/creating-an-economic-distress-index-using-python","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/05\/banner-large.jpg","primary_product":"ArcGIS API for Python","tag_data":[{"term_id":36021,"name":"American Community Survey","slug":"american-community-survey","term_group":0,"term_taxonomy_id":36021,"taxonomy":"post_tag","description":"","parent":0,"count":37,"filter":"raw"},{"term_id":387782,"name":"ArcGIS API for Python","slug":"arcgis-api-for-python","term_group":0,"term_taxonomy_id":387782,"taxonomy":"post_tag","description":"","parent":0,"count":44,"filter":"raw"},{"term_id":31361,"name":"Census","slug":"census","term_group":0,"term_taxonomy_id":31361,"taxonomy":"post_tag","description":"","parent":0,"count":35,"filter":"raw"},{"term_id":769372,"name":"composite index","slug":"composite-index","term_group":0,"term_taxonomy_id":769372,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw"},{"term_id":771242,"name":"economic distress","slug":"economic-distress","term_group":0,"term_taxonomy_id":771242,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1333,"filter":"raw"}],"product_data":[{"term_id":36841,"name":"ArcGIS API for Python","slug":"api-python","term_group":0,"term_taxonomy_id":36841,"taxonomy":"product","description":"","parent":36601,"count":151,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=api-python","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1943312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/317312"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=1943312"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1943312\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1943312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1943312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1943312"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1943312"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1943312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}