Right now the schedule is downloaded from smartsheet and saved as a csv. Then loaded into the GUI as a pandas table.
This process is delicate in that types of columns sometimes change. For example, mouse IDs should be ints, but if a specific row has a string, then pandas converts the whole columns to strings.
Possible solutions
- Forced casting of columns to specific types
- A pydantic model to ensure input is valid
Right now the schedule is downloaded from smartsheet and saved as a csv. Then loaded into the GUI as a pandas table.
This process is delicate in that types of columns sometimes change. For example, mouse IDs should be ints, but if a specific row has a string, then pandas converts the whole columns to strings.
Possible solutions