From the course: Data Analysis with Python and Pandas

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Shifting time series

Shifting time series

From the course: Data Analysis with Python and Pandas

Start my 1-month free trial Buy for my team

Shifting time series

“

- [Instructor] We can shift a series by a specified number of rows using the shift method. And note that this will work with non-time series columns and non-time series data. This is particularly helpful in working with time series to compare values against previous periods. So here we have our dates series. We have a bunch of dates in our index, and then we have sales values in our series. If we shift this series without an argument passed, we will shift this series down by one. So our value on January 1st is now on January 2nd. Our value on January 2nd is now on February 1st, and so on. We'll shift this entire series down by one row. If we wanted to shift back one row, we could use shift negative one. And so this will shift forward by one row by default, but we can specify any positive or negative integer to shift the series by. And so here's an example of using shift to calculate a growth rate. We're dividing our sales by the sales in the prior row. We're subtracting one…

Contents