Tag: pandas
All the articles with the tag "pandas".
-
Data Analysis Study #3 — pandas loc includes the end, iloc excludes it
Week 3, day 2. I went through Series attributes and pulled out values with loc and iloc. I confirmed that slicing doesn't raise an error even when it goes out of range, and that loc and iloc handle the endpoint differently. I also cover conditional filtering and aggregating boolean Series.
-
Data Analysis Study #2 — pandas Series adds by matching indices, not order
After the lecture, I jumped straight into pandas practice. I set up the environment with uv and tried out Series, and adding two Series with different indices gave me NaN instead of values. That's when I learned pandas calculates based on index, not position.
-
Quant Study 00 — pandas Basics · Trend Following vs Mean Reversion · The 4 Backtest Biases · Fake Alpha
Starting a quant learning series. pandas Series/DataFrame, loc/iloc, the warm-up period (NaN), silent data corruption from adjusted close prices, trend following (MA, golden/dead cross) vs mean reversion, the 4 backtest biases (look-ahead, overfitting, unrealistic trading costs, survivorship bias), and why you need to look at a distribution instead of a single point to filter out fake alpha (B&H beat rate / median alpha / market exposure / walk-forward).