Challenge No. 70: Consider a set of coin denominations as: {1$, 2$, 5$, 10$}.
Solved using:Excel (FILTER, LAMBDA, LET), Power Query (List.Transform, Table.FromRows), Python, R, and VBA.
⭐️⭐️⭐️⭐️⭐️Expert
Highly advanced challenges.
Assignment Problem (Part 2)!
Challenge No. 50: In the continuation of the previous challenge, we reach the question table as the normalized table, in the rest of the algorithm the below step should be done.
Solved using:Excel (AND, BYCOL, BYROW), Power Query (List.Transform, Table.Column), Python, and R.
Convert Number To Text!
Challenge No. 22: Convert the numbers in column B to the text like column H
.
Solved using:Excel, Power Query, and R.
Hierarchy Transformation
Challenge No. 20: The question table provides information about products, which are organized into three levels based on the length of their codes, and we want to transform this table into the result table wich each level is displayed in separate columns.
Solved using:Excel (FILTER, HSTACK, LEFT), Power Query (List.Transform), Python, and R.
Sudoku In Excel
Challenge No. 19: Solve the left side Sudoku table and replace X by a number based on the below rule:
Use the numbers 1 through 6 instead of X.
Solved using:Excel, Power Query, and VBA.
K-Means Clustering Algorithm!
Challenge No. 6: The k-means clustering algorithm is a popular method used in data science and machine learning for partitioning a dataset into k distinct, non-overlapping subsets (clusters) with the below steps.
Solved using:Excel, and Power Query.