Hi everyone,
New user - love this program so far. I have a few questions about the context of this challenge (and really any challenge):
I notice that there are (to be expected) some data anomalies - nulls in the start and/or finish times, finish times that are < the beginning times, etc. Are we to regard these data points as useless in the grand scheme of things? For instance, they don't tell me much of anything if I'm the university analyst - at the very least I know what time classes start or end or maybe neither - and therefore we can't tell the difference in minutes. If the start time > end time in military format, we have a negative class length (in minutes) and honestly the entire data point becomes nonsensical in terms of practical use for the university analyst because we no longer know if that entry was even entered correctly.
As a data analyst/engineer (the one providing this service to the university analyst who actually needs the information to act on) - what is the best practice in terms of these instances? Should we simply treat them as they exist and instead focus on building a process that caters to the sensical data points and just handle the nonsensical data records so as to not create errors when it comes to format conversion or formula work?
Thanks so much!
-Kyle
