HSTACK Archives - Page 12 of 39

Max Frequency Characters

Challenge No. 487: Find the characters whose frequency is the maximum and also find the maximum frequency.
Solved using: Excel VBA.

Challenge No. 212: Find the total commission of each sales person and sort it descending on total amount.
Solved using: Python.

Challenge No. 211: Append the groups one below the other and sort on Income descending, Name ascending within each group.
Solved using: R.

Challenge No. 483: Generate a 20×20 matrix as given through a formula.
Solved using: Python in Excel.

Challenge No. 482: Prepare the given matrix from problem table.
Solved using: Python in Excel.

Challenge No. 210: Populate the From and To Date based on type of leaves for a person.
Solved using: Python.

Challenge No. 209: Populate the End dates against all owners in a pivot format as shown.
Solved using: Python.

Challenge No. 478: Merger the tables into a single table.
Solved using: Python.

Challenge No. 477: Align the data as shown which is 1 record, then 2 records, then 3 records and so on.
Solved using: Python in Excel.

Challenge No. 207: Generate the result table from problem table.
Solved using: Python in Excel.