Split.py

A small program to split any excel workbook (csv or xlsx) into smaller workbooks based on values in different coloumns.

It is just a helpful script that I use almost everyday. I also attempted to develop it through TDD. I hope it assists someone else.

Requirements

1. Python 3.*
2. Pandas
3. Termcolor

Install requirements:

pip3 install pandas termcolor

How to run it

python3 split.py example.csv
python3 split.py example.xlsx