How to resolve the algorithm Top rank per group step by step in the Arturo programming language

Published on 12 May 2024 09:40 PM

How to resolve the algorithm Top rank per group step by step in the Arturo programming language

Table of Contents

Problem Statement

Find the top   N   salaries in each department,   where   N   is provided as a parameter. Use this data as a formatted internal data structure (adapt it to your language-native idioms, rather than parse at runtime), or identify your external data source:

Let's start with the solution:

Step by Step solution about How to resolve the algorithm Top rank per group step by step in the Arturo programming language

Source code in the arturo programming language

printTopEmployees: function [count, entries][
    data: read.csv.withHeaders entries
    departments: sort unique map data 'row -> row\Department
    loop departments 'd [
        print "----------------------"
        print ["department:" d]
        print "----------------------"
        loop first.n: count
            sort.descending.by:"Salary" 
                select data 'row [row\Department = d] 'employee ->
                    print [get employee "Employee Name" "->" employee\Salary]
        print ""
    ]
]

printTopEmployees 2 {
    Employee Name,Employee ID,Salary,Department
    Tyler Bennett,E10297,32000,D101
    John Rappl,E21437,47000,D050
    George Woltman,E00127,53500,D101
    Adam Smith,E63535,18000,D202
    Claire Buckman,E39876,27800,D202
    David McClellan,E04242,41500,D101
    Rich Holcomb,E01234,49500,D202
    Nathan Adams,E41298,21900,D050
    Richard Potter,E43128,15900,D101
    David Motsinger,E27002,19250,D202
    Tim Sampair,E03033,27000,D101
    Kim Arlich,E10001,57000,D190
    Timothy Grove,E16398,29900,D190
}


  

You may also check:How to resolve the algorithm Perfect shuffle step by step in the Scilab programming language
You may also check:How to resolve the algorithm Order disjoint list items step by step in the Wren programming language
You may also check:How to resolve the algorithm Read entire file step by step in the Smalltalk programming language
You may also check:How to resolve the algorithm Comments step by step in the Tcl programming language
You may also check:How to resolve the algorithm Formatted numeric output step by step in the AArch64 Assembly programming language