CHAPTER 7Data Preparation
So far, we have seen semantics utilized within visualizations. These depictions rely on data that is ready to analyze. Drawing from the data literacy circle in the previous chapter (Figure 6.1), data preparation is a meaning-centered exercise to prepare, clean, and curate data. As we clean, we think about how the data should be structured to support the analysis: we make it taller or wider, thus giving it shape and defined fields. Whether it's from large transaction databases, JSON files downloaded from APIs, or CSV outputs from shared data repositories, defining useful data formats requires logic that often includes understanding what the data is intended to mean.
We all know the pains of poorly shaped data. During analysis, we spend our time creating calculations, building additional outside workflows, or sacrificing depth within the analysis. We may instead rely on writing to make the connections rather than the analysis itself. The connections must then be inferred rather than made tangible in the analysis. Poorly shaped data is the dresser that wobbles and ultimately breaks down. It is the chest of drawers where you slam your fingers over and over again and can't pinpoint why.
While preparation is invisible to those consuming visualizations, a well-shaped and cleaned dataset makes all the difference in analyzing the data. Data preparation is the back of the dresser and the interior supports. It holds everything together. A well-made dresser is ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access