Data Analysis

Provides reference documentation and code patterns for using Biopython to handle biological sequences, file formats, database access, alignments, structures, and phylogenetics.

Gerencia contas do Instagram via Graph API: publica fotos, vídeos, reels, stories e carrosséis, agenda posts, responde comentários e DMs, coleta métricas e analisa hashtags.

Ingests video and audio from files, URLs, RTSP feeds, or desktop capture; indexes and searches moments with timestamps; transcodes, edits timelines, generates media assets, and creates real-time alerts for live streams.

Analyze Claude Code token usage, spending, and budgets from a local SQLite cost-tracking database, with breakdowns by project, tool, session, or date.

Geocode places, find nearby points of interest, calculate routes and travel times, and look up timezones using free OpenStreetMap, OSRM, and TimeAPI.io data sources.

Queries Polymarket prediction market data via public REST APIs: markets, prices, orderbooks, and history.

Query Solana blockchain data with USD pricing — wallet balances, token portfolios with values, transaction details, NFTs, whale detection, and live network stats. Uses Solana RPC + CoinGecko. No API key required.

Fetches latest WHOOP recovery, sleep, and strain data and generates daily suggestions.

Finds all places matching a query within a radius using grid-based Google Places scanning, with options for ratings, reviews, and map export.

Projeta métricas, logs, traces, dashboards, alertas e SLO com Prometheus, Grafana, Loki, Tempo, Mimir, Zabbix e Alertmanager, incluindo consultas PromQL e boas práticas de alertas.

Analyzes Claude Code session logs to report token usage, tool and skill rankings, and session search by prompt text.

Generates one-day Kiro credit usage reports from LanceDB usage events, with China-time windows, global totals, and account subset breakdowns.

Debug agent execution by querying trace and metric tables, analyzing tool calls, durations, errors, and performance trends.

Runs a deterministic, sample-based quality audit comparing original PDF/EPUB source against converted Markdown, flagging discrepancies and producing a GREEN/YELLOW/RED status report.

Investigates slow responses, tool failures, and guardrail rejections by querying agent trace logs and performance metrics.

Process PDFs with Python libraries and command-line tools: extract text and tables, create, merge, split, rotate, watermark, encrypt, and OCR documents.

Process tabular data with Polars' expression API, lazy evaluation, and parallel execution for fast in-memory analysis and pandas migration.

Provides expert guidance on modern SQL, cloud-native databases, and query optimization, covering performance tuning, data modeling, and hybrid analytical systems.

Reimplements DnaSP 6 for population genetics analysis of aligned DNA sequences, including nucleotide diversity, haplotype statistics, neutrality tests, linkage disequilibrium, recombination, mismatch distribution, InDel polymorphism, between-population divergence, outgroup-based tests, HKA test, McDonald-Kreitman.

Calculate polygenic risk scores from direct-to-consumer genetic data using published scoring files from the PGS Catalog and contextualize results against population reference distributions.

Performs differential expression analysis on bulk RNA-seq or pseudo-bulk count matrices with QC, PCA, and contrast testing.

Analyze a single FASTA file (nucleotide or protein), compute sequence-level metrics (GC, ORFs, MW, pI, GRAVY, secondary-structure fractions) with Biopython, and write a Markdown report plus structured JSON for downstream chaining.

Automates genome-wide association studies from genotype files to publication-ready results, running PLINK2 QC and REGENIE regression with Manhattan and QQ plots.

Annotates VCF variants using Ensembl VEP, ClinVar, and gnomAD, ranks them by predicted impact, and generates a reproducible report.

Returns structured prediction-market data for Polymarket, Kalshi, Limitless, Opinion, Predict.Fun, dFlow, and UMA oracle via a local API, covering markets, cross-venue search, leaderboards, smart money, wallet analytics, identity clustering, and resolution status.

Assesses genome, transcriptome, and protein completeness with BUSCO v6, automatically resolving the correct lineage from an organism description and generating reproducible reports.

Designs and implements big data architectures, processes large-scale datasets with distributed systems, and optimizes data pipelines for throughput using Hadoop, Spark, and cloud platforms.

Applies quantitative and qualitative analysis techniques, interprets experimental data, validates procedures, and selects appropriate methods with uncertainty quantification.

Performs financial ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction for strategic decision-making.

Analyzes campaign performance with multi-touch attribution, funnel conversion analysis, and ROI calculation for marketing optimization.

Process PDFs with Python and command-line tools: extract text and tables, merge, split, rotate, create, watermark, OCR, and handle passwords.

Runs R statistics analyses on local datasets, producing NLSS-format tables, narratives, and JSONL logs from CSV, SAV, RDS, RData, or Parquet files.

Creates, reads, and analyzes Excel workbooks with formulas, financial models, and data analysis, including formula recalculation and CSV/TSV conversion.

Cleans datasets, detects anomalies, generates reports, and creates visualizations using pandas, scikit-learn, and plotting libraries to turn raw data into client-ready deliverables.

Collects market data from Yahoo Finance and Exa, calculates technical indicators, scans watchlists, and generates market analysis reports to identify trading opportunities.

Tracks revenue pipelines, monitors Stripe and analytics metrics, and automates financial reporting for SaaS businesses.