Missing Covid-19 test data was caused by the ill-thought-out use of Excel

Re:Missing Covid-19 test data was caused by the ill-thought-... by tomc1985 on Monday October 05, 2020 @09:23PM (#24693905)

Indeed, you have to manually inspect results to verify correctness. If you're lucky maybe your error will result in one of those weird error values being shown instead, but way too often that is not the case

Not to mention that complex formulae are still usually expressed as a bunch of gobbledygook in the cell value textbox, which is about as easy to parse as minified Javascript. And that's to technical users like ourselves.

[ Parent | on HN ]

Re:Missing Covid-19 test data was caused by the ill-thought-... by logicOnly on Monday October 05, 2020 @09:56PM (#24694082)

I had Excel error out when I tried to open 10 million rows.

[ Parent | on HN ]

Re:Missing Covid-19 test data was caused by the ill-thought-... by sueders101 on Monday October 05, 2020 @10:10PM (#24694135)

Excel tops out a little more over a million rows without specifically handling of larger files. I’m not sure excusing it, just a heads up to all the junior analysts out there who haven’t dealt with the problem(not implying you’re a junior analyst, just wanted to point something out to those who aren’t familiar with the issue).

[ Parent | on HN ]

Re:Missing Covid-19 test data was caused by the ill-thought-... by logicOnly on Tuesday October 06, 2020 @07:53AM (#24696742)

No worries, Excel is nice for small/medium sized data and has the UI/Visualization which is nice.

The story I mentioned was because I wanted to look at the data before I started parsing it. I had full expectations to use either sqlite or Pandas.

[ Parent | on HN ]