Metadata-Version: 2.4
Name: splitnstitch
Version: 0.2.0
Summary: CLI tool for splitting and merging table files (safe export / import merge / melt columns).
Author: espehon
License: MIT License
        
        Copyright (c) 2026 espehon
        
        Permission is hereby granted, free of charge, to any person obtaining a copy
        of this software and associated documentation files (the "Software"), to deal
        in the Software without restriction, including without limitation the rights
        to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        copies of the Software, and to permit persons to whom the Software is
        furnished to do so, subject to the following conditions:
        
        The above copyright notice and this permission notice shall be included in all
        copies or substantial portions of the Software.
        
        THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        SOFTWARE.
        
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3 :: Only
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: 3.9
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: 3.11
Classifier: Operating System :: OS Independent
Requires-Python: >=3.8
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: pandas==3.0.0
Requires-Dist: questionary==2.1.1
Requires-Dist: halo==0.0.31
Dynamic: license-file

# splitnstitch

A powerful CLI tool for splitting and merging table files. Perfect for creating safe-to-share datasets, managing sensitive data, and reorganizing table structures.

## Features

✨ **Split Tables** - Separate sensitive columns from public data  
🔄 **Stitch Tables** - Merge split files back together seamlessly  
📊 **Melt Columns** - Reshape wide data into long format  
🛡️ **Safe Export** - Create redacted versions of datasets  
🧩 **Detail Joins** - Enrich datasets with additional information  
📁 **Multiple Formats** - Works with CSV and Excel files  
💬 **Interactive CLI** - User-friendly command-line interface with guided workflows
🪟 **Windows Support** - Can be used on Windows machines as well as Linux

## Installation

```bash
pip install splitnstitch
```

Or install from source:

```bash
git clone https://github.com/espehon/splitnstitch.git
cd splitnstitch
pip install -e .
```

## Quick Start

Launch the interactive CLI:

```bash
sns
```

Or run with Python:

```bash
python -m splitnstitch
```

The tool will guide you through a series of prompts to:
1. Choose your operation (split, stitch, melt)
2. Select your data file (CSV or Excel)
3. Configure your preferences
4. Generate your output file(s)

## Use Cases

### 🔐 Privacy Protection
Split sensitive customer data into separate files to share only non-sensitive columns with partners while keeping PII secure.

### 📦 Data Organization
Reorganize wide datasets into long format for easier analysis and database import.

### 🔀 Selective Sharing
Share safe columns publicly while maintaining a master file with complete data internally.

### 🧬 Data Enrichment
Stitch together detail data from multiple sources to create a comprehensive dataset.

## Requirements

- Python 3.8+
- pandas
- questionary
- halo

## License

This project is licensed under the MIT License - see the LICENSE file for details.

## Author

Created by espehon
