Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
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()
Result
Open