News for hackers. Stuff that matters.
Re:Missing Covid-19 test data was caused by the ill-thought-... by ajsnigrutin on Monday October 05, 2020 @06:49AM (#24686434)
Once you have a couple of thousands of rows in excell files, one file per day, possibly one per testing center.... possibly with inconsistent structure.... non standard date formats (even different in each row),... add to this the inconsistent namings ("Tested at" column with data: "Testing center 1, London", "TC1, London", "TC1 London", "TC1 LONDON",....), etc...

Yes, anything-sql or whatever would be better, but deciding between putting all the data into sql by hand, or "uhm... i'll think of something and do it tomorrow", me, being lazy, I'd pick the second option,...

...until i'd get shamed on here. Maybe even a few days after.

Re:Missing Covid-19 test data was caused by the ill-thought-... by hdjdbtbgwjsn on Monday October 05, 2020 @07:34AM (#24686676)
Cleaning data is a major part of data engineering there are plenty of professionals capable of helping with this task.