Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Filter by Categories
About Article
Analyze Data
Archive
Best Practices
Better Outputs
Blog
Code Optimization
Code Quality
Command Line
Course
Daily tips
Dashboard
Data Analysis & Manipulation
Data Engineer
Data Visualization
DataFrame
Delta Lake
DevOps
DuckDB
Environment Management
Feature Engineer
Git
Jupyter Notebook
LLM
LLM Tools
Machine Learning
Machine Learning & AI
Machine Learning Tools
Manage Data
MLOps
Natural Language Processing
Newsletter Archive
NumPy
Pandas
Polars
PySpark
Python Helpers
Python Tips
Python Utilities
Scrape Data
SQL
Testing
Time Series
Tools
Visualization
Visualization & Reporting
Workflow & Automation
Workflow Automation

Time Series

Maya: Convert the string to datetime automatically

If you want to convert a string type to a datetime type, the common way is to use strptime(date_string, format). But it is quite inconvenient to specify the structure of your datetime string, such as %Y-%m-%d %H:%M:%S.

To convert the string to datetime automatically, use maya. You just need to parse the string, and maya will figure out the structure of your string.

Link to maya.

Maya: Convert the string to datetime automatically Read More »

traces: A Python Library for Unevenly-Spaced Time Series Analysis

If you are working with unevenly-spaced time series, try traces. traces allows you to get the values of the datetimes not specified in your time series based on the values of other datetimes.
For example, while logging our working hours for each date, we forgot to log the working hours for some dates. We can get the working hours of dates we forgot to log using traces.
Link to traces.
Link to all previous tips on time series.

traces: A Python Library for Unevenly-Spaced Time Series Analysis Read More »

Extract holiday from date column

You have a date column and you think the holidays might affect the target of your data. Is there an easy way to extract the holidays from the date? Yes, that is when holidays package comes in handy.
Holidays package provides a dictionary of holidays for different countries. The code below is to confirm whether 2020-07-04 is a US holiday and extract the name of the holiday.
The great thing about this package is that you can write the date in whatever way you want and the package is still able to detect which date you are talking about.
You can also add more holidays if you think that the library is lacking some holidays.
Try this out if you are looking for something similar.

Extract holiday from date column Read More »

Scroll to Top

Work with Khuyen Tran

Work with Khuyen Tran