{"id":2968957,"date":"2026-06-22T12:00:08","date_gmt":"2026-06-22T19:00:08","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=2968957"},"modified":"2026-06-22T12:00:21","modified_gmt":"2026-06-22T19:00:21","slug":"handling-non-numeric-values","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values","title":{"rendered":"Handling non-numeric values during data cleaning"},"author":7121,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23851],"tags":[758111,781140,781138,781141],"industry":[],"product":[36581,36551,36561],"class_list":["post-2968957","blog","type-blog","status-publish","format-standard","hentry","category-data-management","tag-conditional-rendering","tag-handling-nulls","tag-negative-values","tag-null-values","product-arcgis-living-atlas","product-arcgis-online","product-arcgis-pro"],"acf":{"authors":[{"ID":7121,"user_firstname":"Diana","user_lastname":"Lavery","nickname":"Diana Lavery","user_nicename":"dianaclavery_global","display_name":"Diana Lavery","user_email":"DLavery@esri.com","user_url":"","user_registered":"2018-03-02 00:19:20","user_description":"(she\/her\/hers) Diana loves working with data. She has over 15 years experience as a practitioner of demography, sociology, economics, policy analysis, and GIS. Diana holds a BA in quantitative economics and an MA in applied demography. She is a senior GIS engineer on ArcGIS Living Atlas of the World's Policy Maps team. Diana enjoys strong coffee and clean datasets, usually simultaneously.","user_avatar":""}],"short_description":"Working with a dataset that contains -999, or other strange values that represent non-numeric constructs is common when prepping GIS data.","flexible_content":[{"acf_fc_layout":"content","content":"

Working with a dataset that contains 999, -999, 888, or other strange values that represent non-numeric constructs is common when prepping GIS data. Often these values don’t represent the integer value, but rather many different reasons for missing data points. “Not sure” is categorically different from “decline to state,” which is categorically different from Not Applicable, or a particular geography never even being included in the survey from the start.<\/p>\n

Data evaluation<\/h1>\n

These different flavors of missing data are often represented by specific integer values in a numeric data field that are (hopefully) referenced in a Data Dictionary or Codebook. These differences are important to understand during the source evaluation phase of working with a new dataset. There are often cultural, age, and gender differences in who answers “don’t know” vs. who skips questions, vs. who even answers surveys in the first place (Sage Journal study<\/a>). In general, missing data can point to the underlying data quality, and how suitable this dataset will be to answer your specific questions.<\/p>\n

Calculating statistics<\/h1>\n

Once you’ve determined that this dataset is fit for use for your purposes, you will have to handle these non-numeric values somehow. When summarizing these fields to find the average or median, these extreme values will yield your initial meaningless results.<\/p>\n

For example, this Wind Turbines layer<\/a> has a field called “Project Capacity (MV)” that has a minimum of -9999, a clue that this field might need to be handled with care. (Negative megawatts would be quite strange, after all.) Descriptive statistics such as mean, median, and standard deviation here are not going to be valid until we do a bit of data cleaning.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2969028,"id":2969028,"title":"WindTurbine_DataTab","filename":"WindTurbine_DataTab.png","filesize":147059,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_DataTab.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\/windturbine_datatab","alt":"The descriptive statistics for the field p_cap (Project Capacity (MW)) is shown. The minimum (highlighed with a green box) says -9,999.000, the max is listed as 1,055.600, the mean is listed as -205.68 (with a question mark next to it), and the standard deviation is listed as 1,966.59 (also with a question mark next to it).","author":"7121","description":"","caption":"","name":"windturbine_datatab","status":"inherit","uploaded_to":2968957,"date":"2026-06-05 05:09:46","modified":"2026-06-22 18:42:47","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1904,"height":853,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_DataTab-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_DataTab.png","medium-width":464,"medium-height":208,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_DataTab.png","medium_large-width":768,"medium_large-height":344,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_DataTab.png","large-width":1904,"large-height":853,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_DataTab-1536x688.png","1536x1536-width":1536,"1536x1536-height":688,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_DataTab.png","2048x2048-width":1904,"2048x2048-height":853,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_DataTab-826x370.png","card_image-width":826,"card_image-height":370,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_DataTab.png","wide_image-width":1904,"wide_image-height":853}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_DataTab.png"},{"acf_fc_layout":"content","content":"

Symbolizing on this field would also be problematic.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2969029,"id":2969029,"title":"WindTurbine_Legend_AsIs","filename":"WindTurbine_Legend_AsIs.png","filesize":28799,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Legend_AsIs.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\/windturbine_legend_asis","alt":"A proportional symbols legend with the smallest circle next to a label that says -9999.","author":"7121","description":"","caption":"","name":"windturbine_legend_asis","status":"inherit","uploaded_to":2968957,"date":"2026-06-05 05:19:39","modified":"2026-06-22 18:47:54","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":377,"height":628,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Legend_AsIs-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Legend_AsIs.png","medium-width":157,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Legend_AsIs.png","medium_large-width":377,"medium_large-height":628,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Legend_AsIs.png","large-width":377,"large-height":628,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Legend_AsIs.png","1536x1536-width":377,"1536x1536-height":628,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Legend_AsIs.png","2048x2048-width":377,"2048x2048-height":628,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Legend_AsIs-279x465.png","card_image-width":279,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Legend_AsIs.png","wide_image-width":377,"wide_image-height":628}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Legend_AsIs.png"},{"acf_fc_layout":"content","content":"

How can we convert all these values to null? Let’s explore the many ways to do this throughout ArcGIS. We’ll start with the simple ways and then end with more intermediate\/advanced methods.<\/p>\n

Method 1: Apply a filter or definition query<\/h1>\n

Applying a filter in ArcGIS Online<\/a> or a definition query in ArcGIS Pro<\/a> is a great, light-weight way to subset your records to include ones that meet specific criteria. Filter by attribute with a simple expression. In our Wind Turbines example, the expression is: Project Capacity is at least 0.<\/p>\n

 <\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2969030,"id":2969030,"title":"WindTurbine_Filter","filename":"WindTurbine_Filter.png","filesize":39317,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Filter.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\/windturbine_filter","alt":"A filter in ArcGIS Online that says Project Capacity (MV) -> is at least -> 0.","author":"7121","description":"","caption":"","name":"windturbine_filter","status":"inherit","uploaded_to":2968957,"date":"2026-06-05 05:22:24","modified":"2026-06-22 18:48:28","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":447,"height":744,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Filter-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Filter.png","medium-width":157,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Filter.png","medium_large-width":447,"medium_large-height":744,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Filter.png","large-width":447,"large-height":744,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Filter.png","1536x1536-width":447,"1536x1536-height":744,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Filter.png","2048x2048-width":447,"2048x2048-height":744,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Filter-279x465.png","card_image-width":279,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Filter.png","wide_image-width":447,"wide_image-height":744}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Filter.png"},{"acf_fc_layout":"content","content":"

This allows you to symbolize, visualize, and summarize the subset of the data that does not contain the non-numeric values.<\/p>\n

On the flip side, you can apply a filter to only<\/em> display features that have values of -9999, in order to see if there are obvious spatial patterns in missing data. This can be helpful during the data exploration \/ source evaluation phase.<\/p>\n

By applying a filter, you are not changing the underlying attribute table. Even if you don’t own the data layer, you can save the filter to your web map and proceed.<\/p>\n

Method 2: Use Arcade to handle these values on the fly<\/h1>\n

Similar to Method 1, using an if-statement in Arcade to handle these values will allow you to symbolize properly, even if you don’t own the layer. This can be advantageous if the data values are updated frequently.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2969032,"id":2969032,"title":"WindTurbine_Arcade","filename":"WindTurbine_Arcade.png","filesize":19467,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Arcade.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\/windturbine_arcade","alt":"An Arcade expression entitled \"Project Capacity\" that says: iif($feature.p_cap == -9999, null, $feature.p_cap)","author":"7121","description":"","caption":"","name":"windturbine_arcade","status":"inherit","uploaded_to":2968957,"date":"2026-06-05 05:39:05","modified":"2026-06-22 18:49:44","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":883,"height":281,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Arcade-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Arcade.png","medium-width":464,"medium-height":148,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Arcade.png","medium_large-width":768,"medium_large-height":244,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Arcade.png","large-width":883,"large-height":281,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Arcade.png","1536x1536-width":883,"1536x1536-height":281,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Arcade.png","2048x2048-width":883,"2048x2048-height":281,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Arcade-826x263.png","card_image-width":826,"card_image-height":263,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Arcade.png","wide_image-width":883,"wide_image-height":281}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/WindTurbine_Arcade.png"},{"acf_fc_layout":"content","content":"

Method 3: Use Calculate Field<\/h1>\n

If you own the layer, you can use Calculate Field in both ArcGIS Online<\/a> and ArcGIS Pro<\/a> to overwrite any values with null. This does permanently change the data table, which can be advantageous if you’re preparing a layer for others to use.<\/p>\n

Another advantage of using Calculate Field is that you can deal with multiple values at once. For example, the Local Air Conditioning Estimates<\/a> dataset contains -88888888, -66666666, -22222222, and more in the original source. Each denote different reasons that data is missing. As such, some need to be set to null, and others need to be set to zero. I can handle multiple values in one expression while calculating the field.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2969035,"id":2969035,"title":"CalculateField","filename":"CalculateField.png","filesize":591697,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/CalculateField.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\/calculatefield-2","alt":"An attribute table open in ArcGIS Pro, with a field with a lot of -8888888 values highlighted. The options are open, and Calculate Field option is highlighted with a green box.","author":"7121","description":"","caption":"","name":"calculatefield-2","status":"inherit","uploaded_to":2968957,"date":"2026-06-05 05:58:07","modified":"2026-06-22 18:56:04","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1091,"height":826,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/CalculateField-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/CalculateField.png","medium-width":345,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/CalculateField.png","medium_large-width":768,"medium_large-height":581,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/CalculateField.png","large-width":1091,"large-height":826,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/CalculateField.png","1536x1536-width":1091,"1536x1536-height":826,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/CalculateField.png","2048x2048-width":1091,"2048x2048-height":826,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/CalculateField-614x465.png","card_image-width":614,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/CalculateField.png","wide_image-width":1091,"wide_image-height":826}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/CalculateField.png"},{"acf_fc_layout":"content","content":"

Method 4: Use Find and Replace in ArcGIS Pro<\/h1>\n

If the non-integer values are consistent across multiple fields, it can be faster to do a bulk Find and Replace<\/a> for the entire table in ArcGIS Pro. Much like in Microsoft Excel, it will find every cell that matches a specific value, and will search across multiple fields.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2969036,"id":2969036,"title":"FindAndReplace","filename":"FindAndReplace.png","filesize":392208,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/FindAndReplace.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\/findandreplace-2","alt":"The same attribute table open in ArcGIS Pro, this time with the find and replace section open. -88888888 is typed into the Find field, and the value is found across multiple fields.","author":"7121","description":"","caption":"","name":"findandreplace-2","status":"inherit","uploaded_to":2968957,"date":"2026-06-05 06:02:54","modified":"2026-06-22 18:57:16","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1110,"height":652,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/FindAndReplace-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/FindAndReplace.png","medium-width":444,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/FindAndReplace.png","medium_large-width":768,"medium_large-height":451,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/FindAndReplace.png","large-width":1110,"large-height":652,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/FindAndReplace.png","1536x1536-width":1110,"1536x1536-height":652,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/FindAndReplace.png","2048x2048-width":1110,"2048x2048-height":652,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/FindAndReplace-792x465.png","card_image-width":792,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/FindAndReplace.png","wide_image-width":1110,"wide_image-height":652}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/FindAndReplace.png"},{"acf_fc_layout":"content","content":"

Method 5: Handle these values programmatically at data ingest<\/h1>\n

For large datasets with dozens of attribute tables, multiple levels of geography, or multiple years, you can handle these types of values programmatically upon ingesting the data, and take care of these values from the start.<\/p>\n

This is what we do for the layers in Living Atlas containing data from U.S. Census Bureau’s American Community Survey.<\/a> Census has documentation<\/a> about all the different meanings behind many different values. We set -555555555 to zero and all other negative numbers, “-“, and “*” to null in our scripted process as soon as we extract it from the API. You can do something similar using ArcGIS Data Pipelines, ArcGIS Notebooks, and stand-alone scripts.<\/p>\n

Handling these edge-cases as soon as possible helps ensure that downstream logic and calculations won’t have errors due to these values.<\/p>\n"},{"acf_fc_layout":"content","content":"

Document and comment your data cleaning process<\/h1>\n

Methods 3 through 5 above create permanent changes to the raw data.<\/strong> The long field descriptions as well as the Item Details Page are the perfect places to document the modifications you have made.<\/p>\n

Comments in code (Arcade, Python, etc.) as well as notes in Data Pipeline elements all provide great places to do this. This helps you out when you come back to this project in a few weeks and try to remember what you did. It also helps others trust your work and your process.<\/p>\n

If your goal is to provide the data as pure, unadulterated, and high-fidelity to the original source (such as the Wind Turbines layer<\/a>), then providing a link in the Item Details Page to the original source is necessary so that others can research the meanings of these values.<\/p>\n

More advanced options<\/h1>\n

You aren’t stuck with nulls or zeros. Many sophisticated imputation techniques exist in the field of statistics, social sciences, and data science. These techniques generally involve finding similar data points other (non-null) attributes, and then using their information to create an informed data estimate.<\/p>\n

One geoprocessing tool for this is called Fill Missing Values.<\/a> This tool allows you to estimate missing values based on spatial neighbors, time neighbors, or other statistics within your dataset.<\/p>\n"},{"acf_fc_layout":"content","content":"

Share your methods<\/h1>\n

These are just a few of the many ways to handle these types of values. Have you ever had a GIS project that involved handling strange numeric values as part of your data cleaning process? How did you approach it? Let us know in Esri Community<\/a>.<\/p>\n"}],"related_articles":[{"ID":1211452,"post_author":"7121","post_date":"2021-07-09 08:32:24","post_date_gmt":"2021-07-09 15:32:24","post_content":"","post_title":"Ethical considerations for surveys","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"ethics","to_ping":"","pinged":"","post_modified":"2021-07-09 08:33:34","post_modified_gmt":"2021-07-09 15:33:34","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1211452","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1802182,"post_author":"7121","post_date":"2023-01-18 15:08:07","post_date_gmt":"2023-01-18 23:08:07","post_content":"","post_title":"High-Quality Field Descriptions Make Mapping Easier","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"high-quality-field-descriptions","to_ping":"","pinged":"","post_modified":"2023-01-18 15:20:48","post_modified_gmt":"2023-01-18 23:20:48","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1802182","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"2","filter":"raw"},{"ID":2927161,"post_author":"134231","post_date":"2025-12-31 21:15:06","post_date_gmt":"2026-01-01 05:15:06","post_content":"","post_title":"Enhance Your Attribute Field Quality with Coded Domain Fields","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"enhance-your-attribute-field-quality-with-coded-domain-fields","to_ping":"","pinged":"","post_modified":"2026-01-11 21:15:55","post_modified_gmt":"2026-01-12 05:15:55","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=2927161","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":742692,"post_author":"7121","post_date":"2020-02-24 11:45:05","post_date_gmt":"2020-02-24 19:45:05","post_content":"","post_title":"Transform your layers\u2019 value with more functional attribute field names, aliases, and descriptions","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"transform-your-layers-value-with-more-functional-attribute-field-names-aliases-and-descriptions","to_ping":"","pinged":"","post_modified":"2026-01-15 15:09:29","post_modified_gmt":"2026-01-15 23:09:29","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=742692","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1943942,"post_author":"8932","post_date":"2023-05-30 12:29:00","post_date_gmt":"2023-05-30 19:29:00","post_content":"","post_title":"Explore and Prepare Your Data with ArcGIS Pro Data Engineering","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"explore-and-prepare-your-data-with-arcgis-pro-data-engineering","to_ping":"","pinged":"","post_modified":"2023-06-13 06:24:23","post_modified_gmt":"2023-06-13 13:24:23","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1943942","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":257232,"post_author":"7121","post_date":"2018-07-02 08:53:50","post_date_gmt":"2018-07-02 15:53:50","post_content":"","post_title":"Evaluate and Prep Your Tabular Data in ArcGIS Online","post_excerpt":"","post_status":"publish","comment_status":"closed","ping_status":"closed","post_password":"","post_name":"evaluate-and-prep-your-tabular-data-in-arcgis-online","to_ping":"","pinged":"","post_modified":"2020-01-03 10:01:47","post_modified_gmt":"2020-01-03 18:01:47","post_content_filtered":"","post_parent":0,"guid":"http:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=257232","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"show_article_image":true,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/Non-numericValues_Card.png","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/Non-numericValues_Banner.png"},"yoast_head":"\nHandling non-numeric values during data cleaning<\/title>\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\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Handling non-numeric values during data cleaning\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\" \/>\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=\"2026-06-22T19:00:21+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\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\/arcgis-living-atlas\/data-management\/handling-non-numeric-values#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\"},\"author\":{\"name\":\"Diana Lavery\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/1f2b2b13a804cac814ed4245368e9eb9\"},\"headline\":\"Handling non-numeric values during data cleaning\",\"datePublished\":\"2026-06-22T19:00:08+00:00\",\"dateModified\":\"2026-06-22T19:00:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\"},\"wordCount\":6,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"conditional rendering\",\"handling nulls\",\"negative values\",\"null values\"],\"articleSection\":[\"Data Management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\",\"name\":\"Handling non-numeric values during data cleaning\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2026-06-22T19:00:08+00:00\",\"dateModified\":\"2026-06-22T19:00:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Handling non-numeric values during data cleaning\"}]},{\"@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\/1f2b2b13a804cac814ed4245368e9eb9\",\"name\":\"Diana Lavery\",\"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\/2025\/04\/diana-lavery-3z7a9428-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/04\/diana-lavery-3z7a9428-213x200.jpg\",\"caption\":\"Diana Lavery\"},\"description\":\"(she\/her\/hers) Diana loves working with data. She has over 15 years experience as a practitioner of demography, sociology, economics, policy analysis, and GIS. Diana holds a BA in quantitative economics and an MA in applied demography. She is a senior GIS engineer on ArcGIS Living Atlas of the World's Policy Maps team. Diana enjoys strong coffee and clean datasets, usually simultaneously.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/dianaclavery_global\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Handling non-numeric values during data cleaning","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\/arcgis-living-atlas\/data-management\/handling-non-numeric-values","og_locale":"en_US","og_type":"article","og_title":"Handling non-numeric values during data cleaning","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2026-06-22T19:00:21+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values"},"author":{"name":"Diana Lavery","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/1f2b2b13a804cac814ed4245368e9eb9"},"headline":"Handling non-numeric values during data cleaning","datePublished":"2026-06-22T19:00:08+00:00","dateModified":"2026-06-22T19:00:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values"},"wordCount":6,"commentCount":0,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["conditional rendering","handling nulls","negative values","null values"],"articleSection":["Data Management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values","name":"Handling non-numeric values during data cleaning","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2026-06-22T19:00:08+00:00","dateModified":"2026-06-22T19:00:21+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/data-management\/handling-non-numeric-values#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Handling non-numeric values during data cleaning"}]},{"@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\/1f2b2b13a804cac814ed4245368e9eb9","name":"Diana Lavery","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\/2025\/04\/diana-lavery-3z7a9428-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/04\/diana-lavery-3z7a9428-213x200.jpg","caption":"Diana Lavery"},"description":"(she\/her\/hers) Diana loves working with data. She has over 15 years experience as a practitioner of demography, sociology, economics, policy analysis, and GIS. Diana holds a BA in quantitative economics and an MA in applied demography. She is a senior GIS engineer on ArcGIS Living Atlas of the World's Policy Maps team. Diana enjoys strong coffee and clean datasets, usually simultaneously.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/dianaclavery_global"}]}},"text_date":"June 22, 2026","author_name":"Diana Lavery","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/dianaclavery_global","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/06\/Non-numericValues_Banner.png","primary_product":"ArcGIS Living Atlas","tag_data":[{"term_id":758111,"name":"conditional rendering","slug":"conditional-rendering","term_group":0,"term_taxonomy_id":758111,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":781140,"name":"handling nulls","slug":"handling-nulls","term_group":0,"term_taxonomy_id":781140,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":781138,"name":"negative values","slug":"negative-values","term_group":0,"term_taxonomy_id":781138,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":781141,"name":"null values","slug":"null-values","term_group":0,"term_taxonomy_id":781141,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"}],"category_data":[{"term_id":23851,"name":"Data Management","slug":"data-management","term_group":0,"term_taxonomy_id":23851,"taxonomy":"category","description":"","parent":0,"count":964,"filter":"raw"}],"product_data":[{"term_id":36581,"name":"ArcGIS Living Atlas","slug":"arcgis-living-atlas","term_group":0,"term_taxonomy_id":36581,"taxonomy":"product","description":"","parent":0,"count":1191,"filter":"raw"},{"term_id":36551,"name":"ArcGIS Online","slug":"arcgis-online","term_group":0,"term_taxonomy_id":36551,"taxonomy":"product","description":"","parent":0,"count":2465,"filter":"raw"},{"term_id":36561,"name":"ArcGIS Pro","slug":"arcgis-pro","term_group":0,"term_taxonomy_id":36561,"taxonomy":"product","description":"","parent":0,"count":2126,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-living-atlas","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2968957","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\/7121"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=2968957"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2968957\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=2968957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=2968957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=2968957"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=2968957"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=2968957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}