Mastering pandas - Second Edition

Summary

In this chapter, we discussed time series data and the steps you can take to process and manipulate it. A date column can be assigned as an index for Series or DataFrame and can then be used for subsetting them based on the index column. Time series data can be resampled—to either increase or decrease the frequency of the time series. For example, data generated every millisecond can be resampled to capture the data only every second or can be averaged for 1,000 milliseconds for each second. Similarly, data generated every minute can be resampled to have data every second by backfilling or forward filling (filling in the same value as the last or next minute value for all the seconds in that minute).

String to datetime conversion ...