Challenge No. 163: Extract the valid vehicle registration numbers from given data table T2.
Solved using: R.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
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.
Form Shortest Palindromic Prefix
Challenge No. 391: Find the smallest Palindromes (in length) which can be formed by adding English alphabets before string.
Solved using: Python in Excel.
Digits With Sum Equal to Length
Challenge No. 390: Find the min, max and count of n digit numbers where n = sum of digits
Ex.
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.
Kamasutra Cipher with Digits
Challenge No. 388: Kamasutra Cipher 2 – Generate 13 random pairs from English alphabets and 5 random pairs from 0-9 digits and use that to encrypt the plain text.
Solved using: R.
Pilot Flight Rest Hours
Challenge No. 153: This time this problem will appear on both Sat and Sun with variations.
Solved using: Python in Excel.
Fruit Pair Frequency Grid
Challenge No. 148: Generate the grid shown where count need to be populated at intersections of rows and columns.
Solved using: Python.
Increment Number at Word End
Challenge No. 363: If any word contains numbers at the end of the word, add 1 to that number.
Solved using: Python in Excel.
Employee Count in Intervals
Challenge No. 142: Generate the time series between 9AM to 9PM at 15 minutes interval.
Solved using: R.