#foo.csv
No, Fruit, Quality, Units, Location
1, Orange, New, 10, Village
2, Orange, Fresh, 20, City
3, Apple, New, 15, Village
4, Grapes, Fresh, 25, City
5, Apple, Fresh, 30, City
6, Apple, Fresh, 35, City
有了这些数据我想在下面的方式输出:
水果| 位置| 品质| 单位
我无法进一步对(子组?)数据进行分组,以下是我自带的数据,但不是我所需要的:
Import-Csv "E:\foo.csv" |
Group-Object { $_.Fruit } |
Select-Object -Property Count,
@{ Name = 'Fruits'; Expression = { $_.Name } },
@{ Name = 'Location'; Expression = { ($_.Group | Measure-Object -Property Units -Sum).Sum } } |
Export-Csv new.csv -NoTypeInformation
我进一步尝试:
Import-Csv "E:\foo.csv" |
Group-Object { $_.Fruit } |
Select-Object -Property Count,
@{ Name = 'Fruits'; Expression = { $_.Name } },
@{ Name = 'Location'; Expression = { $_.Location } },
@{ Name = 'Quality'; Expression = { $_.Quality } },
@{ Name = 'Units'; Expression = { ($_.Group | Measure-Object -Property Units -Sum).Sum } } | Sort-Object -Property Count | Format-Table -Auto
但是数据是空白的。
您可以同时按多个属性分组:
Import-Csv "E:\foo.csv"|
Group-Object Fruit,Location,Quality|
Select-Object @{Name='Fruit' ;Expression={$_.Values[0]}},
@{Name='Location';Expression={$_.Values[1]}},
@{Name='Quality' ;Expression={$_.Values[2]}},
@{Name='Units' ;Expression={
($_.Group|Measure-Object Units -Sum).Sum
}}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句