vaex

Process and analyze large tabular datasets exceeding RAM using out-of-core DataFrames.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/Rowtion/Bioclaw --skill vaex-rowtion
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: vaex
Source: https://github.com/Rowtion/Bioclaw/tree/main/scientific-skills/vaex
Command: npx skills add https://github.com/Rowtion/Bioclaw --skill vaex-rowtion

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires vaex, numpy, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill tackles the challenge of analyzing datasets that are too large to fit into your computer's RAM, enabling interactive exploration and processing of billions of rows.

Core Features & Use Cases

  • Out-of-Core DataFrames: Work with datasets larger than memory.
  • Lazy Evaluation: Operations are performed only when needed, optimizing performance.
  • Fast Aggregations & Visualizations: Quickly compute statistics and generate plots from massive data.
  • Use Case: Analyze a multi-terabyte CSV file containing sensor data to identify anomalies and trends without running out of memory.

Quick Start

Use the vaex skill to open the file 'large_dataset.hdf5' and print its shape.

Frequently Asked Questions about vaex

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I process a large CSV file that exceeds available RAM?

To process a large CSV file that exceeds RAM, use out-of-core DataFrames and lazy evaluation. This approach reads data in chunks and evaluates operations only when needed, enabling interactive analysis of massive tabular datasets without memory errors.

Can I compute fast aggregations and statistics on billions of rows interactively?

Yes, you can compute fast aggregations and statistics on billions of rows interactively. By using out-of-core DataFrames and lazy evaluation, operations are delayed and optimized, allowing quick calculations and visualizations on massive datasets that exceed memory limits.

What file formats are supported for out-of-core big data analysis?

Supported file formats for out-of-core big data analysis include CSV, HDF5, Arrow, and Parquet. These formats enable fast statistics, visualization, and machine learning tasks on massive tabular datasets that exceed available RAM capacity.

How does lazy evaluation optimize performance for large tabular datasets?

Lazy evaluation optimizes performance for large tabular datasets by performing operations only when needed. By delaying execution until a result is explicitly requested, it minimizes memory usage and significantly speeds up out-of-core data processing.

Do I need to convert my data before analyzing a multi-terabyte dataset?

You do not need to convert your data before analyzing a multi-terabyte dataset. You can directly open and process large CSV, HDF5, Arrow, or Parquet files to identify anomalies and trends using out-of-core DataFrames without running out of memory.