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.
- 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:UsersAlexDocuments02_testpolylines2.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:UsersAlexDocuments02_teststats_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.