Day: October 28, 2020

The ultimate R data.table cheat sheet

Read in CSV file Import mydt <- fread(“myfile.csv”) myt <- read_csv(“myfile.csv”) #OR
myt <- vroom::vroom(“myfile.csv”) Import the first x number of rows of a CSV file Import mydt_x <- fread(“myfile.csv”, nrows = x) myt_x <- read_csv(“myfile.csv”, n_max = x) Import only those rows from a CSV file that match a certain pattern Import mydt_pattern <- fread(“grep ‘mypattern’ myfile.csv”) myt_pattern <- vroom::vroom(pipe(“grep ‘mypattern’ myfile.csv”)) Import a .gz compressed file Import mydt <- fread(“myfile.gz”) myt <- vroom::vroom(“myfile.gz”) Import a.zip compressed file import mydt <- fread(cmd = ‘unzip -cq myfile.zip’) myt <- read_csv(“myfile.zip”) Create data table from existing data frame (tibble for tidyverse)
Read More

Building a hybrid SQL Server infrastructure

The geographic distribution of cloud data centers makes it easy to configure SQL Server instances for high availability (HA) and/or disaster recovery (DR), but what good is that to you if you’re already invested in a well-tuned SQL Server system that’s firing away on all cylinders on-premises? The idea of ensuring higher levels of availability or easily adding a disaster recovery site may sound very attractive, but the thought of moving everything into the cloud to achieve those ends may give rise to cold sweats and nightmares.

But here’s the thing: The cloud is not an all-or-nothing proposition. You can

Read More

Download InfoWorld’s ultimate R data.table cheat sheet

If you saw our Ultimate R data.table Cheat Sheet, you might want a copy of your own. And in fact you can download an HTML file with the full interactive table — complete with tasks, task category, data.table code, and Tidyverse alternatives, all searchable.

This download is free for all registered Insiders — and Insider membership is also free.

We ask that once you download it, you don’t share the file; please share the link to the article instead. As a data afficionado, you can probably understand that the number of registrations for this download is one way I

Read More

I loved the PlayStation 5’s design — until I saw it in my house

The time has finally come: we’re able to do our first hands-on inspection of the PlayStation 5, and to see what it looks like in the wild. And as a staunch defender of this console’s form factor pre-release, I have to say that seeing it in my home… has made me change my mind.

I’m on record calling the PS5 “gorgeous” when I first saw pictures of it. I was (and still am) really tired of consoles looking like interchangeable black boxes and thought the curvy outline of the white panels was refreshing. I still think the color — or

Read More