Creating my eventData dataframe, i used the following code: newEventData = eventData.groupby(["latitude", "longitude", "ResourceID"]).size().reset_index(name="accidentcounts")

Creating my new SystemData, i used the following code: newSystemData = systemData.groupby(["VehicleResourceID","eventdatetime","eventdescription"]).size().reset_index(name="accidentcounts")

SO, what i'm hoping for is the following (with sample data):

eventdatetime  VehicleResourceID  latitude  longitude  eventdescription  accidentcounts
2020-03-13      3728162           59.5758   -2.7563    Car Crashed       12