Scaffolding in 3 Min

Scaffolding is the art of adding rows to your dataset. Why would you want to do this?

Imagine you had a new years resolution to work out every day for January. You kept track of the days you worked out - like this!

Dates you worked out

Now you want to build a chart to find out how many days you missed, and scaffolding can help you do that!

First, add a column to distinguish between the rows you added and the rows you currently have.

New Column '1' is set to 1, meaning it was in the original dataset

Now add rows for every date of January, and assign a value of 0 to the '1' column:

Snippet of final table in red box

By doing this, you can make charts that track some of the data that was not present in the original dataset:

Days worked out/skipped in January by counting the number of rows grouped by the '1' column

Of course, there are many more use cases for scaffolding, but this was just a quick overview of why adding rows to your dataset could be useful!

Author:
Tomo Mensendiek
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2026 The Information Lab