Data Analysis – Page 2

Pandas GroupBy 2x Faster: Categorical Dtypes on 1M Rows

2026년 05월 09일

Speed up Pandas GroupBy 2x with categorical dtypes on large datasets. Real benchmark on 1M rows shows dramatic performance gains and memory savings.

2026년 05월 06일

Pandas resample OHLC beats custom groupby 14x faster for time series aggregation. Discover why built-in wins and when to use which method.

2026년 05월 05일

Compare Pandas vs SQL performance in real data cleaning tasks. Benchmark reveals surprising winner in the 3.2x speed gap—and when to use each tool.

2026년 05월 02일

Compare PCA, t-SNE, and UMAP on 10K samples with runtime benchmarks, visual quality analysis, and practical guidance for your data pipeline.

2026년 04월 29일

merge() beat concat() by 12x on 500K rows. Why most tutorials get Pandas joins wrong — real benchmarks with gotchas.

2026년 04월 25일

Fix Pandas MemoryError when reading large CSVs using chunking, Dask, or Polars. Compare memory usage and choose the best solution for your data.

2026년 04월 22일

Optimize Pandas memory usage and cut RAM by 90% when loading large CSVs. Learn dtype tricks, chunking, and category conversion techniques.

2026년 04월 17일

Master PySpark window functions with 3 battle-tested patterns for rolling aggregations. Fix memory issues and scale to billions of rows.