Challenge No. 280: List the Teams which have never lost even a single game.
Solved using: Python in Excel.
CHOOSECOLS
Returns specific columns from an array in Excel.
Top Player by Group Average
Challenge No. 197: List the qualifying player from each group on the basis of
1.
Solved using: Power Query (Table.AddColumn).
Final Week Of The Month!
Challenge No. 134: From the “transactions” in the provided table, filter those that occurred in the last 7 days of the month.
Solved using:Excel (CHOOSECOLS, DAY, EOMONTH), Google Sheets, Power Query (Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and SQL.
Add Index Column! Part 2
Challenge No. 116: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (CHOOSECOLS, CHOOSEROWS, COLUMN), Google Sheets, Power Query (List.Alternate, Table.AlternateRows, Table.Column), Python, Python in Excel, and R.
Matching Tables!
Challenge No. 107: In a survey, 10 questions were asked to both
a manager and an expert, and they responded
to some of them.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Google Sheets, Power Query (List.PositionOf, List.Transform, Table.AddColumn), Python, Python in Excel, and R.
Custom Average!
Challenge No. 103: Today is 20/08/2024, and we’re calculating the average delivery time per product in days.
Solved using:Excel (AVERAGE, CHOOSECOLS, FILTER), Google Sheets, Power Query (Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Region-Year with Max Growth
Challenge No. 87: Find the Region and Year where and when the growth was the highest.
Solved using: DAX.
Top 5 Goal Scoring Teams
Challenge No. 75: — This week will be FIFA World Cup week.
Solved using: SQL.
Avg Interval Between Wins
Challenge No. 74: — This week will be FIFA World Cup week.
Solved using: SQL.
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.