Skip to main content

Time Series in DataFrames

Time is a first class entity in SQL Frames. Many datetime string formats are automatically recognized and converted to the appropriate DateTime or Date field while processing the input. In addition, there are API to extract the various components of a datetime field and then perform data transformations such as aggregation by year or quarter.

There are two main API related to time. Time is a static class providing access to utility API such as creating time component calculations or data types. There is also a time plugin accessible as df.time providing DataFrame instance level API for dealing with time.