Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.
Indexing & Ranking
Creating indexed/ranked lists in datasets.
Sum Between Plus Groups
Challenge No. 640: Treat the data between two pluses as one group.
Solved using: R.
Rank Cities by Percent Change
Challenge No. 615: List the top 3 cities where sum of %change from 2020 to 2021 and 2021 to 2022 is the highest.
Solved using: Python.
Reapply Original Capitalization
Challenge No. 594: Work out the indexes where capital letters are.
Solved using: Python in Excel.
List Consecutive Streak Indexes
Challenge No. 590: If there are more than one consecutive streaks of H or T, then list the Indexes of those.
Solved using: Python in Excel.
Pick top N by group
Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.
Sort Odd Position Values
Challenge No. 574: Keep the numbers in even positions as it is and sort the numbers in odd positions.
Solved using: R.
Rank stores by percentage of
Challenge No. 263: Table 1 (T1) has got customer satisfaction responses and Table 2 (T2) has got color coding of those responses.
Solved using: Python.
Swap Letters by Index Pair
Challenge No. 570: For a given string, interchange the alphabets by swapping positions given in Numbers column.
Solved using: Python in Excel.
Rank Players by Uppercase
Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.