I would like to generate some quintile maps based on the averaged sentiment score in each city in the US. However, not all the city has the same number of data point. How can I tell ArcGIS to show averaged sentiment score in each city that has at least, say 100, data points and leave the ones with less than 100 data points blank?
To be more specific, I have some csv data with latitude and longitude,
- I first import XY as csv into ArcGIS,
- then I export this csv into .shp file,
- each XY point contains a sentiment score, and ultimately I would like to get an averaged sentiment score of each city,
- I then spatially join the new .shp file containing my data with a base file of US city, and the aggregation method is to average the sentiment points into one averaged score per city,
- then I would like to generate quintile map based on the averaged sentiment score.
I just want the final quintile map leave those cities with less than 100 data points originally. I am not sure how and where I can specify when I generate the final quintile map to look into the original data in .shp and screen out the cities that don't have at least 100 data points.
Although I am getting more knowledgeable about how to select data via Query, it doesn't address my issues:
- I don't see any reference from their document of how to query based on number of data points (they have given an example of using "population" variable > 1000, but it's not the same); and
- even if I can successfully select cities satisfied the threshold data points, I still need to join all areas with the base map and the final map will still see cities with less than 100 data points as having 0 averaged sentiment.