Author Topic: Fuck dance, let's code  (Read 3155 times)

Sebastian Cobb

  • bad opinion haver
Re: Fuck dance, let's code
« Reply #120 on: October 14, 2020, 02:17:49 PM »
It could well be. I've mainly used it for joining different spreadsheets together, and have bad memories of having to do a lot of googling and try a lot of different ways to do "if date A from sheet 1 < date B from sheet 2, put "true" in new column C". So not stats at all, just R as a means to a particular end, and not a means I'd use again for the same purpose.

The comparison with int/dec is something I've misremembered but which happens in SSRS. I know you should be conscious of your types, but for fuck's sake don't give me an error if I try and do 2 * 2.5 rather than 2.0 * 2.5.
You know you can reference other workbooks in excel?

touchingcloth

  • Member
  • **
  • You wanna plack the rick, you ha.
Re: Fuck dance, let's code
« Reply #121 on: October 14, 2020, 03:07:52 PM »
You know you can reference other workbooks in excel?


Aye, but the use case was for SQL-y type joins and unions on multiple different data sources. It's stuff that might just've about been theoretically possible in Excel, but there were too many rows so it killed my PC.

I've learned to use Tableau Prep since and gone back to the same data I wrangled with R, and the thing is a fucking miracle, and within about half an hour of first picking it up I'd done what took me ages to get up to speed with R for.

Sebastian Cobb

  • bad opinion haver
Re: Fuck dance, let's code
« Reply #122 on: October 14, 2020, 03:11:41 PM »
Fair enough. I know fuck all about using Excel as a proper spreadsheet but I did have to maintain some reporting stuff that used vba libraries and hidden sheets to connect directly to db's and do queries.

I'm quite happy to pretend I know even less than I do if it means someone else has to do it tbh. Some of the customers I worked with could do way more powerful stuff in it than any of us techies ever worked out to do, but then we had other tools at our disposal I suppose.

touchingcloth

  • Member
  • **
  • You wanna plack the rick, you ha.
Re: Fuck dance, let's code
« Reply #123 on: October 14, 2020, 03:18:52 PM »
I'm going to try hard to forget I ever read this.

Ha. It was to get over some shortcomings of reporting from mailing software we use at work. They can give you a sends report, an opens report, a clicks report, but not all in the same output file and not for more than a single mailing at a time. R was essentially being used to recreate the software's database tables from spreadsheets due to not having any means to query the db directly.

Re: Fuck dance, let's code
« Reply #124 on: October 14, 2020, 05:58:01 PM »
All goes to show that coding, like dance, can be powerfully erotic.

Re: Fuck dance, let's code
« Reply #125 on: October 14, 2020, 06:31:41 PM »
Esther's next job could be in Auschwitz.

(she just doesn't know it yet)

touchingcloth

  • Member
  • **
  • You wanna plack the rick, you ha.
Re: Fuck dance, let's code
« Reply #126 on: October 14, 2020, 06:49:55 PM »
Note also that the £250-odd million they're generously giving out now is a fraction of the £1.57 billion they promised earlier in the year.

They haven't - yet - said that the remainder of the £1.57 billion is off the table. The £257 million is going to organisations who applied for grants of under £1 million, so organisations who applied for more are still waiting to hear what the fuck's going to happen.

Re: Fuck dance, let's code
« Reply #127 on: October 14, 2020, 07:42:38 PM »
Anyway, it should be encoding.

Dex Sawash

  • Silver Member
  • ****
  • Upphängningspunkterna
Re: Fuck dance, let's code
« Reply #128 on: October 15, 2020, 12:08:11 AM »
Odd that an esoteric dance sub-conversation hasn't broken out

Re: Fuck dance, let's code
« Reply #129 on: October 15, 2020, 01:15:51 PM »
Think the government is right about this: dancing should NOT be encouraged under ANY CIRCUMSTANCES.

touchingcloth

  • Member
  • **
  • You wanna plack the rick, you ha.
Re: Fuck dance, let's code
« Reply #130 on: October 15, 2020, 01:30:01 PM »
Think the government is right about this: dancing should NOT be encouraged under ANY CIRCUMSTANCES.

Agreed. What is wrong with standing by a wall holding a pint and nodding your head in time with the music like a sane person?

Tags: