Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.80 KB | None | 0 0
  1. $InStuff = Import-Csv 'M:MyDocscriptlogfilesOutput_18Marstreams_E1WAF2_OUTPUT.csv'
  2. $TargetPropertyList = $InStuff[0].PSObject.Properties.Name.Where({$_ -ne 'TimeStamp'})
  3.  
  4. $GroupedInStuff = $InStuff |
  5. Group-Object -Property TimeStamp
  6.  
  7. $Results = foreach ($GIS_Item in $GroupedInStuff) {
  8. $HighestValues = [ordered]@{
  9. TimeStamp = $GIS_Item.Name
  10. }
  11. foreach ($TPL_Item in $TargetPropertyList) {
  12. $TempHiVal = [Math]::Round(($GIS_Item.Group.$TPL_Item.ForEach({[int]$_}) | Measure-Object -Average).Average)
  13. $HighestValues.Add($TPL_Item, $TempHiVal)
  14. }
  15.  
  16. [PSCustomObject]$HighestValues
  17. }
  18.  
  19. $Results = $Results | Sort-Object -Property {[DateTime]$_.TimeStamp}
  20.  
  21. $InStuff = Import-Csv 'M:MyDocscriptlogfilesOutput_18Marstreams_E1WAF2_OUTPUT.csv'
  22. $TargetPropertyList = $InStuff[0].PSObject.Properties.Name.Where({$_ -ne 'TimeStamp'})
  23.  
  24. $GroupedInStuff = $InStuff |
  25. Group-Object -Property TimeStamp
  26.  
  27. $Results = foreach ($GIS_Item in $GroupedInStuff) {
  28. $HighestValues = [ordered]@{
  29. TimeStamp = $GIS_Item.Name
  30. }
  31. foreach ($TPL_Item in $TargetPropertyList) {
  32. $TempHiVal = [Math]::Round(($GIS_Item.Group.$TPL_Item.ForEach({[int]$_}) | Measure-Object -Average).Average)
  33. $HighestValues.Add($TPL_Item, $TempHiVal)
  34. }
  35.  
  36. [PSCustomObject]$HighestValues
  37. }
  38.  
  39. $Results = $Results | Sort-Object -Property {[DateTime]$_.TimeStamp}
  40.  
  41. , 2
  42.  
  43. $csv = import-csv C:temptest.csv
  44. $Averages = New-Object System.Collections.ArrayList
  45.  
  46. Foreach($object in ($csv | Group-Object timestamp)) {
  47.  
  48. $Averages.Add([pscustomobject]@{
  49. timestamp = $object.Name
  50. abc = ($object.group | Select-Object -ExpandProperty abc | Measure-Object -Average).Average
  51. a = ($object.group | Select-Object -ExpandProperty a | Measure-Object -Average).Average
  52. b = ($object.group | Select-Object -ExpandProperty b | Measure-Object -Average).Average
  53. c = ($object.group | Select-Object -ExpandProperty c | Measure-Object -Average).Average
  54. d = ($object.group | Select-Object -ExpandProperty d | Measure-Object -Average).Average
  55. e = ($object.group | Select-Object -ExpandProperty e | Measure-Object -Average).Average
  56. f = ($object.group | Select-Object -ExpandProperty f | Measure-Object -Average).Average
  57. g = ($object.group | Select-Object -ExpandProperty g | Measure-Object -Average).Average
  58. })
  59. }
  60.  
  61. PS H:> $Averages
  62.  
  63.  
  64. timestamp : 6/4/2019
  65. abc : 6811.33333333333
  66. a : 3129
  67. b : 10.6666666666667
  68. c : 2680
  69. d : 1522.66666666667
  70. e : 1184
  71. f : 0
  72. g : 9.33333333333333
  73.  
  74. timestamp : 6/5/2019
  75. abc : 6783.33333333333
  76. a : 3098
  77. b : 6.66666666666667
  78. c : 2698.66666666667
  79. d : 1320
  80. e : 686.666666666667
  81. f : 0
  82. g : 1.33333333333333
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement