It’s almost 2 weeks since I had my first package successfully submitted to CRAN. The runcharter package is special to me for lots of reasons - it was a tough problem to crack, and it’s one I’ve worked on with a variety of tools over the year... [Read more...]

[Read more...]

[Read more...]

[Read more...]

I wanted to try and create some parameters in my flexdashboard script, so I could extract data from our warehouse over a flexible date range. In SQL Server, I’d create a variable and reference it like this: DECLARE @ndays int SET @ndays = -... [Read more...]

[Read more...]

I saw a question on reddit today which can be answered using {patientcounter} The asker wants to know how to work out how many folk are in a hotel, at any given time, based on check in and check out dates. Here’s the setup: check_in_date &... [Read more...]

Importing multiple excel files (not sheets, but files) and flattening into one data frame / tibble / data.table should be straightforward - shouldn’t it? How many ways can there be? What are the pros and cons of each? I’ve made three copies... [Read more...]

Importing multiple excel files (not sheets, but files) and flattening into one data frame / tibble / data.table should be straightforward - shouldn’t it? How many ways can there be? What are the pros and cons of each? I’ve made three copies... [Read more...]

After a very long , R free hiatus (I don’t recommend it) I’m back on the R train, destination unknown. I had a bit of spare time last night, and remembered I had not done a PreppinData challenge for a while. In fact, the last one I did was ... [Read more...]

After a very long , R free hiatus (I don’t recommend it) I’m back on the R train, destination unknown. I had a bit of spare time last night, and remembered I had not done a PreppinData challenge for a while. In fact, the last one I did was ... [Read more...]

Back once again with the block rocking themes! Yes, having produced a set of R colour palettes based on Metallica album covers, and then another set of palettes based (loosely) on classic rock album covers, I’ve decided to complete the set w... [Read more...]

[Read more...]

I’ve been using data.table quite a lot in my spare time, and I want to make a few notes of some things I’ve learned along the way. I would say I’m no longer a beginner, not yet an expert, but getting there.. As noted in a ... [Read more...]

I’ve been using data.table quite a lot in my spare time, and I want to make a few notes of some things I’ve learned along the way. I would say I’m no longer a beginner, not yet an expert, but getting there.. As noted in a ... [Read more...]

[Read more...]

[Read more...]

Why you should know about it - What does coalesce mean? In the English language, it is generally used to convey a coming together, or creating one whole body, mass or system. How does that help us when working with data? We spend a lot of ti... [Read more...]

What does coalesce mean? In the English language, it is generally used to convey a coming together, or creating one whole body, mass or system. How does that help us when working with data? We spend a lot of time cleaning our data, surely th... [Read more...]

The NHS-R Community site prompted this post, specifically a question to the help-with-r channel on Slack. Someone asked about obtaining unique values in a 60M row / 6 column dataset. Naturally, data.table came up, and a few of us made sugg... [Read more...]