← All blog series
Pandas for Finance
The Python data toolkit for finance analysts. yfinance, DataFrames, returns, joins, time-series, and a final backtest in 15 episodes.
15 posts
1
Pandas for Finance: Why Pandas When You Have Excel: 5 Years of Apple in 5 Lines
Celest Kim•Video•Quiz available
2
Pandas for Finance: The DataFrame Mental Model: Index, Columns, Series, Vectorized
Celest Kim•Video•Quiz available
3
Pandas for Finance: Loading & Caching Real Data: Parquet, load_or_download Pattern
Celest Kim•Video•Quiz available
4
Pandas for Finance: Filter Rows: Boolean Masks, .query(), .nlargest, Date Slices
Celest Kim•Video•Quiz available
5
Pandas for Finance: Pick Tickers and Columns: Brackets, .loc, .iloc, drop, rename
Celest Kim•Video•Quiz available
6
Pandas for Finance: Returns: Daily, Wealth Curve, Annualized, Sharpe, Drawdown
Celest Kim•Video•Quiz available
7
Pandas for Finance: GroupBy on Time: Buckets, Pivots, Named Aggregations
Celest Kim•Video•Quiz available
8
Pandas for Finance: Joins: Prices x Sector Lookup, merge() and the SQL JOIN
Celest Kim•Video•Quiz available
9
Pandas for Finance: Dates and the Trading Calendar: .dt, bdate_range, Calendar Gaps
Celest Kim•Video•Quiz available
10
Pandas for Finance: Resampling: Daily to Weekly OHLC, Monthly Returns, Yearly Matrix
Celest Kim•Video•Quiz available
11
Pandas for Finance: Rolling Windows: Moving Avg, Bollinger, Volatility, Drawdown
Celest Kim•Video•Quiz available
12
Pandas for Finance: Cleaning Market Data: Nulls, Forward-Fill, Adj Close Trap, Outliers
Celest Kim•Video•Quiz available
13
Pandas for Finance: Writing Out: Excel, Parquet, DuckDB — One Pipeline, Four Formats
Celest Kim•Video•Quiz available
14
Pandas for Finance: Capstone Backtest: Equal-Weight Portfolio vs SPY in Pandas
Celest Kim•Video•Quiz available
15
Pandas for Finance: Pandas + DuckDB at Scale: SQL on Parquet, 100× Faster
Celest Kim•Video•Quiz available