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
In the example below, we have applied the 'Summary' option to a few columns.
Last updated