Skip to content

Latest commit

 

History

History
37 lines (27 loc) · 1.41 KB

README.md

File metadata and controls

37 lines (27 loc) · 1.41 KB
Raw

Ctrl+Alt+Defeat_WEB

WEB - CSVizard : Command Line Tool for performing transformations on CSV files.

Basic video demo: https://drive.google.com/file/d/15p63P-F6fwKmx65y7zTLWKAvPBrb5iQG/view?usp=sharing

To run the CLI app

pip install -r requirements.txt
python -m csvizard

Technologies Used

  • Python
  • Typer
  • Rich
  • Pandas
  • csv

List of Implemented Features

  • Implemented an aesthetic UI with an elegant interface
  • CLI app that inputs CSV files performs user-specified transformations like filtering, joining, aggregating, and outputs the transformed data to a new CSV file
  • Input: The CLI accepts one or more CSV files as input through interactive prompts
  • Filtering: Selecting specific rows based on criteria like column values
  • Joining: Merging data from multiple CSV files based on the common columns.
  • Aggregating: Performing calculations like sum, average, minimum, or maximum on numerical columns.
  • The transformed data is written to a new CSV file
  • Handling different CSV formats: The CLI handles variations in CSV files, such as delimiters and quoting styles
  • Error handling: The tool gracefully handles errors like invalid file paths, missing columns, or out of bound indexes, data type checking during transformation

Resources