Challenge No. 274: Problem Table1 contains the list of ingredients which can be used to prepare a dish.
Solved using: Python.
Table.SelectRows
Filters rows in a table based on a condition in Power Query.
Transpose the table as shown
Challenge No. 273: Transpose the table as shown.
Solved using: Python.
Pick top N by group
Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.
Transpose problem table into result
Challenge No. 249: Transpose problem table into result table.
Solved using: Python.
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.
List Subject Pass Students
Challenge No. 222: Marks for various tests are given in problem table.
Solved using: R.
Mark Completed Tasks Only
Challenge No. 218: Transpose the table as shown.
Solved using: Python in Excel.
Group by Income Then Sort
Challenge No. 211: Append the groups one below the other and sort on Income descending, Name ascending within each group.
Solved using: R.
Top 3 Closest City Pairs
Challenge No. 446: The distance between two cities is given in the grid.
Solved using: R.
Schedule and Cost Performance
Challenge No. 192: Convert the problem table into result table.
Solved using: Python.