datatable
Posts about or featuring the awesome data.table package
The life changing magic of tidying text files
Bringing order to irregularly structured open data CSV files - with R, of course Continue reading The life changing magic of tidying text files
new programming with data.table
baby steps creating handy functions with the new data.table programming interface Continue reading new programming with data.table
more .I in data.table
using .I and .N to retrieve the correct combination of records from grouped data Continue reading more .I in data.table
.I in data.table
A quick note to understand what .I does in data.table Continue reading .I in data.table
non-equi joins in data.table
A quick note to understand (non-equi) joins in data.table Continue reading non-equi joins in 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 from scratch - a dummies guide
An introduction to data.table from scratch for beginners or new users. Continue reading data.table from scratch - a dummies guide