What values are valid in Pandas ‘Freq’ tags?

by

You can find it called Offset Aliases:

A number of string aliases are given to useful common time series frequencies. We will refer to these aliases as offset aliases.

Alias    Description
B        business day frequency
C        custom business day frequency
D        calendar day frequency
W        weekly frequency
M        month end frequency
SM       semi-month end frequency (15th and end of month)
BM       business month end frequency
CBM      custom business month end frequency
MS       month start frequency
SMS      semi-month start frequency (1st and 15th)
BMS      business month start frequency
CBMS     custom business month start frequency
Q        quarter end frequency
BQ       business quarter end frequency
QS       quarter start frequency
BQS      business quarter start frequency
A, Y     year end frequency
BA, BY   business year end frequency
AS, YS   year start frequency
BAS, BYS business year start frequency
BH       business hour frequency
H        hourly frequency
T, min   minutely frequency
S        secondly frequency
L, ms    milliseconds
U, us    microseconds
N        nanoseconds

More Related Contents:

  1. How to join two dataframes for which column values are within a certain range?
  2. Filtering Pandas DataFrames on dates
  3. How to print pandas DataFrame without index
  4. datetime dtypes in pandas read_csv
  5. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  6. Python Pandas Group by date using datetime data
  7. Removing the timestamp from a datetime in pandas dataframe
  8. Pandas filter dataframe rows with a specific year
  9. Python/Pandas convert string to time only
  10. Convert Pandas Series to DateTime in a DataFrame
  11. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  12. Python pandas integer YYYYMMDD to datetime
  13. Group DataFrame in 5-minute intervals
  14. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  15. Python: Adding hours to pandas timestamp
  16. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  17. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  18. Get weekday/day-of-week for Datetime column of DataFrame
  19. Plot pandas dates in matplotlib
  20. pandas divide row value by aggregated sum with a condition set by other cell
  21. Remove ends of string entries in pandas DataFrame column
  22. How to convert DataFrame.append() to pandas.concat()?
  23. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns
  24. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  25. Convert dates to pd.to_datetime where month could be either a number or month name
  26. start index at 1 for Pandas DataFrame
  27. Multi Index Sorting in Pandas
  28. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it
  29. Pandas: select all dates with specific month and day
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment