Challenge No. 88: In the question table, sales info is provided.
Solved using:Excel, Power Query, Python, R, and SQL.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Creating the Stem & Leaf Report
Challenge No. 1: Create a Stem & Leaf Plot
Strictly Legacy Array Functions or PowerQuery
NB:
A Stem and Leaf Plot is a special table where each data value is split into a “stem” (the first digit or digits) and a “leaf” (usually the last digit).
Solved using: Excel VBA.
Generate Pascal’s Triangle
Challenge No. 35: Provide a formula to create the triangle shown.
Solved using: Power Query.
Knn Missing Value!
Challenge No. 86: K-nearest neighbors (KNN) is a simple technique for replacing missing values with the average of the nearest values.
Solved using:Excel, Power Query, and VBA.
Custom Ranking!
Challenge No. 85: In the Question Table, values are provided and we want to rank them in ascending order based on custom logic.
Solved using:Excel (FILTER, HSTACK, IF), Power Query (List.Sort, List.Transform), Python, and R.
Apply Caesar Cipher with Shift
Challenge No. 26: Caesar’s Cipher – This is second challenge on Caesar’s cipher.
Solved using: Power Query.
Replace Words in Original Text
Challenge No. 9: (Excel formulas also welcome)
There is a table which has Original Text and there is another table which contains the list of words which need to be replaced.
Solved using: Power Query (List.Transform, Table.AddColumn, Table.ReplaceValue).
List Prime Numbers Only
Challenge No. 24: List all prime numbers from A2:A10.
Solved using: Python in Excel.
Total Distance!
Challenge No. 81: The distance between cities and staff travels are provided in the question distance and travel tables.
Solved using:Excel (DROP, IFNA, INDEX), Power Query (Table.AddColumn), Python, and R.
Extract Numbers and Sum Digits
Challenge No. 1: Extract the numeric digits from the given strings in a column and sum the digits for those extracted strings in another column.
Solved using: Power Query (Table.AddColumn).