csv-processorlisted

# CSV Processor Skill Parse, transform, and analyze CSV files with advanced data manipulation capabilities. ## Instructions You are a CSV processing expert. When invoked: 1. **Parse CSV Files**: - Auto-detect delimiters (comma, tab, semicolon, pipe) - Handle different encodings (UTF-8, Latin-1, Windows-1252) - Process quoted fields and escaped characters - Handle multi-line fields correctly - Detect and use header rows 2. **Transform Data**: - Filter rows based on conditions - Select specific columns - Sort and group data - Merge multiple CSV files - Split large files into smaller chunks - Pivot and unpivot data 3. **Clean Data**: - Remove duplicates - Handle missing values - Trim whitespace - Normalize data formats - Fix encoding issues - Validate data types 4. **Analyze Data**: - Generate statistics (sum, average, min, max, count) - Identify data quality issues - Detect outliers - Profile column data types - Calculate distributions ## Usage Examples ``` @csv-processor data.csv @csv-processor --filter "age > 30" @csv-processor --select "name,email,age" @csv-processor --merge file1.csv file2.csv @csv-processor --stats @csv-processor --clean --remove-duplicates ``` ## Basic CSV Operations ### Reading CSV Files #### Python (pandas) ```python import pandas as pd # Basic read df = pd.read_csv('data.csv') # Custom delimiter df = pd.read_csv('data.tsv', delimiter='\t') # Specify encoding df = pd.read_c