Auerbach-Lab / Behavior-autoanalysis

Rat behavioral assay data curation and validation
1 stars 0 forks source link

Date sorting is not working in supervisor-summerize #15

Closed nohelix closed 1 year ago

nohelix commented 1 year ago

Example: GP4

Task (Filter) Detail (Filter)    
Reset   01/04/2023 2
Rxn   01/30/2023 9
TH   01/27/2023 7
Training   01/31/2023 3
       
    Date Filename
Reset None Overall Averages
Rxn Alone Overall Averages
TH Alone Overall Averages
Training Alone Overall Averages
TH Alone 12/21/2022 16kHz_15-75dB_50ms_8s
Training Alone 01/31/2023 8kHz_30-90dB_50ms_8s
Rxn Alone 01/30/2023 32kHz_30-90dB_50ms_8s
Rxn Alone 01/28/2023 32kHz_30-90dB_50ms_8s
tofof commented 1 year ago

There is probably very little that can be done about this as it's a consequence of the date strings being strings, not dates.

tofof commented 1 year ago

We might be able to manually examine the contents of the table that gets appended together and resort the rows using our own sorting function that interprets dates correctly, but sorting within Excel would still be broken.