Challenge No. 567: Draw an ASCII house as given.
Solved using: Python in Excel.
Assign Fruits to Tiers
Challenge No. 566: Populate Fruits1, Fruits2 and Fruits3 against fruits beneath the counts.
Solved using: Python.
Reversed Even Perfect Squares
Challenge No. 565: Find first 50 numbers where both the number and its reversed number are
– Even
– Perfect squares
Ex.
Solved using: Python in Excel.
List the fruits and the
Challenge No. 259: List the fruits and the sum of total amount against a fruit.
Solved using: Python in Excel.
Sort Only Numeric Columns
Challenge No. 564: Sort the columns where only numbers will be sorted and non-numbers will not be sorted.
Solved using: R.
Count Bands by Product Range
Challenge No. 563: List the products, range of numbers along with the count of bands (not count of product).
Solved using: Python.
Generate the result table from
Challenge No. 256: Generate the result table from problem tables.
Solved using: R.
Palindrome One-Child Numbers
Challenge No. 562: One Child Palindromes – Find all unique substrings of a number excluding 0 and if one and only one substring is divisible by the length of the number, then this is called One Child number.
Solved using: Python.
Maximum Profit from Transactions
Challenge No. 561: For each row, you need to buy first and sell second.
Solved using: Python in Excel.
Find Vowels Between Consonants
Challenge No. 560: Locate the vowels which are between two consonants.
Solved using: Python.