DamianCalin/SQLOperators

Provide the simplicity of SQL in Wolfram language

Contributed By: Damian Calin

Being able to express SQL like queries in Wolfram Language:

Installation Instructions

To install this paclet in your Wolfram Language environment, evaluate this code:
PacletInstall["DamianCalin/SQLOperators"]

Details

See guide section

Paclet Guide

Examples

Basic Example

Using groupBySQL/summarySQL:

In[1]:=
    sampledataSQL //
     groupBySQL[# , {symbol} ] & //
  summarySQL [# ,  Association["maxclose" :> (close // Max) ,
     						"minclose" :> (close // Min) ,
     						"count" :> (close // Length) ,
     						"histogram" :> (close // Histogram)  ,
     						"dateplot" :>  (Thread[{time, close}] // DateListPlot) ,
     						"boxplot"  :> BoxWhiskerChart[close ] ]
    		] & //
     showTableSQL
Out[1]=

For more examples see guide section or https://community.wolfram.com/web/damcalrom/home

Publisher

Damian Calin

Compatibility

Wolfram Language Version 13.

Version History

  • 1.0.1 – 22 September 2022
  • 1.0.0 – 22 September 2022

License Information

MIT License

Paclet Source