$data = Import-Csv .\employees.csv Filters objects based on a condition.
$data | Where-Object $_.YearsOfExperience -ge 2 Sorts by one or more properties. powershell 3 cmdlets hackerrank solution
# PowerShell 3+ Template $inputFile = ".\data.csv" $requiredYears = 2 $topN = 3 Import-Csv $inputFile | Where-Object [int]$ .YearsOfExperience -ge $requiredYears | Sort-Object [int]$ .Salary -Descending | Select-Object -First $topN | Group-Object Department | Select-Object @Name="Department"; Expression=$ .Name, @Name="AverageSalary"; Expression= [math]::Round(($ .Group | Sort-Object Department $data = Import-Csv
$data = Import-Csv .\employees.csv Filters objects based on a condition.
$data | Where-Object $_.YearsOfExperience -ge 2 Sorts by one or more properties.
# PowerShell 3+ Template $inputFile = ".\data.csv" $requiredYears = 2 $topN = 3 Import-Csv $inputFile | Where-Object [int]$ .YearsOfExperience -ge $requiredYears | Sort-Object [int]$ .Salary -Descending | Select-Object -First $topN | Group-Object Department | Select-Object @Name="Department"; Expression=$ .Name, @Name="AverageSalary"; Expression= [math]::Round(($ .Group | Sort-Object Department