Challenge No. 248: Transpose the problem table into result table.
Solved using: Python.
⭐️⭐️ Easy
Slightly challenging problems for learners.
For each Deal, list the
Challenge No. 246: For each Deal, list the name of the persons who handled the deal most recently.
Solved using: Python.
Five-Weekend Month Finder
Challenge No. 541: List the months and years having 5 Fridays, 5 Saturdays and 5 Sundays in a month for the years 2000 to 2999.
Solved using: Python in Excel.
Compute Average Supplier Price
Challenge No. 539: Table1 gives the Items, Suppliers and per unit rate for different band of quantities.
Solved using: Python in Excel.
Find Min Product of Three
Challenge No. 537: Find the minimum product which results from multiplying any 3 numbers from N1 to N6.
Solved using: Python in Excel.
Reformat Item Entries
Challenge No. 242: Transform the problem table into result table as shown.
Solved using: Python.
Draw Symmetric Star in ASCII
Challenge No. 533: Draw ASCII star for given N which is an odd number for the purpose of symmetry.
Solved using: Python in Excel.
Spread Yearly Rows to Columns
Challenge No. 240: Transpose the problem table into result table as shown.
Solved using: R.
Rank Sales Drop Per Person
Challenge No. 239: Transpose the problem table into result table and calculate the drop in sales amount from one quarter to previous quarter.
Solved using: Python.
Fill Blanks with Column Index
Challenge No. 237: Fill in the blanks / nulls with column name_1, 2, 3.
Solved using: Python.