datatable
Posts featuring data.table.
Pivoting data in R with tidyr and data.table
How to pivot data in R with data.table and tidyr. Examples of melt, dcast, pivot_longer and pivot_wider Continue reading Pivoting data in R with tidyr and 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
Ways to combine multiple excel workbooks into one dataframe, using purrr, data.table, rio and base R. Continue reading Well Well Well my Excel
Cutting down code in dplyr and data.table
Optimising code in data.table and tidyverse. 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
Combining elements from different rows while discarding NA values Continue reading Solving small data problems with data.table
patientcounter
Introducing the patientcounter package to create census tables without crashing Excel, and no need for SQL 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 starter guide to the fabulous data.table package. An introduction to data.table for new users. Continue reading data.table by a dummy - a dummies guide
