EasyCsv

easycsv is an extremely fast command line CSV toolkit built using Rust. It provides a variety of powerful features to manipulate and analyze CSV files efficiently. With easycsv, you can filter rows, find data in specific columns using a custom query language, perform aggregations, and display results in multiple formats such as CSV and JSON. Additionally, easycsv can be seamlessly integrated with other Linux commands by using shell pipes.

Features

• Extremely Fast: Optimized for speed and efficiency.
• Filter Rows: Quickly filter rows from a CSV file based on specified criteria.
• Custom Query Language: Use a specialized language to find data in particular columns with support for =, !=, and ~ (contains) operators.
• Aggregation: Perform aggregations such as counting the number of rows and identifying duplicate entries in columns.
• Multiple Output Formats: Display results in CSV or JSON format.
• Command Line Integration: Easily integrate with other Linux commands by piping data.

Installation

Using Cargo

If you have Cargo installed on your machine, you can install easycsv directly from crates.io:

cargo install easycsv

Building from Source

To build easycsv from source, follow these steps:

1. Clone the repository:

   git clone https://github.com/ItsHyde-dev/easycsv.git
   

2. Navigate to the project directory:

   cd easycsv
   

3. Build the project:

   cargo install --path .
   

4. The compiled binary will be located in the target/release directory. You can add this directory to your PATH or move the binary to a directory that is already in your PATH.

Usage

Basic Usage

easycsv [OPTIONS] <CSV_FILE>

Examples

• Find data in specific columns:

  easycsv --find "name ~ 'John' and age != 25" data.csv
  

• Count rows:

  easycsv --count data.csv
  

• Count duplicate entries in columns:

  easycsv --dc "email" data.csv
  

• Display results in JSON format:

  easycsv --display-json data.csv
  

• Integration with other commands:

  cat data.csv | easycsv -f "name ~ 'Doe' or age = 30"
  

Options

• --find <CONDITION>: Filter rows based on the specified condition.
• --count: Count the number of rows in the CSV file.
• --dc <COLUMN>: Count duplicate entries in the specified column.

You can use easycsv --help for a detailed list of available options.

Contributing

Contributions are welcome! Please open an issue or submit a pull request on GitHub.

License

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

easycsv: The ultimate command line CSV toolkit for efficient data manipulation and analysis.