no coronavirus thread ?

Open discussion about any topic, as long as you abide by the rules of course!
Don Carlos
Posts: 17508
Joined: Thu Jan 01, 1970 12:00 am

Re: no coronavirus thread ?

Post by Don Carlos »

Big day!
User avatar
Eraser
Posts: 19168
Joined: Fri Dec 01, 2000 8:00 am

Re: no coronavirus thread ?

Post by Eraser »

My country is doing really shitty right now. The government is fucking up in many areas.

For instance, there is a crushing shortage in testing capacity. I have been having a sore throat and runny nose the past couple of days, but getting tested for COVID is pretty much impossible right now. Yesterday when I checked, the only available spot would be next Tuesday, at 6pm in a city that's about 80 minutes driving from where I live. Today I checked again, and there were no available spots at all. It's ridiculous. I don't really have to be anywhere, so I'm just staying at home, but something needs to change here.
User avatar
seremtan
Posts: 36007
Joined: Wed Nov 19, 2003 8:00 am

Re: no coronavirus thread ?

Post by seremtan »

look on the bright side though: no one outside your country cares what goes on there, so you avoid all the bad publicity
User avatar
Eraser
Posts: 19168
Joined: Fri Dec 01, 2000 8:00 am

Re: no coronavirus thread ?

Post by Eraser »

Yes, otherwise you get things like these :olo:
[tweet]https://twitter.com/maxcroser/status/1313046638915706880[/tweet]
User avatar
Κracus
Posts: 5969
Joined: Tue Oct 16, 2007 12:38 am

Re: no coronavirus thread ?

Post by Κracus »

lol, who needs to pay someone to manage a database when we can just use excel!?
Don Carlos
Posts: 17508
Joined: Thu Jan 01, 1970 12:00 am

Re: no coronavirus thread ?

Post by Don Carlos »

:olo:

Fuck me...I live in a country run by absolute mongos
User avatar
Eraser
Posts: 19168
Joined: Fri Dec 01, 2000 8:00 am

Re: no coronavirus thread ?

Post by Eraser »

Best thing is, the solution was not to migrate to a decent database, no, they moved part of the data to a new excel sheet so they've got plenty of rows columns left :tard:
xer0s
Posts: 12446
Joined: Sat Feb 10, 2001 8:00 am

Re: no coronavirus thread ?

Post by xer0s »

Don Carlos wrote::olo:

Fuck me...I live in a country run by absolute mongos
Better than a country run by mangos...

[lvlshot]https://ih1.redbubble.net/image.1184011365.6735/flat,750x,075,f-pad,750x1000,f8f8f8.u1.jpg[/lvlshot]
Last edited by xer0s on Mon Oct 05, 2020 6:56 pm, edited 1 time in total.
User avatar
Eraser
Posts: 19168
Joined: Fri Dec 01, 2000 8:00 am

Re: no coronavirus thread ?

Post by Eraser »

Don Carlos wrote::olo:

Fuck me...I live in a country run by absolute mongos
lol, at my company, we actually run the software we build on a database named MongoDB, which is a very high performance database system :)
xer0s
Posts: 12446
Joined: Sat Feb 10, 2001 8:00 am

Re: no coronavirus thread ?

Post by xer0s »

[lvlshot]https://pbs.twimg.com/profile_images/886310716579303425/fJqKWCK8_400x400.jpg[/lvlshot]
User avatar
seremtan
Posts: 36007
Joined: Wed Nov 19, 2003 8:00 am

Re: no coronavirus thread ?

Post by seremtan »

Eraser wrote:Yes, otherwise you get things like these :olo:
*tweet*
on a related note, the csv used to power the Johns Hopkins dashboard is structured with dates (at the day level) as column headers, with countries in rows (and to make matters worse, the daily case values are running totals, not daily counts). at end of sept, the righthand-most column in the dataset was IV :dork: this means that to do any viz oneself (i.e. in Tableau or PowerBI or whatever) you have to pivot the date columns, then add new date columns to the pivot every time you update your own copy from Github (and fix the date column because they didn't use the right format :mad: )

as someone who works in data and data viz, this imho this is really shit practice. they only need three columns: date, country, cases. Excel has way more rows than columns available
User avatar
Whiskey 7
Posts: 9697
Joined: Sat Jul 21, 2001 7:00 am

Re: no coronavirus thread ?

Post by Whiskey 7 »

Where are we at I wonder?

Cases worldwide

19 September 30,697,734

28 September 33,297,042

10 October 37,121,450

Total deaths
• World 1,072,852
• USA 218,648
• Brazil 149,692
• India 107,450

Source #1 Source #2
[color=#FFBF00]Physicist [/color][color=#FF4000]of[/color] [color=#0000FF]Q3W[/color]
Don Carlos
Posts: 17508
Joined: Thu Jan 01, 1970 12:00 am

Re: no coronavirus thread ?

Post by Don Carlos »

Strong numbers
User avatar
seremtan
Posts: 36007
Joined: Wed Nov 19, 2003 8:00 am

Re: no coronavirus thread ?

Post by seremtan »

Eraser wrote:Yes, otherwise you get things like these :olo:
also, Excel maxes out at 16,384 columns. even with a column per day since the first case there should still be plenty left over

were they using a column per hour? minute? wtf?
User avatar
Eraser
Posts: 19168
Joined: Fri Dec 01, 2000 8:00 am

Re: no coronavirus thread ?

Post by Eraser »

seremtan wrote:
Eraser wrote:Yes, otherwise you get things like these :olo:
also, Excel maxes out at 16,384 columns. even with a column per day since the first case there should still be plenty left over

were they using a column per hour? minute? wtf?
Famous (only slightly) mathematician Matt Parker explains it very well in this video:
https://www.youtube.com/watch?v=zUp8pkoeMss

For some reason he poured it into some faux news reporting shape for comedic purposes, which distracts a bit from the issue at hand, so I'll give you the quick rundown:

- The claim that columns maxed out is unsubstantiated. The BBC reported this, but hasn't been verified.
- What is known is that an older version of the Excel file format was used (the pre-Office 2007 .xls format), which caps its number of rows at 65,536 (versus 1,048,576 for Office 2007's .xlsx).
- It turns out one case of COVID used more than one row. Official reports say that there was room for about 1400 cases which means there were about 46 or 47 rows per case.
- Because each case had a variable number of rows, it took a long time before someone noticed something was off.
User avatar
seremtan
Posts: 36007
Joined: Wed Nov 19, 2003 8:00 am

Re: no coronavirus thread ?

Post by seremtan »

the part where someone was using columns as rows was especially lolworthy

that said, general understanding of how data ought to be structured is thin on the ground even among people who you'd expect to know better. i've lost count of the number of times i've been asked to build visualisations of datasets in Tableau only to find i have to restructure their shitty clusterfuck of a dataset before i can even start :|
HM-PuFFNSTuFF
Posts: 14375
Joined: Thu Mar 01, 2001 8:00 am

Re: no coronavirus thread ?

Post by HM-PuFFNSTuFF »

xer0s
Posts: 12446
Joined: Sat Feb 10, 2001 8:00 am

Re: no coronavirus thread ?

Post by xer0s »

Interesting. These super spreader events are the real problem. I can now envision all these Italians sitting down for family meals, screaming at each other from across the table as meatballs crumbs and Covid particles fly through the air...
scared?
Posts: 20988
Joined: Fri Mar 02, 2007 1:28 pm

Re: no coronavirus thread ?

Post by scared? »

Racist pos... I'm half Italian... Southern poverty law center called...
HM-PuFFNSTuFF
Posts: 14375
Joined: Thu Mar 01, 2001 8:00 am

Re: no coronavirus thread ?

Post by HM-PuFFNSTuFF »

scared? wrote:Racist pos... I'm half Italian... Southern poverty law center called...
you're half balled :olo:
scared?
Posts: 20988
Joined: Fri Mar 02, 2007 1:28 pm

Re: no coronavirus thread ?

Post by scared? »

Lol nope...
User avatar
seremtan
Posts: 36007
Joined: Wed Nov 19, 2003 8:00 am

Re: no coronavirus thread ?

Post by seremtan »

scared? wrote:Racist pos... I'm half Italian... Southern poverty law center called...
"hello, SPLC? i'd like you to call someone an extremist then get sued for defamation and lose millions of $$$. thanks bye"
dekayd
Posts: 218
Joined: Mon Jan 15, 2001 8:00 am

Re: no coronavirus thread ?

Post by dekayd »

scared? wrote:Racist pos... I'm half Italian... Southern poverty law center called...

So you are half Italian half Moron, got it :olo:
User avatar
Captain
Posts: 20410
Joined: Thu Jan 05, 2006 2:50 am

Re: no coronavirus thread ?

Post by Captain »

So full Italian then :olo:
Pext
Posts: 4257
Joined: Thu Aug 28, 2003 7:00 am

Re: no coronavirus thread ?

Post by Pext »

Captain Mazda wrote:So full Italian then :olo:
Mama mia! :olo:
Post Reply