Select to view content in your preferred language

I am trying to aggregate and summarize zip code date from excel file.

1536
3
02-06-2018 11:47 AM
BrandonRutledge
New Contributor

I am attempting to create a map that shows the frequency of evictions by zip code within a single county.  I have the data in an excel file. What would be the easiest way to import the data to the map. Is this something that is even possible to do?

Thanks in advance. 

0 Kudos
3 Replies
XanderBakker
Esri Esteemed Contributor

What software do you have? Desktop (ArcMap or ArcGIS Pro), ArcGIS Online?

There is a layer with Zip code points available: http://www.arcgis.com/home/item.html?id=70b012d7c6ad4d5b8be7403ee5683aa0 that you can use. Summarize the data in Excel to have the count per ZIP code and join them together to show the locations with the count.

0 Kudos
BrandonRutledge
New Contributor

I am currently using ArcGIS online but I plan to download ArcGIS Pro later today on my macbook. Thanks for the info.

0 Kudos
XanderBakker
Esri Esteemed Contributor
0 Kudos