jceresearch / pydit

Library of data wrangling functions that an internal auditor typically needs (for my own use and learning, if you wish to use or collaborate pls get in touch, or use at your own peril).
https://pypi.org/project/pydit-jceresearch/
MIT License
2 stars 0 forks source link

create a calendar table based on one or more data frames and merge back relevant attributes #10

Closed jceresearch closed 2 years ago

jceresearch commented 2 years ago

Similar to powerBI calendar tables pick a bunch of DFs look at all the datetimes there, find the range that comprise all, generate it for reference and potentially merge back to a list of fields and/or df+files a selection of those facets (quarter, yyyymm, yyyymmdd, yyyyww, working/non-working, dow)