Excel’s Limitation Caused Loss of 16,000 Positive COVID Cases. And 50,000 potentially infectious people missed by tracers and not told to self-isolate
If you open an Excel file and scroll to the bottom (tip: CTRL + south arrow) you’ll find out it ends at 1,048,576. Not a single row more.
This limitation was blamed by Public Health England for the loss of 15,841 positive COVID test results, as reported by The Guardian¹. In turn, following the estimate that each non-complex case has 3 close contacts, it leads to at least 47,000 potentially infectious people not being informed and required to self-isolate, and potentially be traced. This figure can rise beyond 50,000 as it was reported² that a minority of the 15,841 missing positive cases were complex, i.e. from environments such as hospitals, prisons, homeless shelters, which have 7 close contacts on average.
The Public Health England (PHE) organization collects public and private lab results. As reported by The Guardian, one lab had sent its daily test report to PHE as a CSV document. PHE is then consolidating the results in Excel for the lab, alongside the results received from other labs. The organization would then be reporting the official figures and doing the follow-up on tracing and informing individual positive cases. Yet, it seems the lab at hand was already within the 1 million+ rows within PHE’s datasheet. The addition of yet another daily batch led to some results being truncated, and hence not reported and acted upon.
Data Science and Analytics market evolves to adapt to the constantly changing economic and business environments. Our latest survey report suggests that as the overall Data Science and Analytics market evolves to adapt to the constantly changing economic and business environments, data scientists and AI practitioners should be aware of the skills and tools that the broader community is working on. A good grip in these skills will further help data science enthusiasts to get the best jobs that various industries in their data science functions are offering.
The agenda of the talk included an introduction to 3D data, its applications and case studies, 3D data alignment and more.
Become a data analysis expert using the R programming language in this [data science](https://360digitmg.com/usa/data-science-using-python-and-r-programming-in-dallas "data science") certification training in Dallas, TX. You will master data...
Understand how data changes in a fast growing company makes working with data challenging. In the last article, we looked at how users view data and the challenges they face while using data.
Need a data set to practice with? Data Science Dojo has created an archive of 32 data sets for you to use to practice and improve your skills as a data scientist.