Process Length Groups for Fish Over 100cm
process_over100_length_groups.RdExtracts and processes length data for large fish (over 100cm) from KoBoToolbox survey data. These are stored in separate repeated group structures outside the main species_group.
Value
A data frame with columns: submission_id, n_catch, length_range, length_over, count Returns NULL if no over-100cm length group data is found
Details
Length groups for fish over 100cm are stored separately from the main species_group structure, in columns following the pattern: species_group/no_fish_by_length_group_100/fish_length_over100
The function:
Identifies columns matching the over-100cm pattern
Pivots them to long format
For fish_length_over100 entries, extracts the actual length value
Links this data back to the corresponding species group via submission_id
Assigns new n_catch values to avoid conflicts with existing species groups