rjj 0.0.8

rjj (read-joint-jet) is a simple cmd-based data analysis/transforming tool

rjj (read-joint-jet)

rjj is a simple cmd-based data transforming/analysis tool

install it via pip/pip3

pip install rjj

update rjj

pip install rjj --upgrade

check current version

rjj -v

read user manual

rjj -h

convertor

convert json to csv; select a json file in the current directory, then give a name to the output file (don't need the extension)

rjj c

detector

detect the co-existing record(s) between two csv files; select two csv files to execute the detection process, then assign a name for the output file; co-existing record(s) will be indicated in a newly created column Coexist

rjj d

jointer and splitter

joint or split your data file(s)

jointer

joint all csv files in the current directory together; all file names will be stored in the first field of the newly created column File; when you execute the command you will be asked for assigning a name for the output file

rjj j

splitter

split the selected csv file to different csv files and name it according to the value in the first field of that selected file

rjj s

xplit

split the selected excel (.xls or .xlsx) to pieces and name it according to the value in the first field of that selected excel

rjj x

joint

joint all excels (.xls and .xlsx) in the current directory together*; all file names will be stored in the first field of the newly created column File; when you execute the command you will be asked for assigning a name for the output file

rjj t

*tips: this is different from csv jointer, since both .xls and .xlsx is accepted, and the file extention will not be taken, it will be merged while two of them share the same file name (cannot be split by the command above); so understand this condition, then make good use of it!