Challenge No. 161: For each group, find the maximum occurring Winning numbers within a period of 7 weeks .
Solved using: Python in Excel.
Missing Values
Handling and filling missing values in datasets using different strategies.
Fill Missing Months Default
Challenge No. 159: For a give name and year combination, if a month is missing between 1 and 12 then enter that month number with a default sales of 100.
Solved using: Python in Excel.
Find Missing Letters in Range
Challenge No. 353: Find the missing letters.
Solved using: R.
Missing Characters!
Challenge No. 195: In the ID column, the text should follow the format XX/XX/XX/XX (with a ‘/’ after every two characters).
Solved using:Excel (IF, LAMBDA, LEN), Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Find missing terms in arithmetic progressions
Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.
Identify Missing Brackets
Challenge No. 289: There are 3 types of Parentheses (brackets) – ( ), { }, [ ].
Solved using: Python in Excel.
Recover Missing Cipher Keys
Challenge No. 253: NOTE – Order in answer is not important.
Solved using: Power Query (Text.Combine).
Find Missing Letters in Order
Challenge No. 193: Listed are the strings where letters are in increasing order.
Solved using: Power Query.
Fill Arithmetic Progression
Challenge No. 182: Find the missing numbers in Arithmetic Progressions given.
Solved using: Python in Excel.
Find Missing Alphabets
Challenge No. 172: Find the missing English Alphabets from First Ladies column.
Solved using: Power Query.