Docs
Browse Docs
Glossary

Wide format

A table layout in which repeated measurements of the same thing are spread across columns: one row per store, with a separate sales column for each month.

Wide tables are comfortable to read and awkward to analyze, because a value such as the month is held in the column names instead of in the cells. Each new month changes the shape of the table.

Where it comes up

  • Wide tables that should be longValues of one variable, such as months or years, are spread across the column headers instead of being stored in a column of their own.

See also

  • Long formatA table layout with one row per observation, in which a repeated measurement gets a row each time: one row for each store in each month.
  • PivotReshaping a table by turning the values of one column into new column headers, for example one row per store per month into one row per store with a column for each month.
  • Tidy dataA table layout in which each row is one observation, each column is one variable, and each cell holds one value.

Karg checks for many of these when it profiles a file, applies the fixes it is confident about, and sets the rest aside for your review. See how it works, or have our team clean your data for you.