My organization has a point dataset with over 1 million records that needs to be symbolized by one of it's attributes (lets call it status). Each week approximately 10,000 statuses of the >1 million need to be updated based on what happened that week.
I'm curious if the best method is to simply use the Python API to join based on ID, and calculate? Can I do this more efficiently then joining a such a small change to a large dataset?Am I over complicating this? Visual representation of the dataset below.
![](/legacyfs/online/447084_dataset.PNG)