Challenge No. 413: Pivot the given data with headers suffixed with 1, 2.
Solved using: Python.
Custom Grouping
Challenges related to custom data grouping.
Department Totals and Summary
Challenge No. 165: Insert the total row containing count of employees and sum of salary at the bottom of each dept groups.
Solved using: R.
Winning Numbers Weekly Range
Challenge No. 161: For each group, find the maximum occurring Winning numbers within a period of 7 weeks .
Solved using: Python in Excel.
Encrypt Words with Tri Numeral Cipher
Challenge No. 397: Tri Numeral Alphabet Cipher – English alphabets are divided into groups containing 3 alphabets each and last group contain only 2 alphabets i.
Solved using: Python in Excel.
Log Changes Within Group
Challenge No. 157: Except the Group column, for every other column, log the value within a group if value changes.
Solved using: R.
Boundary Rows per Threshold
Challenge No. 146: For a group –
List the last row where value < Threshold
and also list the first row where value > Threshold
If more than one row meets the criterion, then capture all those rows.
Solved using: Python in Excel.
Split Group and Track Running
Challenge No. 144: Divide the data set for a group in 2 halves.
Solved using: Python in Excel.
Map Groups to Company
Challenge No. 137: Generate result table on the basis of 2 problem tables.
Solved using: Python in Excel.
Detect Common Groups by ID
Challenge No. 136: Find the common groups on the basis of common IDs.
Solved using: R.
Find Longest Consecutive Sequence
Challenge No. 347: List the largest group of consecutive numbers in each column.
Solved using: R.