Skills
.Work. You
Rest

db23-excel-split

Community

Split multi-day Excel files

Data & Analytics#validation#data pipeline#split#excel#trading data#db23
Authortankygranny05
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill automates the process of splitting large, multi-day Excel files into smaller, single-day files required by the db23 trading data pipeline, ensuring data integrity and compatibility.

Core Features & Use Cases

  • Splitting Logic: Divides Excel workbooks based on the ORDER_DATE and PT_DATE columns.
  • Data Validation: Enforces strict requirements for sheet names, column headers, and data types.
  • Use Case: Prepare daily trading data from a consolidated weekly or monthly Excel report for ingestion into a structured database.

Quick Start

Split the Excel file located at /home/ubuntu/Downloads/multi-day/YOUR_FILE.xlsx into single-day files in the /home/ubuntu/Downloads directory.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: db23-excel-split
Download link: https://github.com/tankygranny05/agent-box/archive/main.zip#db23-excel-split

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.