Python: Datetime to season

by

You can use a simple mathematical formula to compress a month to a season, e.g.:

>>> [month%12 // 3 + 1 for month in range(1, 13)]
[1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4, 1]

So for your use-case using vector operations (credit @DSM):

>>> temp2.dt.month%12 // 3 + 1
1    3
2    3
3    3
4    4
5    4
6    4
7    4
8    4
Name: id, dtype: int64

More Related Contents:

  1. Filtering Pandas DataFrames on dates
  2. Keep only date part when using pandas.to_datetime
  3. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  4. How to print pandas DataFrame without index
  5. datetime dtypes in pandas read_csv
  6. How to convert string to datetime format in pandas python?
  7. pandas dataframe groupby datetime month
  8. Find the end of the month of a Pandas DataFrame Series
  9. Pandas: Subtracting two date columns and the result being an integer
  10. How to change the datetime tick label frequency for matplotlib plots
  11. Converting between datetime and Pandas Timestamp objects
  12. Splitting timestamp column into separate date and time columns
  13. Pandas: Datetime Improperly selecting day as month from date [duplicate]
  14. Pandas converting row with unix timestamp (in milliseconds) to datetime
  15. Python pandas convert datetime to timestamp effectively through dt accessor
  16. Specifying date format when converting with pandas.to_datetime
  17. Which is the fastest way to extract day, month and year from a given date?
  18. In Pandas how do I convert a string of date strings to datetime objects and put them in a DataFrame?
  19. Locate first and last non NaN values in a Pandas DataFrame
  20. Datetime conversion – How to extract the inferred format?
  21. pd.to_datetime is getting half my dates with flipped day / months
  22. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  23. Convert a column of timestamps into periods in pandas
  24. Clean way to convert quarterly periods to datetime in pandas
  25. Average time for datetime list
  26. Python: Adding hours to pandas timestamp
  27. how to specify the datetime format in read_csv
  28. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  29. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  30. Python generating a list of dates between two dates

Leave a Comment