Pandas Timestamps
Pandas provides Timestamp, DatetimeIndex, and Period for time-series analysis.
Python
Intermediate
4 min read
Datetime in Pandas
Example
import pandas as pd
ts = pd.Timestamp("2024-06-15 14:30:00", tz="UTC")
rng = pd.date_range("2024-01-01", periods=12, freq="ME") # month ends
df = pd.DataFrame({"date": rng, "value": range(12)})
df["month"] = df["date"].dt.month
df["year"] = df["date"].dt.year
monthly = df.resample("ME", on="date")["value"].sum() Pro Tip
DatetimeIndex enables .resample() — the most powerful tool for time-series aggregation.