Pivot table

How it is used

Best known from Excel and Google Sheets, but the same idea exists in pandas (pivot_table) and in some SQL dialects (PIVOT). You create or build a pivot table; to 'pivot' data means to turn rows into columns.

Example sentences

1. I made a quick pivot table of revenue by region and month.

2. Finance still checks our numbers with pivot tables in Excel.

Common collocations

• create a pivot table
• pivot table in Excel
• pivot the data
• pivot by month

Related terms

• aggregateTo combine many rows of data into summary values, such as totals, counts or averages, usually grouped by a category such as day, product or region.
• summary statisticsA small set of numbers that describe a dataset at a glance, such as the count, mean, median, minimum, maximum and standard deviation of each column.
• drill downTo move from a summary view to more detailed data, for example from yearly sales to monthly sales and then to single stores, in order to find the cause of a pattern.
• granularityThe level of detail in data, meaning what one row represents, for example one row per order, per customer per day or per store per month.

This word in other fields

The same English word can have a different meaning in another field:

• pivot table · Data Science & Analytics

More terms: Machine Learning and Data Processing

• artificial intelligence
• machine learning
• model
• dataset
• training data
• label
• train
• supervised learning
• neural network
• deep learning
• loss function
• overfitting