topic find and average duplicate records python in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/find-and-average-duplicate-records-python/m-p/168373#M5657 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have a problem where I ran an intersect of a rotated polygon against it's unrotated polygon and due to tiny amounts of overlap with adjacent polygons, there are duplicate records. Has anyone found a way, or might point me in the direction of how to find those duplicate records and average the values associated with the row?</SPAN><BR /><BR /><SPAN>for example, if I have an FID associated with the original FID of the intersected shapefile [ORIG_FID_R], is there a way to sort the [ORIG_FID_R], and average all the values associated with that row?</SPAN><BR /><BR /><SPAN>or... any other suggestions would be appreciated!</SPAN><BR /><BR /><SPAN>stumped,</SPAN><BR /><BR /><SPAN>aaron</SPAN></BODY></HTML> Thu, 29 Apr 2010 22:39:32 GMT aaronreyna 2010-04-29T22:39:32Z find and average duplicate records python https://community.esri.com/t5/geoprocessing-questions/find-and-average-duplicate-records-python/m-p/168373#M5657 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have a problem where I ran an intersect of a rotated polygon against it's unrotated polygon and due to tiny amounts of overlap with adjacent polygons, there are duplicate records. Has anyone found a way, or might point me in the direction of how to find those duplicate records and average the values associated with the row?</SPAN><BR /><BR /><SPAN>for example, if I have an FID associated with the original FID of the intersected shapefile [ORIG_FID_R], is there a way to sort the [ORIG_FID_R], and average all the values associated with that row?</SPAN><BR /><BR /><SPAN>or... any other suggestions would be appreciated!</SPAN><BR /><BR /><SPAN>stumped,</SPAN><BR /><BR /><SPAN>aaron</SPAN></BODY></HTML> Thu, 29 Apr 2010 22:39:32 GMT https://community.esri.com/t5/geoprocessing-questions/find-and-average-duplicate-records-python/m-p/168373#M5657 aaronreyna 2010-04-29T22:39:32Z Re: find and average duplicate records python https://community.esri.com/t5/geoprocessing-questions/find-and-average-duplicate-records-python/m-p/168374#M5658 <HTML><HEAD></HEAD><BODY><SPAN>Have you tried the Summary Statistics tool?&nbsp; The field ORIG_FID_R would be your Case field.</SPAN></BODY></HTML> Sun, 23 May 2010 17:34:34 GMT https://community.esri.com/t5/geoprocessing-questions/find-and-average-duplicate-records-python/m-p/168374#M5658 DaleHoneycutt 2010-05-23T17:34:34Z