Filter rows in a local .xlsx file using AND-combined predicates (eq, contains, gt, etc.). Server-side formula evaluation returns accurate matching rows as a markdown table.
Load FileMaker records into a named dataset for fast analytics. Fetch records once, store as pandas DataFrame, then run multiple analyses without extra database round trips.
Enables data analysis on CSV/Excel files using pandas. Supports profiling, column interpretation, sandboxed code execution, and interactive chart generation.
Recover cell formatting (number formats, fonts, fills) discarded by pandas, enabling LLMs to interpret date serials, currency, and percentages correctly.
Analyze FileMaker datasets with groupby, aggregation, filtering, pivoting, and time-series resampling. Returns compact summary tables instead of raw records.
Search code across your SourceGraph instance using text, patterns, or regular expressions. Filter by repository, file, language, and more for precise results.
Compute net totals across transaction types in a single call by summing signed sums of a quantity column, with per-component breakdown and warnings for unmatched conditions.
Export tracked ENCODE experiments as a CSV, TSV, or JSON table with metadata, publication counts, and PMIDs. Ideal for manuscripts, reports, and further literature analysis.
Scans a CSV or Excel file to return the complete value distribution for specified columns, including dtype, null counts, and frequency counts sorted by most common.
Group rows in a local .xlsx file by specified columns, then compute aggregations like sum, mean, count, or distinct count per group. Returns a markdown table of grouped results.
Reshape a flat table from a .xlsx file into a 2D matrix, aggregating values across index and columns. Choose from sum, mean, min, max, count, or count_distinct.