Challenge No. 139: Prepare the Result table.
Solved using: DAX.
VSTACK
Stacks arrays vertically into a single column in Excel.
Assign Groups to Value Bins
Challenge No. 135: Generate the result table which is as per bin size.
Solved using: R.
Meter Reading Consumption Split
Challenge No. 133: Find out the electricity consumption for all 3 meters for given dates.
Solved using: R.
People Connection!
Challenge No. 200: In the question table, direct connections between people are provided.
Solved using:Excel (IF, IFNA, INDEX), Power Query (List.Transform, Text.End), Python, Python in Excel, and R.
Create half-yearly sorted table from data
Challenge No. 340: From dataset in column A, create the table under Answer Expected.
Solved using: Python in Excel.
Matrix Calculation! Part 2
Challenge No. 198: Create a formula that, for any ‘n x n’ matrix, calculates z1 to zn, where zi is the sum of all the values in the ith row and the ith column of the matrix.
Solved using:Excel (BYCOL, INDEX, LAMBDA), Google Sheets, Power Query (List.Transform, Table.FromRows, Table.ToColumns), Python, Python in Excel, and R.
Column Splitting! Part 6
Challenge No. 196: Split the ID into two columns:
The first column should contain all letters.
Solved using:Excel (CONCAT, HSTACK, LAMBDA), Google Sheets, Power Query (List.Transform, Text.Select, Table.AddColumn), Python, Python in Excel, and R.
Find Min and Max for all zones
Challenge No. 332: Find the Max and Min for all Zones.
Solved using: Python in Excel.
Find the first 50 Iccanobif numbers
Challenge No. 329: Find the first 50 Iccanobif numbers.
Solved using: Python.
Pattern Length!
Challenge No. 194: For each date, samples are evaluated based on quality and marked with a “+” sign if they are within range and a “-” sign if they are out of range.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Remove, Text.Split), Python, Python in Excel, and R.