The Complete Production SOP: How to Deploy and Run Polars Rust-Powered Fast DataFrame Expressions in Autonomous AI Agents

---
name: "polars-rust-dataframe-opt"
description: "Process multi-gigabyte tabular datasets at maximum speed with Polars expressions."
metadata:
  author: "Polars"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "use polars dataframe python"
  - "aggregate data polars"
  - "write polars expression"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

# Polars Rust-Powered Fast DataFrame Expressions
Write queries using column expressions: df.select(pl.col('amount').sum().over('customer_id')).

import polars as pl

# Validate Polars build and SIMD features
build_info = pl.build_info()
print(f"Polars Version: {build_info.get('version', pl.__version__)}")
print(f"Threads Available: {pl.thread_pool_size()}")
assert pl.thread_pool_size() > 0, "Multi-threading engine failed to initialize."

import polars as pl

def compute_customer_metrics(lazy_df: pl.LazyFrame) -> pl.LazyFrame:
    """Calculates customer metrics using idiomatic Polars Rust expressions."""
    return lazy_df.select([
        pl.col("customer_id"),
        pl.col("transaction_id"),
        pl.col("amount"),
        # Vectorized conditional categorization
        pl.when(pl.col("amount") >= 1000)
          .then(pl.lit("VIP"))
          .otherwise(pl.lit("Standard"))
          .alias("customer_tier"),
        # Window function: Customer-level aggregate without eager groupby
        pl.col("amount").sum().over("customer_id").alias("customer_total_spend"),
        # Cumulative count over order window
        pl.col("transaction_id").cum_count().over("customer_id").alias("transaction_sequence")
    ])

#!/usr/bin/env bash
set -euo pipefail

# Validate no pandas conversion leakage occurred in the codebase
if grep -rnw './pipeline' -e 'to_pandas' -e 'apply('; then
    echo "[GATE ERROR]: Disallowed Pandas or Python lambda bridging detected in pipeline!"
    exit 1
fi

echo "[GATE SUCCESS]: Polars expressions conform to high-performance zero-copy standards."