Some events occur more often at certain times of the year, for example, recruitment rates increase after Christmas and slow down toward the summer holidays in Europe. Businesses and organizations want to evaluate performance and objectives at regular intervals throughout the year, for example, at every quarter or every semester. Therefore, deriving these features from a date variable is very useful for both data analysis and machine learning. In this recipe, we will learn how to derive the year, month, quarter, and semester from a datetime variable using pandas and NumPy.
Deriving representations of the year and month
How to do it...
To proceed with the recipe, let's import the libraries and create a toy dataset:
- Import...