Results for “data”

Computes HEIM diversity and equity metrics from VCF or ancestry data, generating heterozygosity, FST, PCA plots, and a composite HEIM Equity Score with markdown reports.

Develop the next version of a MariaDB Schema Management (MSM) schema by editing the development script and splitting large sections into SOURCE-included files.

PHP-only security standards for database access, password handling, and input validation. Use when securing PHP apps against SQL injection, XSS, or weak password storage; defer Laravel middleware and security questions in other languages.

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

Extract text, tables, and structured data from documents using Azure Document Intelligence. Process invoices, receipts, IDs, forms, or build custom document models.

Guides the design of effective, user-friendly, and accessible Power BI reports with optimal chart selection and layout design.

Extracts structured data from Google Search results pages, including organic listings, paid ads, related searches, People Also Ask, and AI Overview.

Perform differential gene expression analysis for bulk RNA-seq data using PyDESeq2, supporting formulaic designs, Wald tests, FDR correction, LFC shrinkage, and result visualization.

Extract and analyze Douyin video data into evidence-graded learning notes, summaries, and research briefs using subtitles, ASR, comments, and AI-assisted reading.

Analyzes sample phenotype and SNP genotype data to identify the best-performing homozygous genotype at each locus, excluding heterozygous and missing calls, and writes results to a CSV file.

Diagnoses and validates Redpanda Connect pipelines using linting, dry-run connection tests, logging, metrics, tracing, and health endpoints, including enterprise feature troubleshooting.

Implements Bulk API 2.0 REST calls for ingest and query jobs, covering CSV format requirements, locator pagination, and v1 vs v2 selection.

Provides JPA/Hibernate patterns for Spring Boot data modeling, including entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and connection pooling.

Backtests quantitative trading strategies across 9 engines and 25 data sources, analyzes trade journals, and runs multi-agent research teams.

Performs differential expression analysis on label-free quantitative (LFQ) proteomics data from MaxQuant and DIA-NN outputs, including preprocessing, imputation, statistical testing, and visualization.

Documents MariaDB-specific CREATE USER syntax and behavior, including authentication chaining, TLS options, resource limits, password expiry, and account locking, to help write accurate statements.

Extends pandas for geospatial vector data operations including reading/writing shapefiles, GeoJSON, and GeoPackage, performing spatial joins, coordinate transformations, and creating static or interactive maps.

Perform cohort analysis on user engagement data — retention curves, feature adoption trends, and segment-level insights. Use when analyzing user retention by cohort, studying feature adoption over time, investigating churn patterns, or identifying engagement trends.

Creates, analyzes, and visualizes complex networks and graphs in Python with NetworkX. Use when working with network/graph data structures, analyzing relationships between entities, computing graph algorithms (shortest paths, centrality, clustering), detecting communities, generating synthetic networks, or visualizing topologies — applicable to social, biological, transportation, citation, and any pairwise-relationship networks. This is classical graph analytics, not deep learning — for training graph neural networks (GCN/message passing, node/edge/graph classification on Cora-style data) use alterlab-torch-geometric instead. Part of the AlterLab Academic Skills suite.

Build and optimize Power BI semantic models with star schema design, DAX measures, relationships, and row-level security following Microsoft best practices.

Extracts full detail data from a single Goofish (闲鱼) second-hand item page, including title, price, seller info, description, images, tags, and want-count.

Extract Amazon product reviews by ASIN using the BrowserAct API, returning structured data including ratings, text, reviewer info, and verified purchase status.

Scrapes Amazon product data from ASINs using browseract.com automation API and performs competitive analysis, comparing specifications, pricing, review quality, and visual strategies.

Extract structured product details from Amazon using an ASIN, including title, price, ratings, brand, and description via the BrowserAct API.

Train unsupervised machine learning models on genomic interval data from BED files, including region embeddings, single-cell ATAC-seq analysis, and consensus peak building.

Analyze biological sequences, alignments, phylogenetic trees, and diversity metrics (alpha/beta, UniFrac) with ordination (PCoA) and PERMANOVA for microbiome and community ecology data.

Recover deleted files from disk images and storage media using PhotoRec's file signature-based carving engine, regardless of file system damage.

Identifies and exploits SQL injection vulnerabilities in web applications during authorized penetration tests using manual techniques and automated tools like sqlmap.

Designs and implements production-grade RAG systems by chunking documents, generating embeddings, configuring vector stores, building hybrid search pipelines, applying reranking, and evaluating retrieval quality.

Annotates single-cell RNA-seq data by scoring marker genes, transferring labels with CellTypist, or reasoning over cluster markers with an LLM.

Extracts a specified URL parameter (such as loc) from a MySQL text column, derives the domain from each parameter value, and counts occurrences per domain, sorted descending.

Define el enfoque, las herramientas y el pipeline de análisis antes de escribir código, eligiendo entre SQL, Python o un enfoque híbrido según la pregunta y los datos.

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

Installs and configures MariaDB Connector/ODBC, covering driver manager registration, DSN setup, connection-string keywords, and TLS options for Linux, macOS, and Windows.

Analyzes AWS billing data with anti-hallucination guardrails, covering cost breakdowns, trends, anomaly detection, RI/SP utilization, forecasting, and multi-account comparisons using Cost Explorer.

Create publication-quality static, animated, and interactive plots with fine-grained control over every element, from basic charts to multi-panel figures, with export to PNG, PDF, and SVG.