Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Python Pandas - Get the weekmask applied on the CustomBusinessDay offset
To get the weekmask applied on the CustomBusinessDay offset, use the CustomBusinessDay.weekmask property in Pandas.
At first, import the required libraries −
import pandas as pd
Set the timestamp object in Pandas −
timestamp = pd.Timestamp('2021-10-22 03:10:35')
Create the CustomBusinessDay Offset. CustomBusinessDay is the DateOffset subclass representing custom business days excluding holidays. Weekmask of valid business days −
cbdOffset = pd.tseries.offsets.CustomBusinessDay(n = 4, weekmask = 'Mon Tue Wed Fri')
Add the offset to the Timestamp and display the Updated Timestamp −
print("\nUpdated Timestamp...\n",timestamp + cbdOffset)
Display the weekmask −
print("\nThe weekmask on the CustomBusinessDay object..\n", cbdOffset.weekmask)Example
Following is the code −
import pandas as pd
# Set the timestamp object in Pandas
timestamp = pd.Timestamp('2021-10-22 03:10:35')
# Display the Timestamp
print("Timestamp...\n",timestamp)
# Create the CustomBusinessDay Offset
# CustomBusinessDay is the DateOffset subclass representing custom business days excluding holidays
# Weekmask of valid business days
cbdOffset = pd.tseries.offsets.CustomBusinessDay(n = 4, weekmask = 'Mon Tue Wed Fri')
# Display the CustomBusinessDay Offset
print("\nCustomBusinessDay Offset...\n",cbdOffset)
# Add the offset to the Timestamp and display the Updated Timestamp
print("\nUpdated Timestamp...\n",timestamp + cbdOffset)
# Return frequency applied on the given CustomBusinessDay Offset object as a string
print("\nFrequency applied on the given CustomBusinessDay Offset object...\n",cbdOffset.freqstr)
# return the count of increments on the given CustomBusinessDay object
print("\nThe count of increments on the CustomBusinessDay object..\n", cbdOffset.n)
# display the weekmask
print("\nThe weekmask on the CustomBusinessDay object..\n", cbdOffset.weekmask)Output
This will produce the following code −
Timestamp... 2021-10-22 03:10:35 CustomBusinessDay Offset... <4 * CustomBusinessDays> Updated Timestamp... 2021-10-29 03:10:35 Frequency applied on the given CustomBusinessDay Offset object... 4C The count of increments on the CustomBusinessDay object.. 4 The weekmask on the CustomBusinessDay object.. Mon Tue Wed Fri
Updated on: 22-Oct-2021
127 Views
Advertisements