With the exception of absolutely NOT doing dates in 2-digit excel destroyable formats, we should try to update the csv to meet HHMI's request. I suggest we do dates as YYYY-MM-DD and label the header as date_YMD.
The requested renaming is as follows (and sample file attached - wtf github won't upload a csv?)
The csv should contain these columns
subject_id -> image_id
camera (remains the same)
longitude (remains the same)
latitude (remains the same)
dateutc -> date
month (remains the same)
year (remains the same)
season (remains the same)
time_period (remains the same)
veg_type (remains the same)
human_type -> human_structure
dist_humans_m -> distance_human_m
water_type (remains the same)
dist_water_m -> distance_water_m
species (remains the same)
most_likely_number_of_animals -> species_count
percentage_behaviour_resting -> percentage_resting
percentage_behaviour_standing -> percentage_standing
percentage_behaviour_moving -> percentage_moving
percentage_behaviour_eating -> percentage_eating
percentage_behaviour_interacting -> percentage_interacting
most_likely_are_there_any_young_present -> young_present
percentage_do_you_see_any_hornsyes -> horns
location -> image_url
With the exception of absolutely NOT doing dates in 2-digit excel destroyable formats, we should try to update the csv to meet HHMI's request. I suggest we do dates as YYYY-MM-DD and label the header as date_YMD.
The requested renaming is as follows (and sample file attached - wtf github won't upload a csv?)
The csv should contain these columns subject_id -> image_id camera (remains the same) longitude (remains the same) latitude (remains the same) dateutc -> date month (remains the same) year (remains the same) season (remains the same) time_period (remains the same) veg_type (remains the same) human_type -> human_structure dist_humans_m -> distance_human_m water_type (remains the same) dist_water_m -> distance_water_m species (remains the same) most_likely_number_of_animals -> species_count percentage_behaviour_resting -> percentage_resting percentage_behaviour_standing -> percentage_standing percentage_behaviour_moving -> percentage_moving percentage_behaviour_eating -> percentage_eating percentage_behaviour_interacting -> percentage_interacting most_likely_are_there_any_young_present -> young_present percentage_do_you_see_any_hornsyes -> horns location -> image_url
wildcam_sample_csv.xlsx