#Datetime
Tags: 6 posts
June 2, 2025
•
6 min read
PySpark Datetime Cheatsheet — For Pandas Users
PySpark Datetime Cheatsheet — For Pandas Users All examples use:
from pyspark.sql import functions as F import pandas as pd 1. Casting Strings to Dates / Timestamps Pandas df["CreatedDate"] = pd.to_datetime(df["CreatedDate"]) …
January 16, 2025
•
6 min read
Advanced Polars Expressions: String Operations & Complex Data Types
Advanced Polars Expressions: String Operations & Complex Data Types Welcome to the second installment of our Polars mastery series! Building on the foundational concepts from Part 1, we’ll dive deep into Polars’ powerful expression …
April 26, 2020
•
1 min read
Handle multiple datetime formats representation using lubridate
Handling Heterogeneous datetime formats We`ll be using parse_date_time function of lubridate package.
Multple datetime formats can be passed under orders attribute of the above function as shown below -
library(lubridate) dates <- c( …
May 30, 2019
•
4 min read
Months between two dates
Importing Packages and Datasets import pandas as pd import numpy as np start_date = ['2019-06-03', '2019-06-13', '2018-11-05', '2019-05-31', '2019-06-01', '2019-09-01'] end_date = …
May 30, 2019
•
1 min read
Business Days with Custom Holidays
Importing Packages and Datasets import pandas as pd start_date = ['2019-06-03', '2019-06-13', '2019-10-01', '2019-09-01'] end_date = ['2019-08-31', '2019-06-21', '2019-10-25', …
January 1, 2019
•
6 min read
T-SQL - Introduction (Part 1)
Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL
These queries works on AdventureWorks database and information regarding the same
can be accessed by visiting …