Instruction: Provide an example of how you would use window functions in Pandas for computing rolling statistics.
Context: Evaluates the candidate's expertise in using Pandas for advanced data analysis tasks, specifically in the context of time series data.
Official answer available
Preview the opening of the answer, then unlock the full walkthrough.
First, to clarify our grounds, rolling statistics are calculations performed over a specified window of data points in a series, which then "rolls" across the data with each calculation based on the current window. This is immensely useful in smoothing out short-term fluctuations and highlighting longer-term trends or cycles.
Assume we're working with a time series dataset, such as daily temperatures over several years. Our goal is to compute a 7-day moving average of temperature to analyze weekly patterns or trends. In this scenario, our "window" is 7 days....
medium
medium
hard
hard
hard