Challenge No. 671: Find the pair of words which together contain all 5 vowels.
Solved using: Python in Excel.
Transpose Table With Profit
Challenge No. 670: Transpose the table as shown.
Solved using: Python.
First Ten Tech Numbers
Challenge No. 669: Tech Number – A number is a tech number if it has even number of digits and square of sum of first half and last half is equal to number itself.
Solved using: R.
Draw Alphabet Z Pattern
Challenge No. 668: Create alphabetic Z for N values as shown.
Solved using: Python.
Pivot Data To Columns
Challenge No. 667: Pivot the data as shown.
Solved using: Python.
Fill Missing With Average
Challenge No. 666: Fill in the blanks with (Total – Sum of non Blanks Values)/Number of Blanks
Hence for row 3: (580-(170+150))/1 = 260
For row 7: (440-90)/2 = 175
For row 9: (360-0)/3 = 120.
Solved using: Python.
Bi And Trimorphic Numbers
Challenge No. 665: Bi & Trimorphic Numbers – List numbers (n<100000) if n^3 and n^2 both end with n. Solved using: Python.
Track Quality Test Rounds
Challenge No. 664: After 3 rounds of quality testing, list the remaining batches from Round0 after each Round.
Solved using: Python in Excel.
Pivot Hierarchical Sublevels
Challenge No. 663: Pivot the data as shown.
Solved using: Power Query.
Matrix Transformation Series
Challenge No. 661: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Converts the T1 matrix to a T2 matrix and the T2 matrix to a T3 matrix.
Solved using: Excel.