Fyrefly

A quant-based library to compute mathematical operations and run SQL queries on your data.

Installation

pip install fyrefly

Usage — Math functions

from fyrefly import add, mul, div, mod

add(5, 4, 6, 10)     # 25
mul(5, 4, 6, 10)     # 1200
div(100, 5, 2)       # 10.0
mod(17, 5)           # 2

Each function accepts any number of arguments:

add(1)                # 1
add(1, 2, 3, 4, 5)    # 15
mul()                  # 1 (identity)

Usage — Data functions

from fyrefly import load, loadh, loadc, loads, sql, xtract

c = load("data.csv")                 # loads a CSV/Excel/Google Sheet, previews it
loadh(c)                             # preview column headers
loadc(c)                             # preview record count
loads(c)                             # preview schema (columns + datatypes)

d = sql("select * from c where age > 30")   # run ANY SQL query on loaded data
xtract(d)                                    # export the result to CSV
xtract(sql("select * from c"), filename="all.csv")  # chained form also works

Functions

Development

pip install -e ".[dev]"
pytest

License

MIT