how to add eventIDs to your occurrences file

Thus far, we have only talked about setting up events and occurrence files individually. However, they need to be linked by a common key so we know which occurrences were seen at which event. Thus, we will link them via the eventID column.

This step assumes that you have set up both your occurrence and event dataframes using the previous tutorials. If you haven’t, in the dropdown menu is the code for your perusal.

Code for occurrences and events thus far

>>> my_dwca.use_events(dataframe=events,
...                    eventType='type',
...                    samplingProtocol='Observation',
...                    Event='name',
...                    event_hierarchy={1: "Site Visit", 2: "Sample", 3: "Observation"})
... my_dwca.occurrences['Latitude'] = pd.to_numeric(my_dwca.occurrences['Latitude'],errors='coerce')
... my_dwca.occurrences['Longitude'] = pd.to_numeric(my_dwca.occurrences['Longitude'],errors='coerce')
>>> my_dwca.use_datetime(check_event=True,
...                      dataframe=events,
...                      eventDate='date',
...                      string_to_datetime=True,
...                      yearfirst=False,
...                      dayfirst=True)
>>> my_dwca.use_occurrences(dataframe=occ,
...                         basisOfRecord='HumanObservation',
...                         occurrenceStatus='PRESENT',
...                         occurrenceID=True)
>>> my_dwca.use_scientific_name(dataframe=occ,
...                             scientificName='Species')
>>> my_dwca.use_coordinates(dataframe=occ,
...                         decimalLatitude='Latitude',
...                         decimalLongitude='Longitude',
...                         geodeticDatum='WGS84',
...                         coordinatePrecision=0.1)
>>>  my_dwca.use_datetime(dataframe=occ,
...                       eventDate='Collection_date',
...                       string_to_datetime=True,
...                       yearfirst=False,
...                       dayfirst=True)

galaxias can automatically link your eventID’s in your events file to the occurrences by comparing whether or not the date in the eventDate column is the same. What this looks like in principle is supplying three arguments:

• add_eventID: set this to True if you want galaxias to automatically add ``eventID``s

• events: provide the events dataframe containing the ``eventID``s to link.

• eventType: specify the eventType that you want to link to the occurrences. In this case, 'Observation' is the appropriate term.

The command will then look like this (using one of the commands in the dropdown as a template)

>>> my_dwca.use_occurrences(add_eventID=True,
...                         occurrenceStatus='PRESENT',
...                         occurrenceID=True,
...                         add_eventID=True,
...                         events=events,
...                         eventType='Observation')
>>> my_dwca.occurrences.head()

Traceback (most recent call last):
  File "/Users/buy003/Documents/GitHub/galaxias-python/docs/source/galaxias_user_guide/longitudinal_studies/events_workflow.py", line 104, in <module>
    my_dwca.set_events(eventType='type',
  File "/Users/buy003/anaconda3/envs/galaxias-dev/lib/python3.11/site-packages/galaxias/dwca_build.py", line 633, in set_events
    self.events = corella.set_events(dataframe=self.events,eventID=eventID,parentEventID=parentEventID,
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/buy003/anaconda3/envs/galaxias-dev/lib/python3.11/site-packages/corella/set_events.py", line 117, in set_events
    dataframe=generate_eventID_parentEventID(dataframe=dataframe,event_hierarchy=event_hierarchy,
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/buy003/anaconda3/envs/galaxias-dev/lib/python3.11/site-packages/corella/generate_eventID_parentEventID.py", line 36, in generate_eventID_parentEventID
    new_dataframe = add_unique_IDs(dataframe=new_dataframe,column_name='eventID',
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/buy003/anaconda3/envs/galaxias-dev/lib/python3.11/site-packages/corella/add_unique_IDs.py", line 110, in add_unique_IDs
    raise ValueError("Please specify whether or not you want a random ID, sequential ID or composite ID.")
ValueError: Please specify whether or not you want a random ID, sequential ID or composite ID.