liveBook · Manning

Panel data

As explained in Outlier Detection in Python

Panel data records multiple entities at multiple points in time, combining cross-sectional and temporal dimensions.

Panel data records multiple entities at multiple points in time, combining cross-sectional and temporal dimensions. Unlike cross-sectional data, it includes repeated observations; unlike ordinary time-series data, it follows multiple entities. section 17.1

A sales-and-purchases dataset illustrates the structure: multiple staff members make purchases at specific times. Irregular timestamps can be aggregated by entity and time period to create evenly spaced observations. section 17.1

From transactions to daily panels

Separate purchases and sales, index records by datetime, resample them by day, and combine the resulting columns for comparison over time.

How Outlier Detection in Python covers it

How deep it goes
Explains the structure, contrasts related data types, and shows aggregation for irregular timestamps.
Examples
Uses staff transactions with product identifiers, timestamps, purchases, sales, and daily aggregates.
What you can do after
Operate pandas resampling to aggregate irregular transaction records into daily time-indexed measures.
How it connects
Connects cross-sectional data, time-series data, longitudinal data, resampling, and aggregation.

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Outlier Detection in Python. The section links point to the parts of the book it draws on.