Categories
Excel
VBA
- Using Excel UDF to compare data differences May 29, 2026 (UDF)
- How to fix a corrupted Excel file with high CPU usage January 11, 2024 (CPU)
ML
Feature Selection
- Improve VarianceThreshold performance in ML feature selection August 18, 2025
Python
IO
- Read CSV files 10x to 40x faster using pyarrow and polars June 13, 2024 (Performance)
Numba
- Make python loops 5x to 10x faster using numba November 26, 2024 (Performance)
Optimization
- Using Gurobi Python matrix API to reduce problem creation time March 17, 2025 (Gurobi)
Pandas
- Reduce a python app run time from two hours to 20 seconds July 11, 2025 (Performance)
- Explode date ranges in a pandas DataFrame 30x faster April 14, 2024 (Performance)
- How to create dummy pandas DataFrames for testing April 07, 2024 (Data)
Polars
- Polars null operations October 27, 2025 (NULL)
- Polars LazyFrame properties are expensive operations September 05, 2025 (LazyFrame)
SQL
- The pandas function pd.read_sql returns an empty DataFrame without correct data types September 06, 2024 (Data Type)