数据处理

数据转换、清洗与 ETL

显示 25-48 / 共 13405 个技能
anthropics

sql-queries

anthropics

Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). Use when writing queries, optimizing slow SQL, translating between dialects, or building complex analytical queries with CTEs, window functions, or aggregations.

数据处理 3.2万 8个月前
anthropics

instrument-data-to-allotrope

anthropics

Convert laboratory instrument output files (PDF, CSV, Excel, TXT) to Allotrope Simple Model (ASM) JSON format or flattened 2D CSV. Use this skill when scientists need to standardize instrument data for LIMS systems, data lakes, or downstream analysis. Supports auto-detection of instrument types. Outputs include full ASM JSON, flattened CSV for easy import, and exportable Python code for data engineers. Common triggers include converting instrument files, standardizing lab data, preparing data for upload to LIMS/ELN systems, or generating parser code for production pipelines.

数据处理 3.2万 8个月前
anthropics

statistical-analysis

anthropics

Apply statistical methods including descriptive stats, trend analysis, outlier detection, and hypothesis testing. Use when analyzing distributions, testing for significance, detecting anomalies, computing correlations, or interpreting statistical results.

分析 3.2万 8个月前
anthropics

knowledge-synthesis

anthropics

Combines search results from multiple sources into coherent, deduplicated answers with source attribution. Handles confidence scoring based on freshness and authority, and summarizes large result sets effectively.

分析 3.2万 8个月前
anthropics

data-context-extractor

anthropics

Generate or improve a company-specific data analysis skill by extracting tribal knowledge from analysts. BOOTSTRAP MODE - Triggers: "Create a data context skill", "Set up data analysis for our warehouse", "Help me create a skill for our database", "Generate a data skill for [company]" → Discovers schemas, asks key questions, generates initial skill with reference files ITERATION MODE - Triggers: "Add context about [domain]", "The skill needs more info about [topic]", "Update the data skill with [metrics/tables/terminology]", "Improve the [domain] reference" → Loads existing skill, asks targeted questions, appends/updates reference files Use when data analysts want Claude to understand their company's specific data warehouse, terminology, metrics definitions, and common query patterns.

自动化 3.2万 8个月前
anthropics

data-validation

anthropics

QA an analysis before sharing with stakeholders — methodology checks, accuracy verification, and bias detection. Use when reviewing an analysis for errors, checking for survivorship bias, validating aggregation logic, or preparing documentation for reproducibility.

分析 3.2万 8个月前
anthropics

data-exploration

anthropics

Profile and explore datasets to understand their shape, quality, and patterns before analysis. Use when encountering a new dataset, assessing data quality, discovering column distributions, identifying nulls and outliers, or deciding which dimensions to analyze.

分析 3.2万 8个月前
luongnv89

self-assessment

luongnv89

Comprehensive Claude Code self-assessment and learning path advisor. Runs a multi-category quiz covering 10 feature areas, produces a detailed skill profile with per-topic scores, identifies specific gaps, and generates a personalized learning path with prioritized next steps. Use when asked to "assess my level", "take the quiz", "find my level", "where should I start", "what should I learn next", "check my skills", "skill check", or "level up".

CLI 工具 4.4万 8天前
lobehub

acceptance

lobehub

End-to-end verification and self-evidence for a delivery in any repository, with or without a preconfigured verify plan. Discover an existing plan when one was handed to this run; otherwise author checks and publish a standalone acceptance. Pick the proving surface (CLI / web / desktop / iOS Simulator), drive the real product, capture visually confirmed evidence, and publish a round with the lh CLI. Triggers on 'verify the task', 'collect evidence', 'prove it works', 'upload evidence', 'verify plan', 'requiredEvidence', 'local test', 'manual test', 'test report', 'test with cli', 'test in electron', 'test desktop', or any local end-to-end verification task. Needs no ambient ids, and never depends on running inside a LobeHub conversation.

数据处理 8.3万 1个月前
lobehub

debug-package

lobehub

'LobeHub debug package and log namespace guide. Use when adding debug() logging, choosing lobe-* namespaces, troubleshooting DEBUG output, localStorage.debug, or log format specifiers.'

数据处理 8.3万 4个月前
lobehub

model-bank-metadata

lobehub

'Backfill and maintain model-bank metadata (knowledgeCutoff, family, generation). Use when adding models, fixing cutoff/family data, running a metadata sweep across aiModels providers, or researching official knowledge cutoffs.'

数据处理 8.3万 4个月前
wesammustafa

onboard

wesammustafa

Explains this repository's shared Claude Code setup to a new teammate, covering what is committed and shared, what stays personal, and what the team-kit plugin adds. Use when someone asks how the team's Claude Code setup works or what they get by cloning the repository.

数据处理 3473 14天前
brycewang-stanford

lit-review

brycewang-stanford

Structured literature search and synthesis with citation extraction and gap identification

学术 4749 6个月前
brycewang-stanford

Searching Scientific Literature

brycewang-stanford

PubMed search with keyword optimization, result parsing, and metadata extraction

学术 4749 3个月前
brycewang-stanford

Full-empirical-analysis-skill

brycewang-stanford

Classical end-to-end empirical analysis workflow in the traditional Python econometric stack — pandas + numpy + scipy + statsmodels + linearmodels + pyfixest + rdrobust + econml + causalml + matplotlib/seaborn. Defaults to economics empirical-paper style (AER / QJE / AEJ) — every run produces a publication-ready output set with a multi-column regression table (M1→M6 progressive controls/FE) as the centerpiece, plus Table 1 (descriptives), mechanism / heterogeneity / robustness tables, and event-study + coefficient + trend figures. Covers the full 8-step pipeline an applied economist or quantitative social scientist runs on every paper — (1) data cleaning, (2) variable construction & transformation, (3) descriptive statistics & Table 1, (4) statistical diagnostic tests, (5) baseline empirical modeling, (6) robustness battery, (7) further analysis (mechanism, heterogeneity, mediation, moderation), (8) publication-ready tables & figures. Also covers two parallel domain modes that share the same 8-step scaffolding — Mode A — Epidemiology / public health (target-trial emulation via zepid / hand-rolled pandas, IPTW + g-formula + TMLE doubly-robust triplet via zepid / econml / lifelines, Mendelian randomization via pymr / mrtool (or rpy2 → MendelianRandomization/TwoSampleMR), KM / AFT / Cox survival via lifelines, E-value sensitivity, principal stratification — STROBE / TRIPOD reporting), and Mode B — ML causal inference (DML via econml.dml / doubleml, S/T/X/R/DR meta-learners via econml.metalearners / causalml, causal forest via econml.grf / causalml, Dragonnet / TARNet / CEVAE neural causal via causalml, BCF via pymc-bart / bcf-py, matrix completion, CATE distribution + policy tree via econml.policy / policytree-py, off-policy evaluation, conformal causal via mapie, fairness audit via fairlearn, DAG learning via causal-learn / cdt / LLM-assisted). Prescribes which library to reach for at each step, shows the canonical code, and links to deeper references/ files for variant-specific patterns. Use when the user asks for a complete empirical analysis in Python, wants to replicate an applied-economics paper from scratch, needs a reproducible workflow that is NOT opinionated on any single vertical package (contrast with StatsPAI), wants explicit control over every estimator and diagnostic, or asks "how do I write a full empirical pipeline in Python?". Also triggers when the user names a specific classical step in isolation — "winsorize at 1/99%", "run Breusch-Pagan", "build a Table 1 balance table", "do a placebo test", "event study plot", "mediation analysis" — and wants it wired into the broader pipeline. Mode A triggers on "target trial emulation", "IPTW", "TMLE", "Mendelian randomization", "STROBE", "公共健康", "流行病学". Mode B triggers on "DML", "double machine learning", "causal forest", "meta-learner", "Dragonnet", "BCF", "policy tree", "conformal causal", "fairness audit", "因果机器学习".

数据处理 4749 3个月前
brycewang-stanford

Full-empirical-analysis-skill

brycewang-stanford

Classical end-to-end empirical analysis workflow in the traditional Python econometric stack — pandas + numpy + scipy + statsmodels + linearmodels + pyfixest + rdrobust + econml + causalml + matplotlib/seaborn. Defaults to economics empirical-paper style (AER / QJE / AEJ) — every run produces a publication-ready output set with a multi-column regression table (M1→M6 progressive controls/FE) as the centerpiece, plus Table 1 (descriptives), mechanism / heterogeneity / robustness tables, and event-study + coefficient + trend figures. Covers the full 8-step pipeline an applied economist or quantitative social scientist runs on every paper — (1) data cleaning, (2) variable construction & transformation, (3) descriptive statistics & Table 1, (4) statistical diagnostic tests, (5) baseline empirical modeling, (6) robustness battery, (7) further analysis (mechanism, heterogeneity, mediation, moderation), (8) publication-ready tables & figures. Also covers two parallel domain modes that share the same 8-step scaffolding — Mode A — Epidemiology / public health (target-trial emulation via zepid / hand-rolled pandas, IPTW + g-formula + TMLE doubly-robust triplet via zepid / econml / lifelines, Mendelian randomization via pymr / mrtool (or rpy2 → MendelianRandomization/TwoSampleMR), KM / AFT / Cox survival via lifelines, E-value sensitivity, principal stratification — STROBE / TRIPOD reporting), and Mode B — ML causal inference (DML via econml.dml / doubleml, S/T/X/R/DR meta-learners via econml.metalearners / causalml, causal forest via econml.grf / causalml, Dragonnet / TARNet / CEVAE neural causal via causalml, BCF via pymc-bart / bcf-py, matrix completion, CATE distribution + policy tree via econml.policy / policytree-py, off-policy evaluation, conformal causal via mapie, fairness audit via fairlearn, DAG learning via causal-learn / cdt / LLM-assisted). Prescribes which library to reach for at each step, shows the canonical code, and links to deeper references/ files for variant-specific patterns. Use when the user asks for a complete empirical analysis in Python, wants to replicate an applied-economics paper from scratch, needs a reproducible workflow that is NOT opinionated on any single vertical package (contrast with StatsPAI), wants explicit control over every estimator and diagnostic, or asks "how do I write a full empirical pipeline in Python?". Also triggers when the user names a specific classical step in isolation — "winsorize at 1/99%", "run Breusch-Pagan", "build a Table 1 balance table", "do a placebo test", "event study plot", "mediation analysis" — and wants it wired into the broader pipeline. Mode A triggers on "target trial emulation", "IPTW", "TMLE", "Mendelian randomization", "STROBE", "公共健康", "流行病学". Mode B triggers on "DML", "double machine learning", "causal forest", "meta-learner", "Dragonnet", "BCF", "policy tree", "conformal causal", "fairness audit", "因果机器学习".

数据处理 4749 4个月前
brycewang-stanford

Finding Open Access Papers

brycewang-stanford

Use Unpaywall API to find free full-text versions of paywalled papers

学术 4749 3个月前
brycewang-stanford

Checking ChEMBL for Structured SAR Data

brycewang-stanford

Check if medicinal chemistry papers are in ChEMBL database to access curated bioactivity data

数据处理 4749 3个月前
brycewang-stanford

Evaluating Paper Relevance

brycewang-stanford

Two-stage paper screening - abstract scoring then deep dive for specific data extraction

数据处理 4749 3个月前
brycewang-stanford

api-data-fetcher

brycewang-stanford

Fetch economic data from FRED, World Bank, and other APIs

API 开发 4749 6个月前
brycewang-stanford

reproducible-pipelines

brycewang-stanford

This skill covers reproducible research pipelines and replication packages. Use when the user is setting up a research project directory structure, configuring workflow managers (Make, Snakemake, DVC), managing computational environments, preparing replication packages for journal submission, or debugging reproducibility failures. Triggers on "reproducible", "replication package", "Makefile", "Snakemake", "DVC", "pipeline", "workflow manager", "data versioning", "conda environment", "Docker", "seed management", "AEA data editor", "replication", "project structure", or "submission checklist".

自动化 4749 6个月前
brycewang-stanford

python-panel-data

brycewang-stanford

Panel data analysis with Python using linearmodels and pandas.

代码生成 4749 6个月前
brycewang-stanford

Full-empirical-analysis-skill-Stata

brycewang-stanford

Classical end-to-end empirical analysis workflow in the traditional Stata ecosystem — native Stata + reghdfe + ivreg2 + csdid + did_imputation + eventstudyinteract + sdid + rdrobust + rddensity + synth + synth_runner + psmatch2 + teffects + ebalance + coefplot + esttab + asdoc + binscatter. Defaults to economics empirical-paper style (AER / QJE / AEJ) — every run produces a publication-ready output set with a multi-column regression table (M1→M6 progressive controls/FE) as the centerpiece, plus Table 1 (descriptives), mechanism / heterogeneity / robustness tables, and event-study + coefficient + trend figures. Covers the full 8-step Stata pipeline an applied economist runs on every paper — (1) data import & cleaning (use/import, destring, misstable, duplicates, merge assert), (2) variable construction (gen/egen/winsor2/xtile/xtset with L./F./D.), (3) descriptive statistics & Table 1 (tabstat/balancetable/asdoc), (4) classical diagnostic tests (sktest/swilk/hettest/imtest/xtserial/xttest3/vif/dfuller/kpss/hausman/estat overid), (5) baseline modeling (reg/xtreg/reghdfe/ivreg2/ivregress/csdid/did_imputation/eventstudyinteract/sdid/rdrobust/synth/psmatch2/teffects/heckman/qreg/ppmlhdfe), (6) robustness battery (bacondecomp/honestdid/rwolf/ritest/wildbootstrap/oster), (7) further analysis (subgroup/triple-diff/interactions/medsem/marginsplot/binscatter by group), (8) publication-ready tables & figures (esttab/outreg2/estout/coefplot/marginsplot/rdplot/twoway combined). Also covers two parallel domain modes that share the same 8-step scaffolding — Mode A — Epidemiology / public health (target-trial emulation, IPTW + g-formula + TMLE doubly-robust triplet via teffects ipw / teffects ipwra / teffects aipw / eltmle, Mendelian randomization via mrrobust (IVW / Egger / weighted median) and mregger / mrpresso, KM / Cox / AFT / RMST survival via sts / stcox / streg / strmst2, E-value sensitivity via evalue (Linden-Mathur), principal stratification — STROBE / TRIPOD reporting), and Mode B — ML causal inference (DML via ddml / pdslasso, S/T/X/R/DR meta-learners via crforest and ddml interactive, causal forest via crforest / cforest, BART/BCF via bart / bartCause-style externals, CATE distribution + policy tree via crforest, off-policy evaluation, conformal causal externals, fairness audit, DAG learning via pcalg / external Python callouts). Use when the user asks for a complete Stata empirical analysis, wants a reproducible .do-file pipeline, needs a Stata counterpart to the Python StatsPAI / Full-empirical-analysis-skill, or names a specific Stata step in isolation ("run reghdfe with two-way clustering", "csdid event study", "winsor2 at 1%", "esttab to LaTeX", "coefplot with CI", "ivreg2 weak-IV test", "synth_runner placebos", "teffects psmatch balance check"). Mode A triggers on "target trial emulation Stata", "teffects ipw aipw", "eltmle", "mrrobust", "mregger weighted median", "stcox AFT survival", "strmst2", "evalue Stata", "STROBE Stata", "公共健康 Stata", "流行病学 Stata". Mode B triggers on "ddml Stata", "pdslasso", "crforest causal forest Stata", "policy tree Stata", "因果机器学习 Stata".

数据处理 4749 4个月前
brycewang-stanford

Answering Research Questions

brycewang-stanford

Main orchestration workflow for systematic literature research - search, evaluate, traverse, synthesize

学术 4749 3个月前