CSVise CLI Tools

---

📋 Table of Contents

• CSVise CLI Tools
  • 📋 Table of Contents
  • 🚀 Installation
    • From PyPI (Recommended)
    • From Source
  • ⚡ Quick Start
    • Display CSV Data
    • Analyze Data
    • Clean Data
  • ✨ Features
    • Display & Validation
    • Data Analysis & Statistics
    • Data Cleaning Operations
    • 🎨 Rich UI Integration
  • 📖 Documentation
    • Command Reference
      • Global Options
      • Custom Delimiter Example
    • Configuration
    • Examples
      • Rich UI Examples
      • Classic Mode Examples
      • Data Analysis Examples
      • Data Cleaning Examples
    • Example Output
  • 🔧 Development
    • Setup Development Environment
    • Run Tests
    • Code Quality
    • Build Package
  • 📄 License

---

🚀 Installation

From PyPI (Recommended)

pip install csvise

From Source

git clone https://github.com/rawsabsaid/csvise-cli-tool.git
cd csvise-cli-tool
pip install -e .

---

⚡ Quick Start

Display CSV Data

# Beautiful table display with Rich formatting
csvise display data.csv

# Classic plain text output
csvise display data.csv --classic

Analyze Data

# Comprehensive analysis
csvise analyze data.csv

# Detect outliers and correlations
csvise analyze data.csv --outliers --correlations

Clean Data

# Remove duplicates and normalize whitespace
csvise clean data.csv --remove-duplicates --normalize-whitespace --output cleaned.csv

---

✨ Features

Display & Validation

Beautiful CSV display with automatic delimiter detection and data validation:

csvise display FILENAME [OPTIONS]

Options:

• --display : Display formatted table output
• --debug : Enable debug output for troubleshooting
• -v : Verbose mode with detailed operation logs
• -dl, --delimiter DELIMITER : Set custom delimiter
• -stf, --save_to_file OUTPUT : Save output to file
• --rich : Use Rich formatting (default)
• --classic : Use classic plain text formatting

Data Analysis & Statistics

Comprehensive data analysis with statistical insights:

csvise analyze FILENAME [OPTIONS]

Options:

• --columns, -c : Analyze specific columns (comma-separated)
• --correlations : Show correlation matrix for numeric columns
• --outliers : Detect outliers in numeric columns
• --distribution : Show value distribution for categorical columns
• -v : Verbose mode
• --classic : Use classic plain text formatting

Data Cleaning Operations

Powerful data cleaning and transformation capabilities:

csvise clean FILENAME [OPTIONS]

Options:

• --remove-duplicates : Remove duplicate rows
• --normalize-whitespace : Normalize whitespace in all columns
• --standardize-case : Standardize text case (upper, lower, title, sentence)
• --fill-missing : Fill missing values (empty, mode, mean, median, custom)
• --fill-value : Custom value for missing data
• --remove-empty-rows : Remove rows with high empty cell percentage
• --output, -o : Output file for cleaned data
• -v : Verbose mode
• --classic : Use classic plain text formatting

🎨 Rich UI Integration

CSVise features beautiful Rich-powered CLI output:

• Color-coded Tables: Data types are color-coded (integers in green, floats in yellow, booleans in magenta)
• Information Panels: File statistics and validation issues in styled panels
• Progress Indicators: Visual feedback during data processing
• Enhanced Messages: Beautiful error and success message formatting
• Type Highlighting: Automatic highlighting of data type mismatches

Modes:

• Rich Mode (--rich): Enhanced visual experience with colors and panels [default]
• Classic Mode (--classic): Traditional plain text output for compatibility

---

📖 Documentation

Command Reference

Global Options

• --help : Show help and documentation
• --version : Display current version

Custom Delimiter Example

csvise display data.csv --delimiter ";"

Configuration

Customize default behavior with csvtoolsConfig.json:

{
    "additional_delimiters": ["|", ";", "###"],
    "start_index": 1,
    "num_rows_to_print": null,
    "display_column_lines": true,
    "display_row_lines": false,
    "check_type_mismatches": true,
    "string_case": "default"
}

Examples

Rich UI Examples

# Beautiful table with validation
csvise display data.csv --debug

# Analysis with correlations
csvise analyze data.csv --correlations

# Clean data with progress feedback
csvise clean data.csv --remove-duplicates --normalize-whitespace

Classic Mode Examples

# Plain text output for scripts
csvise display data.csv --classic --debug

# Classic analysis output
csvise analyze data.csv --classic --outliers

Data Analysis Examples

# Comprehensive analysis
csvise analyze data.csv --correlations

# Analyze specific columns
csvise analyze data.csv --columns "Age,Salary,Department"

# Detect outliers
csvise analyze data.csv --outliers

# Show distributions
csvise analyze data.csv --distribution

Data Cleaning Examples

# Basic cleaning
csvise clean data.csv --remove-duplicates --normalize-whitespace

# Advanced cleaning pipeline
csvise clean data.csv \
    --remove-duplicates \
    --normalize-whitespace \
    --standardize-case title \
    --fill-missing mode \
    --output cleaned_data.csv

# Remove empty rows
csvise clean data.csv --remove-empty-rows 0.5 --output cleaned.csv

Example Output

[VERBOSE] Detecting delimiter from sample row: Name,Age,Occupation
[VERBOSE] Delimiter detected: ,
[VERBOSE] Detected columns: ['Name', 'Age', 'Occupation']

  | Name      | Age       | Occupation  
--------------+-----------+-------------
1 | Alice     | 30        | Engineer   
2 | Bob       | 25        | Designer   
3 | Charlie   | Manager   |             
4 | Diana     | 28        | 7          
5 | Edward    | 40.5      | Developer  
6 | Frank     | 20        | Student    
7 | George    | 45        | Retired    

ROWS WITH INCORRECT LENGTH:
Row 3 is of length 2, expected 3

ROWS WITH POTENTIAL TYPE MISMATCHES:
Row 3, Column 2: Found str, expected int
Row 4, Column 3: Found int, expected str

Total number of rows with incorrect length: 1
Total number of type mismatches: 2

---

🔧 Development

Setup Development Environment

git clone https://github.com/rawsabsaid/csvise-cli-tool.git
cd csvise-cli-tool
pip install -e ".[dev]"

Run Tests

pytest tests/

Code Quality

# Format code
black csvtools/

# Check linting
flake8 csvtools/

# Type checking
mypy csvtools/

Build Package

python -m build
twine check dist/*

---

📄 License

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

---