Summarize Column

The Summary option provides a concise overview of column values, allowing you to quickly access essential information and make informed decisions.

Let us assume you're working with a large dataset and need to review any column to identify aspects such as the number of missing entries, unique entries, or to perform a simple categorization analysis. You might want to determine the earliest and latest dates in your data, or you may need to calculate the range, average, median, or standard deviation of the column data.

The Summary option enables you to efficiently perform all these tasks and gather useful insights. Here are some details you can obtain:

• Number of empty entries/percentage of empty entries

• Number of filled-in entries/percentage of filled-in entries

• Number of unique entries/percentage of unique entries

• Earliest and the most recent date in a date column

• Date range in days or months

• Minimum value, maximum value and range

• Sum

• Average

• Median

• Standard deviation

Summary

In the example below, we have applied the 'Summary' option to a few columns.

Column Summary