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