data.table
Posts about data.table.
modifying columns in datatable with lapply
How to modify or update multiple columns in rdatatable with lapply and SDcols Continue reading modifying columns in datatable with lapply
Calculating hotel occupancy with R
Putting patientcounter to the test by calculating hotel occupancy. Continue reading Calculating hotel occupancy with R
Well Well Well my Excel
I’m fed up forgetting how to combine lots of excel workbooks into one dataframe, so I’m documenting several ways of doing it, using purrr, data.table, rio and base R. Continue reading Well Well Well my Excel
Cutting down code in dplyr and data.table
Do we have to sacrifice readability for brevity? data.table allows succinct code, but so does tidyverse. data.table has some extra tricks up it’s sleeve though. Continue reading Cutting down code in dplyr and data.table
Some data.table tips
Rolling joins, wrapping functions around regular DT[] calls, and more. Continue reading Some data.table tips
PreppinData - accepting the challenge with R and PowerBI
I’ve completed a month of ‘PreppinData’ challenges, using both R and PowerBI. Some things have been easy, some have not - here’s what I’ve learned in Week 1 Continue reading PreppinData - accepting the challenge with R and PowerBI
collapse might rock your world
collapse is a new force in the data transformation stakes. In this post, I try out one simple function and compare it to data.table and dplyr Continue reading collapse might rock your world
Solving small data problems with data.table
Friday afternoon fun - how do we do we filter this data, combining elements from different rows and discarding NA values? Continue reading Solving small data problems with data.table
patientcounter
Introducing the patientcounter package for counting how many patients are in hospital at any point in time Continue reading patientcounter
Programming with data.table
getting started with multiple bare variable names in data.table functions. Continue reading Programming with data.table
data.table by a dummy - a dummies guide
A dummies guide to the fabulous data.table package, for new users to get up to speed quickly Continue reading data.table by a dummy - a dummies guide
