PSelect

A SQL-ish DSL in PowerShell to assist in aggregating collections of data.

Example - FromPipeline

Get-Process | PSelect {
    Field ProcessName
    Field WorkingSet -as Count -Count
    Field WorkingSet -Sum
    
    GroupBy ProcessName

    SortData
}

ProcessName                           Count WorkingSet
-----------                           ----- ----------
ApplicationFrameHost                      1   27492352
AppVShNotify                              1    7405568
armsvc                                    1    5464064
audiodg                                   1   18952192
BleServicesCtrl                           1    9011200
bmservice                                 1   46051328
chrome                                   25 1875648512
Code                                      7  357859328
CodeHelper                                1   13967360
conhost                                   7   38752256
csrss                                     2   16859136
dasHost                                   1   10018816
DataExchangeHost                          1   12623872
dllhost                                   3   26742784
...

Example - FromCsv

PSelect {
    Field category
    Field raisedAmt -as AvgRaisedAmt -Average -Unit Currency
    Field raisedAmt -as TotalRaisedAmt -Sum -Unit Currency
    Field raisedAmt -as MaxRaisedAmt -Maximum -Format "{0:N}"
    Field raisedAmt -as MinRaisedAmt -Min -Format "{0,13:C}"
    Field raisedAmt -as SDRaisedAmd -StdDev -Format "{0:f}"
    Field raisedAmt -as Rounds -Count
    
    GroupBy category
    
    FromCsv TechCrunchcontinentalUSA.csv

    SortData

} | Format-Table -AutoSize

category   AvgRaisedAmt   TotalRaisedAmt     MaxRaisedAmt   MinRaisedAmt  SDRaisedAmd Rounds
--------   ------------   --------------     ------------   ------------  ----------- ------
           $15,554,166.67 $373,300,000.00    150,000,000.00   $900,000.00 29888793.60     24
biotech    $19,312,500.00 $77,250,000.00     37,000,000.00    $250,000.00 13920954.30      4
cleantech  $18,492,857.14 $258,900,000.00    57,000,000.00  $1,000,000.00 14340525.21     14
consulting $6,427,000.00  $32,135,000.00     13,000,000.00     $10,000.00 5576451.92       5
hardware   $21,141,025.64 $824,500,000.00    130,000,000.00   $100,000.00 25244059.65     39
mobile     $6,729,583.33  $323,020,000.00    25,000,000.00     $20,000.00 5752943.80      48
other      $7,490,625.00  $119,850,000.00    29,000,000.00    $300,000.00 6911092.05      16
software   $9,979,823.53  $1,017,942,000.00  60,000,000.00     $10,000.00 10046611.33    102
web        $9,739,300.29  $11,765,074,750.00 300,000,000.00     $6,000.00 19034496.45   1208