.. The Creative L.A.W. documentation master file, created by sphinx-quickstart on Mon Dec 25 12:02:18 2023. You can adapt this file completely to your liking, but it should at least contain the root `toctree` directive. Software & Other Technology ============================= Digital Calligraphy ---------------------- Moonwalk VR ----------------- Excel to JSon Converter --------------------------- This is a command-line tool to convert an Excel sheet to a JSon file. The Excel sheet must follow some rules to be correctlly parsed. Sum-up for .csv data ------------------------ This is a command-line tool to analyse data in .csv format. It will group by some fields, and sum and count on 1 field. .. py:function:: usage: csvsum [-h] [--groupby GROUPBY] [--field FIELD] [--condition CONDITION] input_file Group columns of .csv file, and return sum and count. positional arguments: :param input_file: File name of the .csv file. Can be full path or relative path. required arguments: :parameter - - groupby: Comma-separated list of fields to group by :parameter - - field: Name of the field to sum up optional arguments: :parameter - - help: show this help message and exit :parameter - - condition: Condition. e.g. field==0 Example: **csvsum "C:\Users\Alex\Documents\02_test\polylines2.csv" --groupby Layer --field length --condition order==0** =========== ============== ========= Layer sum count =========== ============== ========= 0 0.748063 1 INV 229.691672 1 COMMS 825.810820 83 ELEC (GEN) 323.076651 21 ELEC (HV) 427.220782 15 =========== ============== ========= Dataframes written to C:\Users\Alex\Documents\02_test\stats_polylines2.xlsx The output sheet contains a "stats" sheet, which has summary and counts, and a "details" sheet of the original data with auto-filter. Backtest for Crypto Futures ------------------------------- This is a framework to backtest some algorithms to trade crypto futures.