DamianCalin/ SQLOperators

Provide the simplicity of SQL in Wolfram language. For demos check: https://community.wolfram.com/web/damcalrom/home

Contributed by: Damian Calin

Installation Instructions

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


To load the code after installation, evaluate this code:
Needs["DamianCalin`SQLOperators`"]

Details

See guide section

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.4 – 29 November 2023
  • 1.0.3 – 23 November 2023
  • 1.0.2 – 26 September 2022
  • 1.0.1 – 22 September 2022
  • 1.0.0 – 22 September 2022

License Information

MIT License

Paclet Source