Get business days between start and end date using pandas

by

You can also use date_range for this purpose.

In [3]: pd.date_range('2011-01-05', '2011-01-09', freq=BDay())

Out[3]: DatetimeIndex(['2011-01-05', '2011-01-06', '2011-01-07'], dtype="datetime64[ns]", freq='B', tz=None)

EDIT

Or even simpler

In [7]: pd.bdate_range('2011-01-05', '2011-01-09')

Out[7]: DatetimeIndex(['2011-01-05', '2011-01-06', '2011-01-07'], dtype="datetime64[ns]", freq='B', tz=None)

Note that both start and end dates are inclusive.
Source: http://pandas.pydata.org/pandas-docs/stable/generated/pandas.bdate_range.html

More Related Contents:

  1. how to calculation cost time [closed]
  2. String concatenation of two pandas columns
  3. pandas: filter rows of DataFrame with operator chaining
  4. Pandas groupby: How to get a union of strings
  5. Reshape wide to long in pandas
  6. How do I create test and train samples from one dataframe with pandas?
  7. pandas groupby sort within groups
  8. Applying function with multiple arguments to create a new pandas column
  9. How to create a large pandas dataframe from an sql query without running out of memory?
  10. How do convert a pandas dataframe to XML?
  11. Python Pandas max value in a group as a new column
  12. How to add hovering annotations to a plot
  13. Converting between datetime and Pandas Timestamp objects
  14. How to query MultiIndex index columns values in pandas
  15. Pandas DataFrame column to list [duplicate]
  16. Add multiple empty columns to pandas DataFrame
  17. Shift NaNs to the end of their respective rows
  18. multi index plotting
  19. No numeric types to aggregate – change in groupby() behaviour?
  20. Pandas how can ‘replace’ work after ‘loc’?
  21. Pandas Dataframe: split column into multiple columns, right-align inconsistent cell entries
  22. Pandas in AWS lambda gives numpy error
  23. Pandas: Reading Excel with merged cells
  24. Pandas groupby with categories with redundant nan
  25. Writing a Python Pandas DataFrame to Word document
  26. Split Python sequence (time series/array) into subsequences with overlap
  27. Pandas combining rows based on dates
  28. Preserving column order in Python Pandas DataFrame
  29. start index at 1 for Pandas DataFrame
  30. Multi Index Sorting in Pandas

Leave a Comment