I have a feature class with fields: Latitude, Longitude, Type, Magnitude, City, State, Comment.
If Latitude, Longitude , and Type are the same, I only want to keep the record with the highest Magnitude value (magnitude will vary usually).
However, sometimes there are duplicates in the data (all fields have duplicate values), so I would only want to keep one record.
I am running ArcGIS 10.3 for Desktop and Python 2.7.8.
After creating a table of max magnitude would I then join this table back to my feature class to create a new feature class?
arcpy.Statistics_analysis("C:/csv/all_reports.gdb/reportsSel", "C:/csv/all_reports.gdb/reportsSel2", [["MAG", "MAX"]], ["Type", "Longitude", "Latitude"])