DataFrame Operations
Filter, sort, aggregate, pivot, melt, join, concatenate, and reshape data with a rich API modeled after Pandas.
New in Version 8
InTouch DataFrame Tool
Jupyter-Style Data Science Without the Infrastructure
Python's Pandas Power, Java's Performance, InTouch's Simplicity
Powered by the Tablesaw library, the DataFrame Tool delivers Pandas and NumPy functionality in pure Java. No Python environments, no Jupyter notebooks, no conda. Write data science code in a Jupyter-style environment with automatic dependency management.
Key Benefits
Data Science in Java
Pandas-like data manipulation with up to 2 billion rows per table. Filter, sort, aggregate, pivot, melt, join — all in pure Java.
Zero Setup Overhead
No Python, no Jupyter, no conda environments to install, configure, or maintain. Just write code and run.
Automatic Dependencies
Specify Maven dependencies once at the top of your code. InTouch auto-downloads everything from Maven Central. No manual resolution.
Seamless Integration
Works with all InTouch tools — pipe data from SQL exports into DataFrame transformations, then load results back to any database.
Automatic Dependency Management
List Maven dependencies at the top of your code, just like Jupyter imports. InTouch auto-downloads everything from Maven Central — no manual dependency resolution, no classpath configuration, no version conflicts. Downloaded once, cached and reused.
AI-Assisted Development
Describe your data processing needs in plain English to AI assistants like Claude, and get working Java Shell code ready to paste into InTouch. The bridge between natural language and enterprise data processing.
Data Manipulation Features
Statistical Analysis
Descriptive statistics, correlations, distributions, and cross-tabulations built directly into the DataFrame library.
Data Transformation
Reshape, clean, normalize, and engineer features. Handle missing data, type conversions, and complex transformations.
Universal Data Loading
Read from CSV, Excel, JSON, SQL databases, HTML tables, and fixed-width files. Write to any supported format.
Full Java Ecosystem
Access any Java library via Maven — machine learning, HTTP clients, cryptography, email, PDF generation, and more.
Workflow Integration
Pass data between SQL, DataFrame, and other InTouch tools. Build multi-step data pipelines with automatic orchestration.
Powered by Tablesaw
Blazing Fast
Retrieve 500 records from a 500-million-row table in approximately 2 milliseconds.
Massive Scale
Handle up to 2 billion rows per table — far beyond what fits in a typical Python Pandas DataFrame.
Rich Operations
Over 500 built-in functions for data manipulation, transformation, and analysis.
Statistical Functions
Comprehensive descriptive and inferential statistics built into the library.
Why Java DataFrame Over Python and Jupyter?
| Capability | Python / Jupyter | InTouch DataFrame |
|---|---|---|
| Infrastructure Requirements | Python, Jupyter, conda, pip, venv | None — runs on InTouch server |
| Workflow Integration | Custom scripts to chain steps | Native InTouch orchestration |
| Developer Pool | Python specialists required | Any Java developer |
| Dependency Management | pip, conda, version conflicts | Automatic Maven resolution |
| Scheduling & Triggers | External scheduler needed | Built-in visual scheduler |
| Error Handling & Alerts | Build your own | Automatic notification on failure |
| Security & Credentials | Config files / env variables | Encrypted, centralized, RBAC |
| Scalability | Limited by Python GIL | Raspberry Pi to enterprise servers |
Beyond DataFrames: General Java Execution
The DataFrame Tool is also a full Java Shell environment. Write any Java code for:
API Integration
Call REST APIs, parse JSON responses, POST data to external services.
File Processing
Parse and generate XML, JSON, PDF, and other complex file formats.
Encryption & Security
Custom cryptographic operations using Java's built-in security libraries.
Email Processing
Send and process emails using JavaMail and other communication libraries.
Custom Business Logic
Implement any business rules, validations, or transformation logic in Java.
Any Maven Library
Access the entire Maven Central repository — hundreds of thousands of libraries.
Use Cases
- ETL Data Transformation — reshape, clean, and aggregate data between extraction and loading
- Financial Analysis — compute financial metrics, ratios, and aggregations across large datasets
- Data Quality Automation — scheduled data validation and anomaly detection across systems
- ML Data Preparation — feature engineering, normalization, and dataset preparation for machine learning
- Report Generation — compute summaries, cross-tabulations, and formatted output for business reporting
- API Data Processing — fetch data from REST APIs, transform it, and load into databases or files
Technical Specifications
Execution Environment
Java Shell (JShell) 11+
Core Library
Tablesaw for DataFrame operations
Data Capacity
Up to 2 billion rows per table
Performance
~2ms for 500 rows from 500M
Supported Formats
CSV, Excel, JSON, SQL, HTML, fixed-width
Dependencies
Automatic Maven resolution
Library Access
Entire Maven Central repository
Integration
Works with all InTouch tools
Ready for Data Science Without the Infrastructure?
Bring Pandas-like power to your InTouch workflows — no Python required.
Contact Blue Isle Software