merge-agent

Inspect file headers and generate runnable merge scripts in Python, R, or Julia.

1|Updated Feb 25, 2026
One-click install
npx skills add https://github.com/bcmcpher/my-skills --skill merge-agent-bcmcpher
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: merge-agent
Source: https://github.com/bcmcpher/my-skills/tree/main/plugins/stat-analysis/agents/merge-agent
Command: npx skills add https://github.com/bcmcpher/my-skills --skill merge-agent-bcmcpher

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Delegate merge tasks by inspecting actual file headers, applying variable typing, and producing a runnable merge script in Python, R, or Julia. This helps ensure correct schema alignment and reproducible merges across multiple inputs.

Core Features & Use Cases

  • Inspect headers and data formats to infer delimiters, encodings, and schema.
  • Infer dtypes, cardinality, and representative samples for each column.
  • Validate and normalize merge keys across input files to prevent join errors.
  • Generate a runnable, multi-file merge script in Python (also supports R or Julia) with explicit sequential joins.
  • Include a validation block that prints a merge summary after execution.
  • Use source-based suffixes to preserve column provenance across merged data.

Quick Start

Provide the input file paths and merge keys, and run this agent to generate a runnable merge script.

Frequently Asked Questions about merge-agent

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate merging multiple CSV and Parquet files with different schemas?

Automating tabular merges involves inspecting file headers, detecting delimiters and encodings, and generating a runnable script with sequential joins. This approach validates keys across formats like CSV, Excel, and Parquet to prevent schema misalignment.

How do I generate a reproducible merge script in Python or R for multiple data files?

Generating a reproducible merge script requires inspecting input headers, inferring dtypes, and writing sequential joins with source-based suffixes. This produces a runnable Python, R, or Julia script that preserves column provenance across merged data.

Can I merge HDF5 and Excel files together while preserving column provenance?

Yes, you can merge HDF5 and Excel files by inspecting headers, inferring dtypes, and applying source-based suffixes. This preserves column provenance by appending source identifiers to overlapping column names in the final merged output.

What is the best way to validate merge keys across heterogeneous data formats before joining?

The best way to validate merge keys is to inspect headers, infer cardinality, and normalize keys across input files. This process prevents join errors by detecting mismatches early and includes a validation summary printed after execution.

Why does my data merge fail due to mismatched data types across input files?

Data merges often fail when input files have mismatched data types. Inferring dtypes and cardinality during preparation resolves this by ensuring schema alignment and validating keys before generating the final merge script.

Does the merge-agent Skill support generating scripts in Julia for tabular data joins?

Yes, the merge-agent Skill supports generating runnable merge scripts in Julia, as well as Python and R. It inspects headers, validates merge keys, and outputs a reproducible sequence of joins tailored to your chosen language.